how to access sql server express from other computer on the netwrok

Hi experts

I use a sqlserver on a local computer. i want to access the sqlserver from other computers on the network using the VWD. When trying to connect to the database i get the error:

"An error has occured 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)"

I enabled the TCP/IP and the Named Pipes protocols on the server and still the same error.

Thanks

check windows firewall enbale or not..

if yes, then let sql 2005 port pass through

|||

I just found the sollution.

1. when accessing from other computers, the servers 'Guest' account is used, so this accoun should have the correct permissions (not recommended) or access using another privileged acount

2. enable remote connection in the "SQL Serve surface area Configuration" tool

Thanks for the attention anyway