connect to SQL from a client written in C#

Question

4.50/5 (2 votes)

See more:

Suppose you have installed SQL Server Express 2008 R2 on a PC and you want to write a program(in C#) able to connect(make queries) to a database hosted by the mentioned database engine, but the program will be running on another machine; all machines are in the same network(even the same workgroup - Assume a network in your home)

You want to use Entity Data Model Framework to make your life easier.

How can you solve the problem? How do you make the program able to recognize the SQL Server on another machine? How do you connect to the database?

Posted 13-Nov-10 13:21pm

arpoarpo

Add a Solution

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)

Kanasz Robert · Accepted Answer · 2010-11-13T22:07:00

Solution 1

Hi,
just add to web.config connectionstring section with connection string and and set data source to valid name of instance

XML

<connectionStrings>
   <add
      name="LocalSqlServer"
      connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
      providerName="System.Data.SqlClient"
   />
</connectionStrings>

http://msdn.microsoft.com/en-us/library/bf7sd233.asp[^]

but don't forget to set all connection string properties of all object working with database.

Regards
Robert

Posted 13-Nov-10 22:07pm

Kanasz Robert

Comments

arpoarpo 14-Nov-10 9:26am

Thank you Robert, I was confused 'cause the machines were over a network and the connection string can't use a Trusted_Connection. I was doing test in the same PC where the SQL Server is intalled and everything were fine because you can use Windows Authentication to connect to database but when I was running the program on another PC with that Connection String I was receiving ERRORS.

Thank you so much for your answer,

Best Regards, Angel

Kanasz Robert 14-Nov-10 12:04pm

Hi,
can you set SQL Authentication mode on SQL Server to mixed mode? That could help you.