Cannot connect to SQLExpress

Hi, I'm using Microsoft SQL Sever Management Studio Express. But all of a sudden, if I clicked connect button, the messageBox pops up and it doesn't let me connect. It says "TITLE: Connect to Server

Cannot connect to YOUR-4105E587B6\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

I didn't have such a problem before. If someone could help to solve to this problem, I appreciate it. Thanks.

YOu will have to enable remote ocnnections. if have a screencast for that on my site (which is currently not online due to server problems at my provider). The setting is made through Programs >MS SQL Server > Configuration Tools > Surface Area Configuration > ..for Services and Connections > SQL Server <Remote Connections > Protocols > ENbale the appropiate protocols > restart the Service. If you need additional help, I can send you the files of the screencast (flash).

HTH, jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Thank you for the tip Mr.Jens.

I'll try that!

Ken

|||

Hi Jens and KentaroM

i have the same problems, but i have tried to make the surgest from Jens but i can't find it.

I have open the Programs >MS SQL Server > Configuration Tools > Surface Area Configuration > Surface Area Configuration for Services and Connections > SQL Server > Remote Connections

i have this options:

local connections only or

Local and remote connections

Using TCP/IP only

Using Name pipes only

Using TCP/IP and name pipes

it it not possble for me to find Protocols > ENbale the appropiate protocols

Do anny have a surgestion to help me with my problems?

Alif

|||

I also have the same problem, and i have opened the remote connections and even so I cannot.

I have all the open ports and appears the same error.