I have a Windows 2003 Std R2 with one instance (default) SQL2000 STD and another instance (secondary) with SQL2005 STD, both instances using port 1433, firewall already configured.
I'm using the following string connection to access my server with ADO.NET 2.0:
server=mer02\dpm,1433;initial catalog=dpm;TrustServerCertificate=yes;Encrypt=yes;Connection Timeout=30;User=*******;Password=********
Well, I don't know why, but I have to specify port 1433, otherwise I'm not able to connect, I have tried to telnet to mer02 port 1433 and it answers OK, even if I use Sql Management Studio from a local pc I have to access with mer02\dpm,1433 otherwise it
takes sometime to return that the server may no be configured to accept remote connections.
Any ideas ?
Thanks in advance
View Complete Post