Monday, March 29, 2010

Connecting to an upgraded SQLServer

I had a database box with SQLServer2000 on it somewhere.  let's say the IP Address was www.xxx.yyy.zzz

I upgraded to sqlserver 2008.  Maybe I didn't upgrade, maybe I added a new instance who knows.  The old sqlserver2000 wasn't running and the new sqlserver2008 was.  On a different port.  My code connection strings became www.xxx.yyy.zzz/MSSQLSERVER2008

I was trying to connect to this new database for weeks using the SQL Management studio.  No dice.  Read all sorts of articles.  Made sure Remote Connections were enabled and that the SQL Browser service was running.

In order to connect to this database I had to enter the servername as:  www.xxx.yyy.zzz,PORT

so something like 333.444.555.666,4567

Worked like a charm.  Sucked when it didn't work and I had to log into Remote Desktop to do anything.

No comments:

Post a Comment