[dba-SQLServer] Re: Connection problems

do you know if anyone remove any permissions for the security accounts you 
are using to access the target database?

sometimes when I get the "cannot open default database", it could mean one 
of two things:
* I no longer have access to the default database
* someone changed the default database to another database which I do not 
have access to

if it is the first reason, then look for way to restore database access to 
my security account

if it is the second reason, then change the default database of my security 
account to what it was originally.

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: Re: [dba-SQLServer] Re: Connection problems
>Date: Wed, 11 Aug 2004 15:18:49 -0500
>
>Martin,
>
> >> Can you use ISQL to see the database?? <<
>
>Being unable to locate a reference to ISQL in the highly-acclaimed Harkins 
>& Reid book, I reluctantly turned to Books Online. Using an Access 2000 ADP 
>to determine what the connection string was, I fired up ISQL and entered 
>the appropriate parameters, including the Initial Catalog/default database. 
>Interestingly enough, I got a message:
>
>Cannot open user default database. Using master database instead.
>
>I then see the "1>" prompt. I haven't gone any further.
>
>Back in Access 2000 I tried once again to go into design mode for an sproc. 
>Lo and behold, I was able to modify it in Access 2000!? This is on my own 
>workstation. At my client's workstation last week, I couldn't get anywhere. 
>I kept getting a message like "You may not have sufficient rights."
>
>I even tried creating a new sproc and again, lo and behold, there's the 
>template for a new sproc. I don't get it.
>
>Hmmm. I think I'll see if I can get somewhere with Access 2000/XP rather 
>than mess with ISQL. Thanks for pointing me in that direction, though. I 
>may be all right now. Thanks for the help.
>
>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*.