how to connect remote database

Posted by Parthibansk under Sql Server on 12/27/2012 | Points: 10 | Views : 834 | Status : [Member] | Replies : 5
i deployed application on server.. for security constraints i want to keep the database remotely..

how to configure database ip..

for instance

123.55.222.222
uname:uname
pwd:pwd

is it same ipadress of my server[pc].. how to set ip for database..




Responses

Posted by: Ranjeet_8 on: 12/28/2012 [Member] [MVP] Gold | Points: 25

Up
0
Down
below is the eg. of connection string

<add name="ConnectionStr" connectionString="Data Source=Your_IP_Address;Initial Catalog=DataBaseName;Uid=Your_User_ID; Pwd=Your_Password;Connect Timeout=20;" providerName="System.Data.SqlClient" />


Parthibansk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Elephant12 on: 1/3/2013 [Member] Starter | Points: 25

Up
0
Down
If you want to connect from your home computer,then you need MYSQL database.

Parthibansk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sourabh07 on: 1/18/2013 [Member] Starter | Points: 25

Up
0
Down
Hi,

below is theconnection string which can be used in .net application to connect to remote database.

  <add name="ConnectionTest" connectionString="user id=uname ;password=pwd;Data Source=123.55.222.222;Database=databaseName"/>


Sourabh07

Parthibansk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Arjunan_Csharp on: 1/18/2013 [Member] Starter | Points: 25

Up
0
Down
1.Open web.config file from your application.
2.Go to "Connection strings"
3."Enter the servername or IPaddress" and its credentials in the connection string.

Parthibansk, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Kundan64 on: 1/23/2013 [Member] Starter | Points: 25

Up
0
Down
In your SSMS Connect to Server window in Server Name TextBox enter SERVER IP Address here 123.55.222.222 and then specify the Login and Pwd.

Parthibansk, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response