SQL server error

[Former Member]

Hi,

I'm running a develpment system - 4.6c on sql server 2000.I tried to detach the db files and got an error message that detaching failed - now i can't connect to my db - i get the following message on the entrerprise manager - a connection could not be established to (LOCAL).

Reason:cannot open user default database.login failed.please verify sql server is running and check your sql server registration properties and try again.

Can anyone assist?

Regards,

Moshe

[former_member193399]

Every login in SQL Server has a default database assigned. Login as "sa" and change the this default database to "master". This will allow you to login.

RT

Message was edited by:

R.T.

[Former Member]

could you pl check whether your SQL server is running and also check your default database stauts. check the error message in windows log viewer.

cheers,

-Sunil