MS SQL 2000, remote connection

[Andrzej]

thanks for help.

I found the solution.

The problem wasn't in my ConnectionString but there was a bug in MS SQL 2000 SP3.



1. I downloaded the last SP ( MS SQL 2000 SP4 , http://www.microsoft.com/downloads/d...displaylang=en

2. install as follows:

setup SAPWD="password" SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0

3. go to FIREWALL settings ->Exceptions->Add New Port:
app_name
port_number (default is 1433)

4.
modify connectionString

Sqlconnection tcpConn;
// example
tcpConn = "Data Source=192.168.1.101,1433;Network Library=DBMSSOCN;Initial Catalog=" + db_name + ";User ID=sa;Password=";
// ... 

it works perfect.