Does client connect to sql instance with same port? Is the port closed somewhere on your network?
Printable View
Does client connect to sql instance with same port? Is the port closed somewhere on your network?
If I create an alias on the client using port 1433, then they can connect fine. But if I leave it to dynamically determine ports it is not able to connect. I have asked the network people to monitor the traffic between the client & server to determine which ports are being hit on & whether any of them is blocked… thanks rmiao!
Have to open port 1434 if use dynamic port.
It's kind of a late post. If you have problems with connecting to a named instance of SQL Server, try to specify port in the connection string. E.g. server = "server1\instance1,1433"
Sergey
http://xrint.com