DAC error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Wayne Fillis » DAC error

DAC error

Rate Topic

Display Mode

Topic Options

Author

Message

SQL DBA-601753

Posted Monday, March 24, 2008 1:54 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, November 21, 2008 3:09 PM
Points: 3, Visits: 53

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
------------------------------

Post #473699

Todd Engen

Posted Monday, March 24, 2008 6:26 PM

Ten Centuries

Group: General Forum Members
Last Login: Friday, June 14, 2013 11:26 AM
Points: 1,073, Visits: 6,324

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

Post #473807

« Prev Topic | Next Topic »

Permissions