Re: Unable to connect to server
From: David (iloveschnauzers@hotmail.com)
Date: 10/22/02
- Next message: David: "Re: Unable to connect to server"
- 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: David: "Re: Unable to connect to server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "David" <iloveschnauzers@hotmail.com> Date: Mon, 21 Oct 2002 15:37:30 -0700
Arvind,
So how do I go about getting the server to recognize it
again?
using the attach command at the command prompt?
Or do I have to copy back what I have already copied from
the "testing" server to the orginal?
Im still confues even after reading that link...
Thx in advance for your assistance in this matter.
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 >> >> >> >> >> >> >> > >> >> >> >> >> >> >> > >> >> >> >> >> >> >> >. >> >> >> >> >> >> >> > >> >> >> >> >> >> > >> >> >> >> >> >> > >> >> >> >> >> >> >. >> >> >> >> >> >> > >> >> >> >> >> > >> >> >> >> >> > >> >> >> >> >> >. >> >> >> >> >> > >> >> >> >> > >> >> >> >> > >> >> >> >> >. >> >> >> >> > >> >> >> > >> >> >> > >> >> >> >. >> >> >> > >> >> > >> >> > >> >> >. >> >> > >> > >> > >> >. >> > > > >. >
- Next message: David: "Re: Unable to connect to server"
- 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: David: "Re: Unable to connect to server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
