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: Fri, 18 Oct 2002 13:07:31 -0700

David,
I don't see MasterPlan starting up during server startup - take a look at
your errorlog. And since there are no related errors either, it appears that
the system is not even aware of the MasterPlan database.

And the servername looks really strange as well..Can you take a look at
that? 

--
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:715901c276c2$179ccc00$35ef2ecf@TKMSFTNGXA11...
> Arvind,
>
> Ok..  Masterplan is still there.. It has not been moved.
>
>
> I have included the error log.
>
>
>
>
> >-----Original Message-----
> >David,
> >So what happened to the MasterPlan database? Is it not
> available any longer?
> >What does your errorlog say?
> >
> >--
> >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:643d01c2763a$65b16320$3aef2ecf@TKMSFTNGXA09...
> >> Arvid,
> >>
> >> I agree it is very strange.. dont know what has
> happened.
> >>
> >> I am using the Windows Authentication..
> >>
> >> And the Default DB is MasterPlan...
> >>
> >> Upon using the command from the command prompt isql -
> E, I
> >> am able to get the following message...
> >>
> >>
> >> MSG 4062, Level 11, State1,  etc
> >>
> >> Cannot open user default database, Using master
> database
> >> instead.
> >>
> >> 1>
> >>
> >> Thx again in advance for your asisstance in this
> issue...
> >>
> >>
> >> David
> >>
> >> >-----Original Message-----
> >> >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></server> mode) and try again..
> >> >>
> >> >>
> >> >> I have tried everything I can think of.. and still
> cannot
> >> >> connect.. PLEASE HELP
> >> >>
> >> >> Thx
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >

Relevant Pages
Loading