Connect to database using sql server remotely

Question

I have finished a program using sql server and visual studio using c# language . I want to put the database on pc and the program that connected to that database on other PCs

I'm using this connection string in App.config :

<connectionStrings>
<add name="MWEConnectionString" connectionString ="integrated security=yes;initial catalog=MWDB;data source=.\sqlexpress"/>
</connectionStrings>

Should I change server name by pc external ip address? and according to sql server Should I use windows authentication or what? I don't know how to do it.

TehBoyan · Accepted Answer · 2011-12-28 12:50:08Z

5

You should access the server by it's address by using Sql Server authentication.

Your connection string should look something like this:

connectionString="Data Source=192.168.0.5\SQL2008R2;Initial Catalog=MWDB;Persist Security Info=True;User ID=user;Password=password"

(this is just an example, your settings will probably be different).

Another example:

connectionString="Data Source=NAMEOFCOMPUTER\SQL2008R2;Initial Catalog=MWDB;Persist Security Info=True;User ID=user;Password=password"

for accessing the server by name.

You can generate a connection string for your application from Visual Studio. From Database Explorer -> Connect to Database

answered Dec 28, 2011 at 12:50

TehBoyan

6,9163 gold badges48 silver badges65 bronze badges

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

Comments

4b0 · Accepted Answer · 2011-12-28 12:52:59Z

2

see:
http://connectionstrings.com/sql-server-2005

http://connectionstrings.com/sql-server-2005#p1

answered Dec 28, 2011 at 12:52

4b0

22.4k30 gold badges97 silver badges143 bronze badges

2 Comments

TehBoyan Over a year ago

+1 for the links. They give a wider view on the subject then just the specific problem the user has.

moonshine Over a year ago

when I try to connect the program after setup it to remote sql server database ,it display that error: login failed for user 'user'The user is not associated with a trusted SQL Server connection and remote connection and sql server explorer is already running I don't know how to solve this problem can any body help me??

Collectives™ on Stack Overflow

Connect to database using sql server remotely

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related