.Net Pro 2005 + SQL Express 2005

[Jay1b]

I'm trying to connect VB.Net 2005 (Pro) to an SQL Server Express 2005 installation, however i keep getting the following error message. I've checked the security settings on the server and everything is enabled (both pipes and TCP/IP).

 

Does anybody know what i'm doing wrong?

 

Thanks

Jay.

********************************************************

 

TITLE: Connect to Server

------------------------------

 

Cannot connect to esp. (esp is the servername)

 

------------------------------

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)

[Nate Bross]

I thought SSE2K5 was only local machine, you could not connect to it via network. I could be misinformed though...

[Jay1b]

I thought SSE2K5 was only local machine' date=' you could not connect to it via network. I could be misinformed though...[/quote']

 

 

As i understand it, its just that by default... But i'll look into it.

 

Thanks.

[Jay1b]

Well i've installed SQL Express on the PC which has the .Net 2005 installed upon it. And it still wont work :@

[PlausiblyDamp]

try

 

esp\sqlexpress

 

for the server name

[Jay1b]

Thanks PD, but i was just coming back to say.... 'Solved it!' :)

 

I dont remember having to do that with 2000, but then it was ages ago i last used it!

[PlausiblyDamp]

SQLExpress is installed as a named instance rather than as a default instance.