SQL SERVER 2000 cannot open user default database

I detached 2 databases in sql 2000 and one of them must be the default database because now I get  Reason: can not open user default database when opening enterprise manager.
I have tried to use isql and changed the default database for sa to master but I am still unable to login - perhaps I need to change the default database for all users - I am logging in as windows administrator and and am not prompted for id/password. I beleive they use windows authentication. Trying to help a friend but getting frustrating - thanks in advance.
RedshawAsked:
Who is Participating?
 
radcaesarCommented:
Have you granted access using sp_addrolemember and sp_grantdbaccess

http://support.microsoft.com/kb/196076

0
 
Alpesh PatelAssistant ConsultantCommented:
see attached screen Change default database
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
radcaesarCommented:
Can you please explain the problem in screen snap clearly?
0
 
RedshawAuthor Commented:
Patel, thanks - I am assuming I am logged in as sa - when I go into enterprise manager I am logged onto the server as domain administrator and am not prompted for a password.. When I go to tree and try to open sql in tree I get the can't login to default. and this was working fine prior to my detaching the databases - (getting an offline backup). Would I need to do the granting in this case?
thanks
0
 
RedshawAuthor Commented:
sorry radcaesar - that last comment was for you.. I don't get the screen shot either - unfortunately I am working on an sql2000 system - and I don't think I can get there..
0
 
RedshawAuthor Commented:
Is there an alternate way for me to re-attach the 2 databases that I detached without using enterprise manager. cmd line for example (once these are attached I think I will be able to open  enterprise manager).
thanks
0
 
RedshawAuthor Commented:
sorry, just got the DB's back online.. here's what I did.. I changed the default database to  Master for the sa user, then I edited the connection properties by right clicking on sql in the tree on the left and changingit from windows logon to sql logon then I logged in as sa and I could see the databases so enterprise manager opened after that change -  which allowed me to attach the db's back - then users were able to access.. OP Zahrin had a good response so I will award him the points..
0
 
Anthony PerkinsCommented:
>>OP Zahrin had a good response so I will award him the points.. <<
I am objecting to allow the author to award points to OP_Zaharin
0
 
RedshawAuthor Commented:
Thanks
0
 
OP_ZaharinCommented:
thank you redshaw :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.