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 - 2003-01-07 : 08:49:35
|
| Paul writes "I recently restored 2 databases and changed the database owners on both. But since then I have been unable to log in to the SQL Server. The message reads Cannot open user default database.I have not changed the system password!!!If I edit the servers properties to log on using the windows account, I have no problems.Any suggestions..Paul" |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-01-07 : 09:54:57
|
| Make sure your security authentication settings are set for sql and windows. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-07 : 12:30:57
|
| Logon to the SQL Server with a windows account that is a member of the administrators group. Now change the default database of the user that owns the databases. You can do this in Enterprise Manager by double clicking on the user in the security section. |
|
|
|
|
|
|
User Default Database