Re: Unable to connect to server
From: Arvind Krishnan[MS] (arvindk@online.microsoft.com)
Date: 10/21/02
- Next message: David: "Re: Unable to connect to server"
- Previous message: Byron Hynes: "Re: Brute Force Attack"
- 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"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Arvind Krishnan[MS]" <arvindk@online.microsoft.com> Date: Mon, 21 Oct 2002 13:38:44 -0700
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: Byron Hynes: "Re: Brute Force Attack"
- 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"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
