Communicating with database server from application server based on separate locations

Question

0.00/5 (No votes)

See more:

, +

I have 2 cloud servers with Win Server 2008 R2 OS on both, one is having MSSQL 2005 database and other server is serving ASP.Net application. Please help me to connect both the servers. I want to access database from my ASP.Net application. Both servers are having unique public IP addresses..... Thanks in advance

additional content copied from comment below
I have a ASP.Net application which needs MSSQL 2005 database. If I put ASP application and database on same computer it works fine. But now I want to shift my database server on another computer what should I write in connection string??

2nd addition
I tried to directly write IP address of the computer on which my database is. But if do it in LAN it works fine. And if the database computer is in another network (internet) and I try to enter the IP of that computer it shows error of cannot find server.

Posted 19-Dec-13 21:53pm

Member 10137773

Updated 20-Dec-13 1:47am

Nelek

v4

Add a Solution

Comments

Nelek 20-Dec-13 4:26am

What have you tried?[^]
If you need help, you should tell us where are you having problems. What you wrote is not a question, it is a requirement and noone is going to do your job for free.

Member 10137773 20-Dec-13 5:45am

I have a ASP.Net application which needs MSSQL 2005 database. If I put ASP application and database on same computer it works fine. But now I want to shift my database server on another computer what should I write in connection string??

An@nd Rajan10 20-Dec-13 6:01am

update your question..

Member 10137773 20-Dec-13 6:16am

In reference with above question....
I tried to directly write IP address of the computer on which my database is. But if do it in LAN it works fine. And if the database computer is in another network (internet) and I try to enter the IP of that computer it shows error of cannot find server.

An@nd Rajan10 20-Dec-13 6:21am

how to connect database via LAN i am struggling here...please help actually connection string was right, but mannaully set some properties in computer that was my mistake i think...can you help me..

Member 10137773 20-Dec-13 7:08am

You can just write in connection string the IP address of the computer where your database server in LAN. Connection string example.....

<add name="SQLCONNECTION" connectionstring="Data Source=192.168.1.5;Initial Catalog=TestDB;Persist Security Info=True;User ID=sa;Password=*********" providername="System.Data.SqlClient">

Member 10137773 20-Dec-13 7:09am

connectionString="Data Source=WIN-593UB69HKRK;Initial Catalog=testvivek;Persist Security Info=True;User ID=sa;Password=********"

Member 10137773 20-Dec-13 7:10am

I have a ASP.Net application which needs MSSQL 2005 database. If I put ASP application and database on same computer it works fine. But now I want to shift my database server on another computer what should I write in connection string??

I tried to directly write IP address of the computer on which my database is. But if do it in LAN it works fine. And if the database computer is in another network (internet) and I try to enter the IP of that computer it shows error of cannot find server.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mike Meinz · Answer 1 · 2013-12-20T01:54:00

Solution 1

Two links with information that might help you.

How to allow remote connections to SQL Server 2005 Express database[^]

Configure the Windows Firewall to Allow SQL Server Access[^]

Note that there will probably be firewalls and routers that block external access to the SQL Server. Those will have to be properly configured by the network administrators.

Posted 20-Dec-13 1:54am

Mike Meinz

Comments

Maciej Los 20-Dec-13 8:44am

5ed!

Member 10137773 21-Dec-13 1:50am

Configured the server as given in above links. Still facing same issue. My database server is on virtual machine instance like Amazon Web Service virtual instance. It is having a IP address provided me by my cloud vendor. So please tell me now how can I access the database on this server from my laptops internet connection. I am using default instance of SQL server and firewall is also turned off.

Mike Meinz 21-Dec-13 7:36am

I suggest that you contact your cloud vendor to get support.