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-08-04 : 15:35:34
|
| Alex writes "Spec: SQL Server 7 Sp 1, NT 4 Server.Hi,I'm just about out of hair through pulling it out... currently running a 20 user network, all of who access multiple SQL databases daily. They have a standard ODBC link to the database, using NT authentication. They have no problems accessing data.My Problem is that I can't access the server group though the enterprise manager. I get this as an error "Cannot open user default database'<ID>' using master instead"I read through the microsoft KB about this problem and they are forever saying 'expand the server group' to change defaults etc.. Hence the catch 22. I can't expand the server group because of the default DB problem, and I can't change the default DB beacuse I can't expand the server group. Nice ain't it? I've tried changing the default DB in the CMD prompt.. no luck. I can't create an odbc link to the server as it throws this message at me no matter what authentication I give it: "Server rejected the connection; Access to the selected database is denied"and I can't change the selected DB because the DB selection is on the next screen of hte ODBC setup... which I can't get to.. arrhhh the madness of Microsoft.. any .. and I mean any ideas, solutions, offers of destructive powertools are welcome.. RegardsAlexIT ManagerOn the edge" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-08-04 : 15:42:34
|
| Use Query Analyzer, log in as sa if in mixed mode authentication or log on locally on the server using NT Authentication assuming you haven't removed BUILTIN\Administrators. Then runsp_defaultdb 'Your login','database'HTHJasper Smith |
 |
|
|
|
|
|
The Microsoft catch 22 access to database problem