SQL Server 2005 Express Connection String

[BomberMan2K]

Hey guys,
I've built an ASP web site using SQL Server Developer Edition, and now have to move it to an Express Edition.
For some reason I can't connect to the DB using a connection string, my guess because is that I can't get the "Data Source" right.
When I power up MSSQL I get that the instance name is "S-1\SQLEXPRESS" - So I write it in "Data Source" - ".\S-1\SQLEXPRESS" and it just doesn't work.
I've tried also just .\SQLEXPRESS and it also didn't work.

I get the message - "Named Pipes Provider: Could not open a connection to SQL Server [53]."

Would really appreciate any help.

Good day,
Roman.

 

[bborissov]

If S_1 is the name of the computer (server) then use just .\SQLEXPRESS or S-1\SQLEXPRESS but not .\S-1\SQLEXPRESS

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.