0

I know there are 100's of article on this issue however in my case. I am able to connect to same instance of sql server from one machine on internet while not able to connect from another machine on internet using same credentials.

I am using SQL authentication.

TCP port are enabled, sqlbrowser service is running. Appropriate ports are added to firewall. All of these settings are checked on machine where SQL Server instance is hosted.

On Client Firewall is off, sqlbrowser service is running.

Shantanu Gupta
  • 20,688
  • 54
  • 182
  • 286
  • so your sql server TCP port is open and accessible from all IPs? is there any black or white listing in your firewall? – ughai May 05 '15 at 10:08
  • There are no such rules of blacklisting IP addresses. All IP address are invited until they have valid credentials. – Shantanu Gupta May 05 '15 at 10:10
  • Did a telnet work on that TCP port from the second client? – ughai May 05 '15 at 10:12
  • I don't know how to use telnet. I have to take a look into this. However I checked PING command and I am getting a reply from server. – Shantanu Gupta May 05 '15 at 10:14
  • possible duplicate of [Cannot connect to SQL Server named instance from another SQL Server](http://stackoverflow.com/questions/17029073/cannot-connect-to-sql-server-named-instance-from-another-sql-server) – Shantanu Gupta May 05 '15 at 13:49
  • For me, issue was with DNS. As soon as I changed my internet provider. Created mobile hotspot everything worked smoothly. – Shantanu Gupta May 05 '15 at 14:16

0 Answers0