Sunday, February 19, 2012

client to client connection

hi we have a sql 2k installed on one server and 2 clients installed with sql server 2005 express..

clients pc are winxp..is it possible to connect from one client to one client pc using the sql express?

thanksBy default, SQL Server Express is not configured to accept remote connections, which helps reduce the risk of attack via the SQL Server service. If you do need to access your Express server from other machines, you can enable remote connections using the Surface Area Configuration tool.

You will probably need to open the TCP port your Express servers are listening to in your firewall as well. The default port number is 1433.

No comments:

Post a Comment