Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-21 : 09:14:13
|
| Stephen writes "Hi everybody,Recently I bought a notebook for developement purpose. I installed SQL Server 2000 as development database server. However, once I expand a database server, an error is reported - "Cannot open user default database. Login Failed.". How can I solve the problem without reinstalling the SQL server?Pls help me asap ... project dealine is coming soon lar ... woo woo ...Configuration:OS - Window Advanced server SP2 / XP ProSQL server - SQL server 2000 Standard Ed. SP 2" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-05-21 : 09:37:33
|
| I take it by 'expand' you mean you are using the gui tool enterprise manager? if so, the user in your sql server registration of the server you are trying to expand does not have access to the default database assigned to him/her . . . therefore is not able to do anything.Edit the sql server registration and log in as SA or some system administrator. Then give whatever put whatever login was having trouble in the public role of the database assigned as his/her default.<O> |
 |
|
|
konglo
Starting Member
2 Posts |
Posted - 2002-05-21 : 22:36:10
|
quote:
I take it by 'expand' you mean you are using the gui tool enterprise manager? if so, the user in your sql server registration of the server you are trying to expand does not have access to the default database assigned to him/her . . . therefore is not able to do anything.Edit the sql server registration and log in as SA or some system administrator. Then give whatever put whatever login was having trouble in the public role of the database assigned as his/her default.<O>
|
|
|
|
konglo
Starting Member
2 Posts |
Posted - 2002-05-21 : 23:14:28
|
Dear,Pls ignore the previous reply. Sorry.I do not understand the sentence "Then give whatever put whatever login was having trouble in the public role of the database assigned as his/her default.". Would you explain it?I have tried using SQL Server Authentication, i.e. use "sa" to connect to sql server. But login resulted in failure also. I wonder if there is error in either the setting of "default database" of all users, or error in properties of "sa" and "dbo". What is your opinion?Initially there is no error after installation. I created a new database and login account for this database. However, once I assigned database access rights to this new login account, the value of "user" column was forced to set as "dbo" instead of new user name. Soon i remove the database. Error occur afterwards ...Thanks your help.Regards,Stephenquote:
I take it by 'expand' you mean you are using the gui tool enterprise manager? if so, the user in your sql server registration of the server you are trying to expand does not have access to the default database assigned to him/her . . . therefore is not able to do anything.Edit the sql server registration and log in as SA or some system administrator. Then give whatever put whatever login was having trouble in the public role of the database assigned as his/her default.<O>
|
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-05-22 : 02:26:51
|
| Login as Admin on the machine, and change the registration properties to NT Authentication.Then once you get in, fix the security mess. Make sure nobody has a default database to which they have no access.-Chad |
|
|
|
|
|
|
|
|
Cannot open user default database!?