1 Attachment(s)
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
Re: MS SQL 2000, remote connection
This looks wrong:
Code:
"Data Source=192.36.66.139,1433;
Should probably be this:
Code:
"Data Source=192.36.66.139:1433;
Re: MS SQL 2000, remote connection
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"
Re: MS SQL 2000, remote connection
You may want to have a look at this. And have you applied all the service packs?
Re: MS SQL 2000, remote connection (fixed issue)
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.
Re: MS SQL 2000, remote connection
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.