September 15, 2011 at 3:53 am
I'm giving following value for connection and its giving me error while connecting to SQL 2008. The same when running for SQL 2005, its working fine.
value="server=ServerName\Instancename,PortNumber;database=DatabaseName;uid=UserId;pwd=P@ssw0rd"
Error message:
"A network-related or instance-specific error occurred 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.)"
The remote connecitons are enabled and there is no issue with firewall.
September 15, 2011 at 4:55 am
sqlnaive (9/15/2011)
I'm giving following value for connection and its giving me error while connecting to SQL 2008. The same when running for SQL 2005, its working fine.value="server=ServerName\Instancename,PortNumber;database=DatabaseName;uid=UserId;pwd=P@ssw0rd"
Error message:
"A network-related or instance-specific error occurred 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.)"
The remote connecitons are enabled and there is no issue with firewall.
Let me try to re-produce the issue. You are on a server other than your SQL machine from where you are trying to connect. Are you able to do a 'telnet' to the SQL machine. telnet ip port is the format command. What do you see when you do it?
There are others things as well that you may want to check like 'tcp-ip' enabled, allowing remote connections etc.
Chandan
September 15, 2011 at 6:49 am
Yes Chandan. We were able to do telnet as well. Got the issue though. We tried connecting using FQDN and it worked. we used the server name as ServerName.DomainName.com. But we ignored the instance name with it to work. So it was not like ServerName.DomainName.com\InstanceName.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply