We have an existing application in ASP on a server that hits a SQL Server2000 database on the same server. To test few changes we wanted to use the development database for testing. So, we decided to use a remote development database server (SQL Server 2000). When i try and connect to that database using my application, i get the following error message:

************************************************** *******************
Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

/LM/W3SVC/1/Root/<application_name>/global.asa, line 29
************************************************** *******************

To test the applications with real production data, i had copied the production database's ".mdf" to the development server and attached the data files to the sql server.

While seaching through some forums i found that when the new databse is attached, old users need to be deleted and new ones need to be created. I did so, but i still get this error.

Any kind of urgent help is appreciated, as this has to go to testing ASAP.

Regards,
Sumit Bhatnagar

1) Check authentication mode,in sql server properties' security tab.
2) If it is windows try to change it to sql and windows mode.
3) Try with user sa and set password for sa user


urt

Help yourself by helping someone.