MS SQL 2000, remote connection

Hello

I try to play with Microsoft SQL 2000 ( 8.0 ).
I'm able to connect when I run my application where the MS SQL 2000 is installed.
Could you please help me to build ConnectionString to make remote connection.

I do it as folows ( ... but I catch error "{SQL Server does not exist or access denied.} " )

Code:

---


SqlConnection myCon = new SqlConnection();
myCon.ConnectionString = "Data Source=192.36.66.139,1433;Network Library=DBMSSOCN;Initial Catalog=" + dbname + ";User ID=sa;Password="

---

btw, I found some helpful info about conn.str on the web, but it doesn't work for ms sql 2000.
http://www.connectionstrings.com/?carrier=sqlserver

here is configuration of my MS SQL Server 2000

This looks wrong:

Code:

---

"Data Source=192.36.66.139,1433;

---

Should probably be this:

Code:

---

"Data Source=192.36.66.139:1433;

---

thanks for replay,

Code:

---

Data Source = 192.36.66.139:1433

---

it throw new error "Specified SQL Server 192.36.66.139:1433 not found"

You may want to have a look at this. And have you applied all the service packs?

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

Code:

---

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.

That's why I asked in my previous post if you have applied all service packs since similar cases existed wherein applying SP4 just solved their problems. Glad it worked for you also.