Re: Default Database Missing, Unable to Connect

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 06/26/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Wed, 26 Jun 2002 15:35:29 -0600

Glad it worked for you - thanks for reporting back.

-Sue

On 26 Jun 2002 14:09:23 -0700, tigger@poetic.com (Mike)
wrote:

>Worked like a champ. Thanks! I wouldn't have thought to try it!!!
>
>Sue Hoegemeier <Sue_H@nomail.please> wrote in message news:<nuphhucs50msqdao9h67qukd3iogjmdtv3@4ax.com>...
>> Try logging in using isql instead. It typically won't kick
>> you out due to the default database issue. It will just
>> report something like: Cannot use default database. Using
>> master instead.
>> Once logged in through isql, you can change the default
>> databases using sp_defaultdb.
>> EXEC sp_defaultdb 'Login', 'NewDefaultDB'
>>
>> -Sue
>>
>>
>> On 25 Jun 2002 13:46:34 -0700, tigger@poetic.com (Mike)
>> wrote:
>>
>> >I deleted a database the other day that was installed by an
>> >application. (Microsoft MOM to be specific.) Anyway, when the
>> >application was removed, the database was still there, so I dropped
>> >it. Since then, I've been unable to connect to the server as any
>> >user, SQL Logins aren't active on that server. My guess is that the
>> >Builtin/Administrators group had the OnePoint database listed as the
>> >Default when it the software installed.
>> >
>> >My question is, if all logins are mapped to OnePoint, which is now
>> >non-existant, how can I log in to Enterprise Manager?
>> >
>> >Thanks.

Relevant Pages

  • RE: Creating a DB User *not* on current Machine
    ... detach/attach the database to a new server. ... Server.When you move a database from one server that is running SQL Server ... the security identification numbers of the logins in the master ...
    (microsoft.public.sqlserver.security)
  • Re: Logins
    ... no databases are checked, ... On the Server Roles tab, ... That server was upgraded to SQL Server ... moved, I recreated the SQL Server logins we had added, making sure that the ...
    (microsoft.public.sqlserver.security)
  • Re: transfering logins
    ... has their name, password, and a SID, among other attributes. ... In <your database>.dbo.sysusers, you will notice that each database user has ... database not a server object), but since the SIDs are generated at random, ... do not have this problem with Windows logins (hint: ...
    (microsoft.public.sqlserver.security)
  • Re: transfering logins
    ... has their name, password, and a SID, among other attributes. ... In <your database>.dbo.sysusers, you will notice that each database user has ... database not a server object), but since the SIDs are generated at random, ... do not have this problem with Windows logins (hint: ...
    (microsoft.public.sqlserver.security)
  • Box Requirements
    ... i would never recommend raid 5 for database apps unless ... >I have an Access database that we will be porting to SQL ... have in Server requirements either. ... reporting database that will aggregate and crunch numbers ...
    (microsoft.public.sqlserver.server)