Re: Unable to connect to server

From: Arvind Krishnan[MS] (arvindk@online.microsoft.com)
Date: 10/18/02 

From: "Arvind Krishnan[MS]" <arvindk@online.microsoft.com>
Date: Thu, 17 Oct 2002 16:39:44 -0700

David,
Which login do you have registered for your Enterprise Manager connection?
And what is the default db for that login?
You should be able to connect to your server through isql, and run a select
* from syslogins to get this information.
I am surprised that this happened just by stopping and restarting your SQL
Server service. Can you post your errorlog as well? 

--
Thanks,
Arvind Krishnan
SQL Server Development Team
Microsoft Corporation
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"David" <iloveschnauzers@hotmail.com> wrote in message
news:5ec301c27632$a9cc8330$37ef2ecf@TKMSFTNGXA13...
> The SQL 2000 server was shutdown.  Upon rebooting the SQL
> 2000 Server, The server indicates that it is running
> (looking at the icon in the lower right hand corner as well
> as verifying it the as well)
>
> I then open the MMC (Console) and try to open up the Server
> and get the following message....
>
>
> A connection could not be established to <the server>
>
> Reason:  Cannot open user default database. Login failed..
>
> Please verify SQL Server is running and check your SQL
> Server registration properties (by right clicking on the
> <server> mode) and try again..
>
>
> I have tried everything I can think of.. and still cannot
> connect.. PLEASE HELP
>
> Thx

Relevant Pages

  • Re: SQL User SID format?
    ... When you move databases to another server, you can remap users to logins ... capability to remap a user to a login with new ALTER USER syntax - I ... The new ALTER USER syntax works for remapping both SQL and Windows ... this means you already have access to a SID from the syslogins catalog; ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server on XP Home Network
    ... The sa account is the system administrator "God" account witihin SQL ... This account is a SQL-Server login. ... You might be able to use Enterprise Manager to go in and create a new SQL ... Select the "SQL Server Authentication" ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2000 Replication Agents Credentials
    ... the snapshot agent IS using sql login to connect to the ... The pull distribution agent IS using sql ... Do you know where SQL Server 2000 saves the sql ...
    (microsoft.public.sqlserver.replication)
  • Re: Can you update/process AS2005 cube with AMO and SQL authentica
    ... We have cases where the AS server and the Data Source server reside on 2 ... The data source is properly secured using SQL Server ... login and no serious client will accept the login with no password. ...
    (microsoft.public.sqlserver.olap)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
Loading