|
|
|
|
Cannot open user default database. Login failed when login with group id
Hello
I got the following error when logon the SQL Sever.
"Cannot open user default database. Login failed"
so, I changed default database with my user id using sp_defaultdb. And then I could login the SQL sever.
I changed default database with window domain group id using sp_defaultdb, but the user in the group id cannot login the SQL server.
I restored master and the default database recently. and then this problem ocurred.
The deafult database is not read-only or user-mode. I removed the group id from the SQL Sever and re-added it to the SQL Sever. But users in the group cannot login the server.
Individual user-ids work, but the group id does not work.
How can I make the group id work?
--
Message posted via http://www.sqlmonster.com
Fri, 14 Jan 2005 19:50:41 GMT
"Do Park via SQLMonster.com"
|
|