Re: Unable to connect to server

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


From: "Arvind Krishnan[MS]" <arvindk@online.microsoft.com>
Date: Mon, 21 Oct 2002 19:09:18 -0700


Excellent, I am glad to hear that. As for the help, no problem whatsoever -
thats why we are here.
I am sorry I couldn't respond sooner - I was away for the last couple of
hours.

--
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:932901c27955$2f1bb040$36ef2ecf@tkmsftngxa12...
> Arvind,
>
> Disregard Last Post...
>
> I thank you a Million times...
>
> I appreciate eyour assistance and patience with me on
> this issue....
>
> All resolved...
>
>
> Thx Again
>
> David
> >-----Original Message-----
> >David,
> >ok, that explains it - the definition for each database
> on a SQL Server is
> >maintained in the Master database. In this case, you
> only copied the
> >MasterPlan database files, the Master still had no idea
> that there was a
> >database with this name.  Please take a look at the
> following KB article for
> >steps on moving a database from one SQL Server to
> another:
> >http://support.microsoft.com/default.aspx?scid=kb;en-
> us;Q314546
> >
> >--
> >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:8cdc01c27943$b2c04530$37ef2ecf@TKMSFTNGXA13...
> >> Arvind,
> >>
> >> I copied all the files from the MastPlan directory..
> This
> >> directory holds drawings, etc for an application called
> >> Archibus as well as the MasterPLan.dbf and the
> >> MasterPLan.LDF files as these two are locked when the
> >> server is active.  I wanted to retrieve the "live"
> >> database in order to create a "testing" server.
> >>
> >> Any thoughts?
> >>
> >> David
> >>
> >> >-----Original Message-----
> >> >Files copied? which files did you copy? and why?
> >> >
> >> >--
> >> >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:8c2b01c2793d$d66d79e0$37ef2ecf@TKMSFTNGXA13...
> >> >> Arvind,
> >> >>
> >> >> Here is what the file contained...
> >> >>
> >> >>
> >> >>
> >> >> Msg 4062, Level 11, State 1, Server FSS-ARCHIBUS-PC,
> >> Line
> >> >> 0
> >> >> Cannot open user default database. Using master
> >> database
> >> >> instead.
> >> >>
> >> >> name
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>                                     dbid
> >> >> status      status2
> >> >> filename
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>  ---------------------------------------------------
> ---
> >> ---
> >> >> ---------------------
> >> >> --------------------------------------------------
> >> >> ---------------------
> >> >> --------------------------------------------------
> >> >> ---------------------
> >> >> ----------------------------------- ------ -------
> >> >> ---- -----------
> >> >> --------------------------------------------------
> >> >> ---------------------
> >> >> --------------------------------------------------
> >> >> ---------------------
> >> >> --------------------------------------------------
> >> >> ---------------------
> >> >> ------------------------------------------
> >> >>
> >> >> master
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> 1          24  1090519040
> >> >> C:\Program Files\Microsoft SQL
> >> >> Server\MSSQL\data\master.mdf
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> model
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>                                          3
> >> >> 1073741840  1090519040
> >> >> C:\Program Files\Microsoft SQL
> >> >> Server\MSSQL\data\model.mdf
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> msdb
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> 4          24  1090519040
> >> >> C:\Program Files\Microsoft SQL
> >> >> Server\MSSQL\data\msdbdata.mdf
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> Northwind
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> 6          28  1090519040
> >> >> C:\Program Files\Microsoft SQL
> >> >> Server\MSSQL\data\northwnd.mdf
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> pubs
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> 5          24  1090519040
> >> >> C:\Program Files\Microsoft SQL
> >> >> Server\MSSQL\data\pubs.mdf
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> tempdb
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> 2           8  1090519040
> >> >> C:\Program Files\Microsoft SQL
> >> >> Server\MSSQL\data\tempdb.mdf
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> (6 rows affected)
> >> >>
> >> >>
> >> >> It does not show the MastPLan Database... Dont know
> >> why...
> >> >>
> >> >> All that was done is the Sql Server was shutdown,
> files
> >> >> copied, then restarted.
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> any ideas?  Thx
> >> >>
> >> >> David
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> >-----Original Message-----
> >> >> >I can't see your file because Outlook express
> security
> >> >> stripped it. In any
> >> >> >case, do you see an entry for the MasterPlan
> database
> >> on
> >> >> this list?
> >> >> >If not, then there is your problem - your 'sa'
> login
> >> is
> >> >> configured to have a
> >> >> >default database of MasterPlan, yet that database
> does
> >> >> not exist on this
> >> >> >server.
> >> >> >Can you give us a little more background on what
> >> changes
> >> >> have taken place in
> >> >> >the recent past on this server?
> >> >> >
> >> >> >--
> >> >> >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:996d01c27938$db507d90$35ef2ecf@TKMSFTNGXA11...
> >> >> >> Arvind,
> >> >> >>
> >> >> >> Here it is.. there isnt much in the file....
> >> >> >>
> >> >> >> Thx again form your assistance in this matter...
> >> >> >>
> >> >> >> David
> >> >> >> >-----Original Message-----
> >> >> >> >David,
> >> >> >> >Yes. Thats an option. You could also pass the
> query
> >> >> as a
> >> >> >> command-line
> >> >> >> >argument as follows:
> >> >> >> >
> >> >> >> >C:\>isql -E -Q"select name, dbid, status,
> status2,
> >> >> >> filename from
> >> >> >> >master..sysdatabases" -oc:\temp\sysdatabases.out
> >> >> >> >
> >> >> >> >and then post the c:\temp\sysdatabases.out
> file..
> >> >> >> >
> >> >> >> >
> >> >> >> >--
> >> >> >> >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:740a01c276f7$137ddad0
> $3bef2ecf@TKMSFTNGXA10...
> >> >> >> >> 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
> >> >> >> >> >> >> >> >
> >> >> >> >> >> >> >> >
> >> >> >> >> >> >> >> >.
> >> >> >> >> >> >> >> >
> >> >> >> >> >> >> >
> >> >> >> >> >> >> >
> >> >> >> >> >> >> >.
> >> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >> >> >.
> >> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >> >.
> >> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> >.
> >> >> >> >
> >> >> >
> >> >> >
> >> >> >.
> >> >> >
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >