client to client connection

Hot Topic

Showing server status in SSMS
SQL 2005 BI Capabilities
Aspnet_Profile data extraction
Help with SUM
Ad hoc updates to system catalogs are not allowed.
Will SQL Express run on Win2k3 Web Edition?
Hundreds Of VIEWS
How To Update data?
SSIS Script Task and Other Assemblies/DLLs
Data types in SQL Server

SQL Server

Automatic synchronization of lookup columns
How to call Integration Services Project from Web UI
In a list prompt
Executing .sql file using in .NET
I hate VS 2005 SQL pane
SQL Mail
Merge Replication with SQL Mobile Server 2005 / SQL Server 2005
Collation Conflict Error 368 (I think)
installation bug found SQL Server 2005
sql express

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

thanks

Answer this question

client to client connection

  • Andy Kemshall

    By 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.

  • client to client connection
Answer this question