November 4, 2008 at 12:47 pm
Following message is published in the event viewer again and again:
Log was restored. Database: , creation date(time): 2006/01/30(22:21:40), first LSN: 1198:132115:1, last LSN: 1198:132115:1, number of dump devices: 7, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'VDI_114B0A7F-BFA7-46DC-B42D-E857C1D492B9_0', 'VDI_114B0A7F-BFA7-46DC-B42D-E857C1D492B9_1', 'VDI_114B0A7F-BFA7-46DC-B42D-E857C1D492B9_2', 'VDI_114B0A7F-BFA7-46DC-B42D-E857C1D492B9_3', 'VDI_114B0A7F-BFA7-46DC-B42D-E857C1D492B9_4', 'VDI_114B0A7F-BFA7-46DC-B42D-E857C1D492B9_5', 'VDI_114B0A7F-BFA7-46DC-B42D-E857C1D492B9_6'}). This is an informational message. No user action is required.
Starting up database
Recovery is writing a checkpoint in database (5). This is an informational message only. No user action is required.
I tried through DAC but got following error:
C:\Program Files\Microsoft SQL Server\90\Tools\Binn>sqlcmd -A -D master
Sqlcmd: Warning: '-D' is an obsolete option and is ignored.
HResult 0x274D, Level 16, State 1
SQL Network Interfaces: Could not establish dedicated administrator connection (
DAC) on default port. Make sure that DAC is enabled [10061].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
MS sql configuration manager shows that all the services are running but the event viewer gives the information that the DB is not built up. Starting up database 'adstore'. message is published again and again.
NB: some information has been changed because of security reasons
November 4, 2008 at 1:06 pm
Hi,
Can you see anything of interest in the errorlog? Can you connect without the -A option?
I am assuming it used to work - any idea what might have changed in between?
Is it correct that you have a server that appears to be running (according to the Services applet) but it will not except any connections?
/Elisabeth
elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
November 4, 2008 at 1:08 pm
Is this secondary server in a log-shipping setup??
November 4, 2008 at 4:01 pm
This tells that Named Pipes Provider error: 40 - could not open a connection to the sqlserver.
According to the configuration manager the named pipe is enabled. Only via is disabled.
Under C:\Program Files\Microsoft SQL Server I found two folders 80 and 90. Does this mean that there are two instances of sql servers installed. I am puzzled. I tried with -A as well but no luck. Not able to connect through DAC
November 5, 2008 at 11:51 am
When sql server 2005 is installed ,two folders 80 and 90 will be created in your installation path.They are for backward compatability with sql server 2000.Thats it.It does'nt mean that two instances are installed.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply