Connect to database from network

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

Hi,
I connect to database on server with this connection string.

SQL

Data Source=.;Initial Catalog=test;Integrated Security=true

How can I connect to this database from another computer on network? I use this connection string but it's not work.

SQL

Data Source=192.168.1.6\SQLEXPRESS;Initial Catalog=test;Integrated Security=true

Posted 27-Apr-14 6:45am

taghit

Add a Solution

Comments

Dave Kreskowiak 27-Apr-14 12:50pm

Do you get an error message? What is it?
Is your SQL Server Express setup to accept remote connections?
Are your computers setup in a domain environment?
Is the user running the code on the remote machine trusted by the database?

[no name] 27-Apr-14 12:51pm

Do you have an Windows user account on 192.168.1.6?

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 · Accepted Answer · 2014-04-27T07:18:00

In my experience, unless the application is on the same computer as the database, Integrated Security=true requires that the user be signed on with a domain account and not a local Windows account. Because your example includes a 192.168.*.* IP Address, I assume that you are not running in an environment where you are logged on with a domain account.

Therefore, instead of using Integrated Security=true, use Integrated Security=False;User id=xxxxx;Password=yyyy where xxxxx is a user id configured into the database server and yyyy is the password for user id xxxxx.

To enable SQL Server to use SQL Server Authentication and accept remote connections
In SQL Server Management Studio, right-click on the server name and click properties. In the Connections page, ensure that Allow remote connections to this server is checked. In the Security folder, click on SQL Server and Windows Authentication mode. Click the OK button. Restart the SQL Server service.

To create a SQL Server User Id
In SQL Server Management Studio, left-click on the Security folder under your server, then right-click Logins and left-click New Login. In the Login - New dialog window, check the SQL Server authentication radio button, enter a Login name and a Password in the appropriate textboxes, and uncheck the User must change password at next login checkbox. Click OK.