Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kwisatz
Starting Member
14 Posts |
 Posted - 2008-11-18 : 06:02:16
|
| Hi allI currently have an issue when trying to connect to a named SQL instance on another (clustered) server on the network. The server uses dynamic ports.I have access to the SQL Server as if I logon to the target server I can register the instance.On my host server I can connect to the target server using the physical and cluster IPs followed by the port number.Furthermore the hostname of the cluster resolves correctly to the IP address of the cluster.When I try to connect using hostname\instancename or hostname\instancename, port the connection fails with :Specified SQL Server Not Found.I get the same error when using only hostname, port which is very confusing as I mentioned earlier the hostname resolves correctly to the IP address which connects sucessfully. If I understand dynamic ports correctly then specifying the port name negates the need for the global port.Its as though SQL is not passing the Hostname to the OS to be resolved. Please does anyone know what to check\do!!?Kind regardsKwis |
|
|
|
|
|
SQL Server Registration Problem