[dba-SQLServer] Connection problems

you can change it from EM.  From EM, go to security -- > logins.  Bring up 
the sql server login properties of the sql server login.  The properties box 
pops up.  From general tab, on the bottom of the page is the "default 
database".

also, sp_defaultdb stored procedure will allow you to modify default db of 
db user from query analyzer

HTH
Billy


>From: "Steven W. Erbach" <serbach at new.rr.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: dba-sqlserver at databaseadvisors.com
>Subject: [dba-SQLServer] Connection problems
>Date: Mon, 9 Aug 2004 20:35:00 -0500
>
>Dear Group,
>
>I have a client whose database is out on a shared host SQL Server. I can 
>get at the data through an ODBC connection with Access 97, or through an 
>Access 2000/XP ADP. My problem comes when I try to use Enterprise Manager. 
>When I enter the user name and password I get this message:
>
>~~~~~~~~~~~~~~~
>A connection could not be established to 64.158...
>
>Reason: Cannot open user default database. Login failed.
>
>Please verify SQL Server is running and check your SQL Server registration 
>properties.
>~~~~~~~~~~~~~~~
>
>Recently the default database for my client's application was, indeed, 
>changed on this particular SQL Server...but there doesn't seem to be a way 
>to change the default database in Enterprise Manager.
>
>What am I missing?
>
>Sincerely,
>
>Steve Erbach
>Scientific Marketing
>Neenah, WI
>920-969-0504
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
MSN® Calendar keeps you organized and takes the effort out of scheduling 
get-togethers. 
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines 
  Start enjoying all the benefits of MSN® Premium right now and get the 
first two months FREE*.