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;I ntegrated
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;Netwo rk Library=DBMSSOC N;Initial
Catalog=DBANK;U ser ID=myID;Passwor d=myPASSWORD;"

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

Thanks.

Rgds,
GC

Sep 28 '05 #1

Subscribe Reply

1606

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
EnterpriseManag er?

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;I ntegrated
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;Netwo rk
N> Library=DBMSSOC N;Initial Catalog=DBANK;U ser
N> ID=myID;Passwor d=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

Sep 28 '05 #2

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
EnterpriseManag er?

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;I ntegrated
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;Netwo rk
N> Library=DBMSSOC N;Initial Catalog=DBANK;U ser
N> ID=myID;Passwor d=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

Sep 28 '05 #3

Similar topics

2031

server bootstrapping upon connection (WARNING: LONG)

by: Fortepianissimo | last post by:

Here is the situation: I want my server started up upon connection. When the first connection comes in, the server is not running. The client realizes the fact, and then starts up the server and tries to connect again. This of course all happens on the same machine (local connection only). The connections can come in as fast as 30+/sec, so the server is threaded (using SocketServer.ThreadingTCPServer). Further, the server initialization...

Python

3943

remoting client in IIS request server waiting permenantly when the network connection broken

by: Dicky Cheng | last post by:

Hi, I am using .net remoting technology. I set up a .net remoting client and server in IIS. When the client calls the server, the server will run a long duration method (30-60seconds). I have a test on it that if the network broken at the time the client have already send the remoting request and waiting for the server, the client side will wait infinitely by default, even if i already set the executionTimeout to 90seconds in...

.NET Framework

8749

SQL Server Connection String

by: Fred Zuckerman | last post by:

Hello All, After reading in this group about the preference for connecting to a SQL Server using a connection string instead of a DSN file, I have done just that. BUT, I cannot update my data. I have gone back and forth between using a DSN file and a DSN-less connection string and I have found the following issue. When I utilize the DSN file to create the link, there is a step where it asks me to identify a unique key for the file. If I...

Microsoft Access / VBA

1314

SQL Server does not exist or access denied

by: RKay | last post by:

I have a Win2k server running SQL Server 2000. On that box I built a working web service that pulls data from the database. One of the services available simply accepts an ado.net connection string to test if a connection can be made to the local server. I can call that web service from any box on my network, and with the correct connection string, I can establish a connection to the database. However, when I copy the exact same service...

ASP.NET

3922

Connecting to Server Problem

by: Suresh | last post by:

Hi Guys I have Db2 server installed on remote server. i am connecting to that remote server by using VPN. I want to connect that remote DB2 server instance using my local machine DB2 development client. Bur Its gives me following error message. I searched lots of things on net and tried on remote server but i didnt got suceess. Can any one tell me how to set TCP\IP connection protocol on server for particular instance. Becuase I think

DB2 Database

7042

HELP! Why is SqlException being caught in this code if it can't connect to SQL Server?

by: Marcus | last post by:

I have a function that simply returns TRUE if it can connect to a particular Sql Server 2005 express, or FALSE if it cannot. I am getting some strange error codes returned when the computer that sql server resides on is not reachable. The error is different depending on the connection string that I use. If I use the following connection string: "server=192.1.1.1; Initial Catalog=master; uid=The_User; password=The_Password; Connect...

Visual Basic .NET

14504

Determine whether SQL Server exists

by: _DD | last post by:

I'd like to include a 'Test Connection' button in an app, for testing validity of a SQL connection string. I'd prefer to keep the timeout low. What is the conventional way of doing this?

C# / C Sharp

2654

ASP and SQL Server 2005 Express

by: Anil Gupte | last post by:

I am using the following to try to connect to the database, but it does not seem to be working. Dim sConnString sConnString = "Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MediaDB;Data Source=MEDIAMACHINE\SQLEXPRESS" Connection.Open sConnString Dim Recordset Set Recordset=Server.CreateObject("ADODB.Recordset")

ASP / Active Server Pages

5869

Mysql database in UTF8, PHP shows latin1 (iso-8859-1)

by: alex | last post by:

I've converted a latin1 database I have to utf8. The process has been: # mysqldump -u root -p --default-character-set=latin1 -c --insert-ignore --skip-set-charset mydb mydb.sql # iconv -f ISO-8859-1 -t UTF-8 mydb.sql mydb_utf8.sql mysqlCREATE DATABASE mydb_utf8 CHARACTER SET utf8 COLLATE utf8_general_ci;

PHP

3559

Error "SQL Server does not allow remote connections"

by: Cirene | last post by:

I just deployed my new ASP.NET (3.5 FW) site to the hosting company I'm using, webhost4life. NOTE: I HAVE deployed other SQL Server sites to the same account with no issues. Now I'm getting this error. Any idea why? Server Error in '/myuser4/MyWebApp' Application. --------------------------------------------------------------------------------

ASP.NET

10223

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10000

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8879

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7413

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6675

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5448

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3968

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3571

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2815

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General