connection problems

Hi, I've installed VWD, SQL Express and IIS successfully using Windows autentication. Everything went smoothly and I had 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 as described above.

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

Open VS2005, go to Tools/Connect to Database and try from there to open the database. That should tell you what the problem is.

Cheers

Al

|||

Hi cosmos,

You would have to habilitate TCP/IP protocol for your SQL Server Express.

Good Coding!

Javier Luna
http://guydotnetxmlwebservices.blogspot.com/

|||Also make sure the SQL Browser service is running.