Re: Unable to connect to server
From: Arvind Krishnan[MS] (arvindk@online.microsoft.com)
Date: 10/22/02
- Next message: David: "Re: Unable to connect to server"
- Previous message: mike.mullane@hpinc.com: "RE: BDO view objects in Enterprise Manager"
- In reply to: David: "Re: Unable to connect to server"
- Next in thread: David: "Re: Unable to connect to server"
- Reply: David: "Re: Unable to connect to server"
- Reply: David: "Re: Unable to connect to server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Arvind Krishnan[MS]" <arvindk@online.microsoft.com> Date: Mon, 21 Oct 2002 15:14:33 -0700
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: mike.mullane@hpinc.com: "RE: BDO view objects in Enterprise Manager"
- In reply to: David: "Re: Unable to connect to server"
- Next in thread: David: "Re: Unable to connect to server"
- Reply: David: "Re: Unable to connect to server"
- Reply: David: "Re: Unable to connect to server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
