I have a problem. I am not able to connect to Remote SQL Server instances from my PC. Though some of my team members are able to connect to the Instances without any problem. We have tried with all the below options and no joy.
1. We tried connecting, with the IP Address, like IP\<ServerInstance>, Port#
2. Added the IP address to Host file with the network address and tried, like <WINServerName>.<networkaddress>\<ServerInstance>, Port#, even without the Port#.
3. Tried to create an ODBC DSN, why this because, this had resolved the issue some times. Thought will help, but didn't work out.
After all these, whenever we tried to connect to the server, we received the below error message.
Error Message :
Can not connect to <WINSERVER>.NetworkAddress\<DBInstance>
A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(Provider :TCP Provider, error:0 - No such Host is known) (Microsoft SQL Server, Error - 11001).
Kindly help to resolve this issue. I have been strugling since quite some time.
View Complete Post