Re: Unable to connect to server
From: David (iloveschnauzers@hotmail.com)
Date: 10/19/02
- Next message: chris: "SQLServerAgent won't start"
- Previous message: Arvind Krishnan[MS]: "Re: Unable to connect to server"
- In reply to: Arvind Krishnan[MS]: "Re: Unable to connect to server"
- Next in thread: Arvind Krishnan[MS]: "Re: Unable to connect to server"
- Reply: Arvind Krishnan[MS]: "Re: Unable to connect to server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "David" <iloveschnauzers@hotmail.com> Date: Fri, 18 Oct 2002 15:38:27 -0700
Arvind,
Sorry, I am still rather new at all this...
Am I to run the Select * From master
at the prompt after I have logged in use the command
isql -E
?
Thx
David
>-----Original Message-----
>David
>Can you post an output of your SELECT * FROM
master..SYSDATABASES? From your
>errorlog, I am not seeing an attempt to start the
MasterPlan database.
>
>--
>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:73ca01c276eb$c288c2d0$3aef2ecf@TKMSFTNGXA09...
>> Arvind,
>>
>> I modified the name before I sent it..
>>
>> Looking at the event viewer, there is nothin that
>> pertains to the SQL server.
>>
>> Dont know why that database is not starting...
>>
>> any thoughts...
>>
>> Thx
>>
>> David
>>
>>
>> >-----Original Message-----
>> >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
>> >> >> >
>> >> >> >
>> >> >> >.
>> >> >> >
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>
>.
>
- Next message: chris: "SQLServerAgent won't start"
- Previous message: Arvind Krishnan[MS]: "Re: Unable to connect to server"
- In reply to: Arvind Krishnan[MS]: "Re: Unable to connect to server"
- Next in thread: Arvind Krishnan[MS]: "Re: Unable to connect to server"
- Reply: Arvind Krishnan[MS]: "Re: Unable to connect to server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
