[dba-SQLServer] Connection problems

Billy Pang tuxedo_man at hotmail.com
Wed Aug 11 13:22:36 CDT 2004


oh ok.. I thought that it was the other way around.
can you logon as the sa user?
sa user should not have problem with opening default database, by definition 
of course.
or use another security account to access EM to change the security account 
that is giving the "cannot open default database" error.

Billy


>From: "Steven W. Erbach" <serbach at new.rr.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: dba-sqlserver at databaseadvisors.com
>Subject: RE: [dba-SQLServer] Connection problems
>Date: Wed, 11 Aug 2004 09:49:54 -0500
>
>Billy,
>
> >>  The "security" folder is peer to the "databases" folder.  The 
>"databases" folder is where you access all the tables. <<
>
>I was afraid that's what you were going to say. I cannot "see" those 
>folders because I can't log in to the server, and that's because of the 
>error I get regarding the default database.
>
>This is very odd since I can get it just fine through ODBC or an Access 
>ADP. It's just in EM that I'm having the trouble.
>
>I want to check EM to see if the rights the user has include the right to 
>modify or create sprocs.
>
>Steve Erbach
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
Take advantage of powerful junk e-mail filters built on patented Microsoft® 
SmartScreen Technology. 
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*.




More information about the dba-SQLServer mailing list