Re: Unable to connect to server
From: Arvind Krishnan[MS] (arvindk@online.microsoft.com)
Date: 10/22/02
- Next message: Andrew John: "Re: Service Account Password Change"
- Previous message: Sue Hoegemeier: "Re: SQL Profiler - Trace Files"
- In reply to: 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 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 > >> >> >> >> >> >> >> > > >> >> >> >> >> >> >> > > >> >> >> >> >> >> >> >. > >> >> >> >> >> >> >> > > >> >> >> >> >> >> > > >> >> >> >> >> >> > > >> >> >> >> >> >> >. > >> >> >> >> >> >> > > >> >> >> >> >> > > >> >> >> >> >> > > >> >> >> >> >> >. > >> >> >> >> >> > > >> >> >> >> > > >> >> >> >> > > >> >> >> >> >. > >> >> >> >> > > >> >> >> > > >> >> >> > > >> >> >> >. > >> >> >> > > >> >> > > >> >> > > >> >> >. > >> >> > > >> > > >> > > >> >. > >> > > > > > > >. > >
- Next message: Andrew John: "Re: Service Account Password Change"
- Previous message: Sue Hoegemeier: "Re: SQL Profiler - Trace Files"
- In reply to: David: "Re: Unable to connect to server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
