.Net Pro 2005 + SQL Express 2005

J

Jay1b

Well-known member
Joined
Aug 3, 2003
Messages
640
Location
Kent, Uk.
Im trying to connect VB.Net 2005 (Pro) to an SQL Server Express 2005 installation, however i keep getting the following error message. Ive checked the security settings on the server and everything is enabled (both pipes and TCP/IP).

Does anybody know what im 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 said:
I thought SSE2K5 was only local machine, you could not connect to it via network. I could be misinformed though...
Click to expand...


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

Thanks.
 
Well ive installed SQL Express on the PC which has the .Net 2005 installed upon it. And it still wont work :@
 
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!
 
Back
Top