Can't connect to SQL2000 instance on server with SQL2005

[hexOffender]

Hi, I just installed SQL 2000 on a server that was already running 2005. I created a new instance called SQL2K, and moved a database to the new instance. I cant seem to connect through my application to the instance. I am just using SQL authentication, with the user id and password coded in the connection string.

"data source=ServerName\SQL2k;Database=Patient Images; user id=user;password=password" .

I have tried telnetting to the sql instance and port, and I can connect that way. I have tried using the sa account and password in the connection string as well, but still not working.

I also tried to sety up a system DSN in ODBC, but the instance name does not appear in the dropdown list.

The connection error says "SQL server does not exist, or access is denied", if that helps.

 

[JayKusch]

Have you set up the 2000 login for the user/pass you have in your connection string?

Thanks

J. Kusch

 

[hexOffender]

Yes, i did... Actually I figured out that the 2005 wasn't using the default ports, so I just uninstalled 2000 and reinstalled it to be the default Instance. and that seems to make the application happy for some reason.

 

[mrdenny]

You would probably just need to enable the SQL Server Browser.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog