March 24, 2008 at 1:54 pm
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
------------------------------
March 24, 2008 at 6:26 pm
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:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply