Not able to connect to SSMS

  • 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

  • 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

  • Is this secondary server in a log-shipping setup??

  • 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

  • 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