Microsoft SQL Server Error 10060

Asked

Viewed 414 times

3

I recently formatted my computer and reinstalled the applications. Among them SQL Server 2014. The problem is that I can’t connect to the provider’s server! I uninstalled the 2014 version and installed the 2012 and the problem persists. Only in my machine does that. No network problem as I can connect to the SQL of my internal server.

Does anyone have any idea?

sql
  • 1

    did you ever see this link? http://msdn.microsoft.com/pt-br/library/bb326282.aspx you need to disable pro SQL ports, you already did this?

  • Just so I understand: you want to connect on this server, which is your machine, through another machine. That’s it?

  • 1

    one more thing, as it says in the link itself... it is necessary to configure the server to accept remote connections

  • So I want to connect to the server that is located at the provider. I had seen this link, but the solutions presented do not solve my problem, because the provider is enabled to accept remote connection, because I can connect from any other machine, except this one.

  • Well, confirm that connection settings are correct in SSMS

  • The connection data is correct. I checked connecting from another machine. I typed and redacted 700x to see if there was no error... :(

  • Stupid question, enabled SQL protocols in Configuration Manager?

  • The protocols on the station are enabled and apparently on the server too, because if I can access from other stations...

Show 3 more comments

1 answer

1

According to the website of MSDN

An error occurred when establishing a connection to the server. When connecting to SQL Server, this failure can be triggered because, under the default settings, SQL Server does not allow remote connections. (provider: TCP provider, error: 0 - Failed connection attempt because the connected party did not respond correctly after a period or there was a connection failure established due to a failure in the connected host response). (Microsoft SQL Server, Error: 10060)

Browser other questions tagged sql

You are not signed in. Login or sign up in order to post.