How to use Sql server database on remote server

Question

0.00/5 (No votes)

See more:

Hi Guys,

I have a asp.net application using sql server 2005 database it run on localhost fine but when i used on remote server database working. plz any one suggest me what to do

Thank you in advance.

Posted 23-Sep-11 22:10pm

Sumit Kumar Singh India

Add a Solution

Comments

André Kraak 24-Sep-11 4:11am

Your question is to vague, please try rephrasing it and/or be more specific.
Please mentioned any error messages you are receiving and/or supply code that is relevant to your question.

If you wish to change your question use the Improve Question button.

RaisKazi 24-Sep-11 4:12am

What error you are facing?

Sumit Kumar Singh India 24-Sep-11 5:22am

Actually i want to host my site and i want to use database on remote server. no any exception occurs but no data found in database so i think i have to import database but i dont know how?

P.Salini 24-Sep-11 6:55am

First insert data into database and then check.

2 solutions

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)

OriginalGriff · Accepted Answer · 2011-09-23T22:13:00

The first thing to do is try to connect to the remote database using either SQL Server Management studio or VS via the Server explorer window. If you can do this, then the properties pane can show you the connection string which will work to that server instance and database.

If it doesn't, then you need to look at any error messages - they may help.
It could be a firewall problem, it could be that the remote database is not configured to accept remote connections.
With the info you have given, a more accurate answer if very difficult to give.

Prasanth S · Accepted Answer · 2011-09-23T22:55:00

Solution 2

While connecting to database in a remote server you have to check whether it provides a remote port for connection, if so you have to add the port also to the connection string.

See the example

<add name="ConnectionString" connectionstring="Data Source=[IP/ServerName],[RemotePort];Initial Catalog=[DBName];Persist Security Info=True;User ID=[username];Password=[password]" providername="System.Data.SqlClient" />

Posted 23-Sep-11 22:55pm

Prasanth S

Updated 23-Sep-11 22:56pm

v2

Comments

Sumit Kumar Singh India 24-Sep-11 5:20am

Actually i want to host my site and i want to use database on remote server.

after settin following same problem(not exception error but no data found in database so i think i have to import database but i dont know how?)
<add name="ConnectionString" connectionstring="Data Source=[IP/ServerName],[RemotePort];Initial Catalog=[DBName];Persist Security Info=True;User ID=[username];Password=[password]" providername="System.Data.SqlClient">

Sumit Kumar Singh India 24-Sep-11 5:21am

OriginalGriff 24-Sep-11 7:02am

If you aren't getting an error of any form, then it is likely that the database contains no data - you don't have to attach it if SQL server knows where it is.

Sumit Kumar Singh India 29-Nov-11 5:07am

thanks you so much!!!!

Prasanth S 24-Sep-11 10:38am

Use SQL Server Management Studio, go to tasks, choose script database, then choose option include data and schema, now you can generate the query containing data and schema. Run that query for remote database. The other option is to create all the tables and choose import option to import local data to remote database

lilian87 10-Jan-12 8:37am

I am having same pblm. I generated the script.U said, run the query for remote db. How can I do it?