user's default database defaults to MASTER, despite config otherwise

user's default database defaults to MASTER, despite config otherwise

Post by David Wra » Sat, 09 Jun 2001 05:27:13



I've come across a SQL7 server running sp3 that, despite setting a user login's
default database to a different database, always defaults the user to MASTER.

When you view the Login screen, the users appear to be defaulting to the correct
database (as they were configured in their properties screen), but if you try to
connect with one of these users, MASTER is the database that it default to.

I've even tried deleting the users and their objects and recreating everything
(including stopping and restarting the SQL Server service), but the behavior
persists.

Anyone seen this before???  Your help is much appreciated!

 
 
 

user's default database defaults to MASTER, despite config otherwise

Post by Mary Bra » Mon, 11 Jun 2001 09:03:24


Is your connection string changing the database (initial catalog)- if they
can log in to Query Analyser and be at the proper default then this may be
the case.

--
Mary Bray
MCT, MCSD, MCDBA, MCSE
**Please reply to newsgroups only**


I've come across a SQL7 server running sp3 that, despite setting a user
login's
default database to a different database, always defaults the user to
MASTER.

When you view the Login screen, the users appear to be defaulting to the
correct
database (as they were configured in their properties screen), but if you
try to
connect with one of these users, MASTER is the database that it default to.

I've even tried deleting the users and their objects and recreating
everything
(including stopping and restarting the SQL Server service), but the behavior
persists.

Anyone seen this before???  Your help is much appreciated!

 
 
 

1. user's default db is always MASTER despite config'd to other db

I've come across a SQL7 server running sp3 that, despite setting a user login's
default database to a different database, always defaults the user to MASTER.

When you view the Login screen, the users appear to be defaulting to the correct
database (as they were configured in their properties screen), but if you try to
connect with one of these users, MASTER is the database that it default to.

I've even tried deleting the users and their objects and recreating everything
(including stopping and restarting the SQL Server service), but the behavior
persists.

Anyone seen this before???  Your help is much appreciated!

2. URGENT HELP on VB5 and ACCESS

3. user's default db is MASTER regardless of configuration settings

4. Port keeps changing to 2433! *sigh*

5. DSN Can't find user's default database

6. SQL Server 7.0 SQLOLE

7. sp3 and user's default database

8. Indexes

9. What is the default password for the postgres user in the default

10. DSN Default dB being overriden by Login's default dB

11. default datestamp of 12am of today's date for default value

12. users default DB is MASTER regardless of how configured

13. selecting real data if available and generating default otherwise