I have recently upgraded a database from SQL 2000 to SQL Express 2005. The DB name is Pds. I installed SQL Express 2005 along side SQL 2000, then I went in, detactched the DB from the old instance "SERVERNAME", and attached it to my new instance "SERVERNAME\SQLEXPRESS". The program that uses this database can access everything just fine, but now I cannot create an ODBC driver to connect to this database. When I attempt to connect via ODBC, I get this error:
SQL Server Error: 67
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect()).
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access is denied.
I've looked all over, but I figure out what's wrong here. I'm connecting via sa. What am I missing?