Connection problems accross the network

[pachjo]

I would really appreciate some help with this please as my ... manhood relies ont it!!!

I have setup sql express 2005 on a Windows XP PC called FUSION.
I have installed the SSMSEE on the same PC
The instance is called FUSION\SQLEXPRESS
In the security I have added my windows network logon
In the databases I have created a database named TestNetworkDB

I open VS.NET Pro and add a Microsoft SQL Server datasource
I click on the Server names but FUSION is not there
On the server PC I have enabled named pipes, tcp/ip and via
FUSION still does not appear
The default is server service not running but even if i turn on it does not work
The sql express instance is running

help???

 

[Arg81]

maybe these will help:
http://technet.microsoft.com/en-us/library/ms165647.aspx

http://technet.microsoft.com/en-us/library/ms143446.aspx

http://www.datamasker.com/SSE2005_NetworkCfg.htm

 

[pachjo]

And the man from Delmonte he say yes!

Or should I say thanks to the third link kindly supplied by Arg81 means my SQL Express works a treat across the network!!!!

You are a star, thanks dude

 

[Arg81]

not a problem. My good friend Google helped me some what

I had some searches cached - I looked into whether I could do the same, as I was looking whether I could implement express to remote sites.

Glad it helped

 

[pachjo]

Just a quick note to let you know how to retstrict the visibility of the sql sever express instance to your local subnet.

When entering the details in the windows firewall exceptions ensure you double click on the server you add to the exceptions list and then click on the change scope button. once there select my network (subnet) only then save and close the windows.