Saturday, February 25, 2012

Cannot connect to sqlexpress from ssmse (ctp)

I have been using sqlexpress for several months and decided to upgrade the ssmse to the november ctp version. I uninstalled the old ssmse and installed the november release from ctp.

I verified that the tcp/ip and named pipes are enable in the config manager. I attempted using these connection strings:

\sqlexpress, (local)\sqlexpress, or server name\sqlexpress

All fail with the following message:

Cannot connect to WALLY1\sqlexpress

--
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: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

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


BUTTONS:

OK

We need a little more information to troubleshoot your problem.

Are you running SSMSE and SQLExpress on the same machine? Are you able to connect to SQLExpress using SQLCMD?

Thanks,
Dan

|||Try to connect either with TCP/IP or named-pipes enabled and not with both the options enabled.
I have had this problem before and when used named-pipes alone it resolved the problem and ensure the ALIAS is defined properly and you can ping the server.|||

Are you running everything from the same machine or are you trying to connect to a remote SQL Server?

Cheers,
Dan

No comments:

Post a Comment