Re: Unable to connect to server
From: David (iloveschnauzers@hotmail.com)
Date: 10/21/02
- Next message: Bill Hollinshead [MS]: "RE: BDO view objects in Enterprise Manager"
- 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: Mon, 21 Oct 2002 13:51:58 -0700
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 >> >> >> >> >> >> > >> >> >> >> >> >> > >> >> >> >> >> >> >. >> >> >> >> >> >> > >> >> >> >> >> > >> >> >> >> >> > >> >> >> >> >> >. >> >> >> >> >> > >> >> >> >> > >> >> >> >> > >> >> >> >> >. >> >> >> >> > >> >> >> > >> >> >> > >> >> >> >. >> >> >> > >> >> > >> >> > >> >> >. >> >> > >> > >> > >> >. >> > > > >. >
- Next message: Bill Hollinshead [MS]: "RE: BDO view objects in Enterprise Manager"
- 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
|
