Login failure 2

[micang]

SQL 2000

Hi All,

Sorry for vagueness. We have a desktop pc running SQL 2000 to hold data. Yesterday all was fine. This mornign I tried to login to the server and get "Cannot open user defined database. Login failure."

It won't connect to the server at all. I am new to SQL and would appreciate any guidance on what the next step is to try and solve this.

Many thanks in advance.

Michael

 

[mutley1]

George,

I believe you are correct with the authentication / logging on to database process of events.

Just in case you want to "un-fuzzy" yourself, here's the link:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;307864

I used to use a security tool called NGSSquirrel, and both that and something i read somewhere on MS website recommended that you don't have master as your default database, so the Security officer forced me to change mine but, alas, when the DB you have as default goes belly up then this is exactly what happens when you log in!!!

Cheers,

M.