SQL Server Connection with IP

[Niyazi]

Hi,

I have to connect SQL Server. In local SQL server my connection string is;
strConn = "Data Source=NTMS-2005;Initial Catalog=DBANK;Integrated
Security=SSPI;"

and I can connect very easily.

My problem is how to connect the Server PC that has the SQL Server. I used
following string but I failed. It says cannot find the SQL Server.

strConn = "Data Source=190.168.0.97,1433;Network Library=DBMSSOCN;Initial
Catalog=DBANK;User ID=myID;Password=myPASSWORD;"

I will be glad if someone will point me the right direction.

Thanks.

Rgds,
GC

[Michael Nemtsev]

Hello Niyazi,

There is everything ok with your connection string.
Have u ever tried to turn off firewall, or to connect to your remote DB through
EnterpriseManager?

N> I have to connect SQL Server. In local SQL server my connection
N> string is;
N> strConn = "Data Source=NTMS-2005;Initial Catalog=DBANK;Integrated
N> Security=SSPI;"
N> and I can connect very easily.
N> My problem is how to connect the Server PC that has the SQL Server. I
N> used following string but I failed. It says cannot find the SQL
N> Server.
N>
N> strConn = "Data Source=190.168.0.97,1433;Network
N> Library=DBMSSOCN;Initial Catalog=DBANK;User
N> ID=myID;Password=myPASSWORD;"

---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/members/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

[Niyazi]

Hi Michael,

I cannot turn off the firewall because of the restriction use of local LAN.
But the port 1433 is open from Network Administrator.

I createb the employee database using my (local) SQL Server and now they
want me to put the SQL server into Application server and the 5 user
(Management) can use the client application to view the Employee detail. It
is a 3 Tire application.

I had another PC with me which connected to my local switch and I will going
to try tomorrow.

By the way do you know how to attache SQL Server Database using VB.NET?
Also do you know how to back-up SQL Server with VB.NET. Or should I use SQL
Server for itself to do the backing up operation?

Thank you.

Rgds,
GC
"Michael Nemtsev" wrote:

Hello Niyazi,

There is everything ok with your connection string.
Have u ever tried to turn off firewall, or to connect to your remote DB through
EnterpriseManager?

N> I have to connect SQL Server. In local SQL server my connection
N> string is;
N> strConn = "Data Source=NTMS-2005;Initial Catalog=DBANK;Integrated
N> Security=SSPI;"
N> and I can connect very easily.
N> My problem is how to connect the Server PC that has the SQL Server. I
N> used following string but I failed. It says cannot find the SQL
N> Server.
N>
N> strConn = "Data Source=190.168.0.97,1433;Network
N> Library=DBMSSOCN;Initial Catalog=DBANK;User
N> ID=myID;Password=myPASSWORD;"

---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/members/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche