Connect a C# MVC application to a remote SQL Server database

Question

I have a SQL Server database located at http://192.168.10.3/MyDB. I have created a C# MVC application, and I need to know the steps to connect my application to the above database.

Is it only replacing the connection string in the web.config file ?

Data Source=?? ;Initial Catalog=??;Integrated Security=SSPI;
User ID=??;Password=pwd;

If so what am I to replace where I have placed the ?? sign ?

Malcolm O'Hare · Accepted Answer · 2013-04-02 19:37:36Z

5

DataSource = 192.168.10.3
Initial Catalog = MyDB
User ID = whatever sql login you are using to access your SQL Server
Password = password for the sql login above

answered Apr 2, 2013 at 19:37

Malcolm O'Hare

5,0393 gold badges36 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sharon Watinsan Over a year ago

So i need not do anything else, but only just replace these values ?

Malcolm O'Hare Over a year ago

Yup. There are other settings you could add but that is all a basic connection string requires.

wilsjd · Accepted Answer · 2013-04-02 22:17:20Z

3

The other answers here are good. In addition, ConnectionStrings.com can be your friend, especially if you are going to connect to various types of databases in the future. Select the database that you need to connect to and then you'll see the different connection strings you can use for that database.

http://connectionstrings.com/sql-server-2012#sqlconnection

answered Apr 2, 2013 at 22:17

wilsjd

2,2682 gold badges24 silver badges40 bronze badges

Comments

Vikramsinh Shinde · Accepted Answer · 2013-04-02 19:45:13Z

1

you can try this

create a new text document on your desktop - conn.txt
change file extension to udl (conn.udl)
double click to open the file in the first tab select appropriate provider 4 . in the second tab enter server name (ip address,port), username, password (check Allow saving password) and database name.
test connection
if the test reports success close the window.
open the file with notepad, copy everything but the provider name and paste it back to connectionString

answered Apr 2, 2013 at 19:45

Vikramsinh Shinde

2,8832 gold badges26 silver badges30 bronze badges

Comments

Alireza Abdollahnejad · Accepted Answer · 2020-01-13 06:47:04Z

0

Below is connection string you need for:

Data Source="192.168.10.3" ;Initial Catalog=MyDb;Integrated Security=SSPI; User ID=sa (for example);Password=whatever you set before;

answered Jan 13, 2020 at 6:47

Alireza Abdollahnejad

1,0679 silver badges9 bronze badges

Collectives™ on Stack Overflow

Connect a C# MVC application to a remote SQL Server database

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related