Very Computer

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!

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!