DAC error

  • Hi,

    I am not able to connect using DAC. I get the error

    TITLE: Connect to Database Engine

    ------------------------------

    Cannot connect to ADMIN:mdinn,2029.

    ------------------------------

    ADDITIONAL INFORMATION:

    An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid) (Microsoft SQL Server, Error: 87)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=87&LinkId=20476

    ------------------------------

    BUTTONS:

    OK

    ------------------------------

  • How are you trying to connect: locally or remotely? In SSMS you would connect using the Database Engine Query, not Database Engine in Object Explorer.

    You also might want to see if you can connect using SQLCMD from the SQL Server. ex. SQLCMD -S127.0.0.1,1434

    Reference:

    Using a Dedicated Administrator Connection

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply