connection problems

Hi, I've installed VWD, SQL Express and IIS successfully using Windows autentication. Everything went smoothly and I did have a functional connection to my new database. But suddenly without any obvious reason I could not connect. When I try to connect inside VWD I receive the error:

"An error has occurred while establishing a connection to the server. When connection 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)."

When I try to connenct through SQL Server Management Studio Express I receive the error:

Cannot connect to I6000\SQLExpress. Additional info are same as described above.

I haven't done any big changes as far I know, only adding a column to a table, so what could be the issue here? I haven't any experience from working with SQL so I am very grateful for any help.

Verify that the instance is actually running. Open SQL Configuration Manager and check out the Services node. You should see SQLEXPRESS listed as running. If it isn't, start it.

There error your getting indicates that the Instance either doesn't exist or isn't running.

Mike

|||

Thanks for your answer,

The SQL Server (SQLEXPRESS) is actually running, but there is also another instance, SQL Server Browser, which is not running. But I guess the problem is somewhere else?

|||Hi,

SQL Server Express uses a dynamic port, if you don′t want to specify it within the conenction string, you will have to use the SQL Browser which acts like a redirector between client requests and the actual grabbed ports of SQL Server Express.

HTH, Jens K. Suessmeyer.

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

You should be do this form the

programs,Microsoft SQL Server 2005, Configurations tools, Sql Server Surface Area Configuration.

In this there′s an option Surface Area Configuration for services.

In the select component choose Remote Connections, and then click in Local and remote connections, after in using TCP/IP only.

And you problem it′s resolve.

|||

There is no need to enable remote connections (sorry Kaos) because you are connecting to your local instance of SQLExpress. Jens is correct, you need to either enable the Browser or specify a port # in your connection string.

Mike