Client can not connect to SQL Express

Hi,

When I try to connect to SQL Express from another computer I get error 26.

The setup is as follows:

Server is Windows XP Pro, Firewall turned off.

Client is Windows XP Pro, Firewall turned off.

Both computers are on the same workgroup, no domain or other servers on the network.

The server is configured for network: protocols enabled, browser running.

The client has MS SQL Server Management Studio Express installed. When I try to connect the SSMSE finds the SQL Express on the server (using the Browse for more – Network server option), but the connection fails with error 26.

When I try to connect from MS Access 2003 I get the same error.

Thank for any help

Amihy

I found this link http://www.datamasker.com/SSE2005_NetworkCfg.htm maybe this will help you out.|||

Thanks for the link, it helped me understand that all my SQL settings are OK.

So I started to think about the network and at last found that NetBios over TCP\IT was disabled. It did not bother me before since the local network works with NetBEUI protocol.

Once I enabled TCP\IP over NetBios in Local Area Connection-Properties-TCP\IP properties-General-advanced-wins, The client immediatly connected to the server.

|||good to hear your ok now