I've loaded the DB onto my local dev SQL2000 server and can connect to this DB just fine from the application. Now when I export this DB to the production server and attempt to connect the application to IT, I get the wonderful error above. I have checked over everything 20 times at LEAST. The user/login exists, and it has the proper permisisons/rights (ie. the same as I have on my dev server which is working).
Connection string for local machine which is working:
var MM_eDFMEAConnect_STRING = "Provider=SQLOLEDB;Data Source=ANNMIW40QZG31;User ID=eDFMEAuser;Password=password;Initial Catalog=PSCO_eDFMEA"
Connection string for remote production server (not working):
var MM_eDFMEAConnect_STRING = "Provider=SQLOLEDB;Data Source=marmissql01\auto_sql;User ID=eDFMEAuser;Password=password;Initial Catalog=PSCO_eDFMEA"
Can someone see something I am missing? or suggest something to try?