Please help me on obtaining "server" and "data source" in string connection for sql connection?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

Dear Buddies:

I have a sql db with its application. I bring this program and the associated sql database to another computer. How can I get the "server" and "data source" of new computer for string connection in sql connection? I should mention that I do not have any info. about the guest computer and assume that the guest computer does not have any sql managemnt system, so my application should obtain the "server" and "data source" to work properly.

Yours

Posted 23-May-12 10:08am

Mmohmmad

Updated 23-May-12 10:40am

v4

Add a Solution

2 solutions

Solution 2

For Web Applications :

SQL

Data Source = .\.; integrated Security= true; Database=yourdatabasename;

For Windows Application :

SQL

Data Source=.\\.; integrated Security= true; Database=yourdatabasename;

Now in place of Server or Datasource first . works understood Default SQL Server and Second . stand Default Instance.

Posted 23-May-12 18:14pm

John Bhatt

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)

Wendelius · Accepted Answer · 2012-05-23T10:13:00

Solution 1

Visit Connection strings for SQL Server 2008[^]

Also one nice way to resolve server name and instance is to open Sql Server Management Studio, connect to the database and then in the properties box, you should see the server name and instance.

Addition:

Example of current connection string to a local Sql Server database:

Server=(local)\MyInstance;Database=TestDatabase;Trusted_Connection=True;

Example of a connection string that clients use to connect to a single Sql Server database:

Server=ServerXYZ\TheInstanceName;Database=ProductionDatabase;Trusted_Connection=True;

Posted 23-May-12 10:13am

Wendelius

Updated 23-May-12 11:33am

v2

Comments

Mmohmmad 23-May-12 17:04pm

Dear Mika:

I should mention that I do not have any info. about the guest computer and assume that the guest computer does not have any sql managemnt system, so my application should obtain the "server" and "data source" to work properly.

Wendelius 23-May-12 17:13pm

That's quite alright.

The connection string is just a string that you define with your SqlConnection. You can store the string inside the application or put it in a configuration file and read it from the etc.

The necessary client libraries to connect to remote Sql Server are included in the .Net framework installation so you doon't have to worry about those.

The reason I mentioned Management Studio was that sometimes people don't know the name or the IP address or the instance name of the Sql Server on the server. That's why it's sometimes handy to check the name from management studio, but the installation of management studio isn't necessary on the client at all. Actually it shouldn't be installed unless the user really needs it.

So to sum it: You just need to put up a correct connection string and use that for the SqlConnection and it'll work perfectly.

Mmohmmad 23-May-12 17:23pm

Dear Mika:

Thanks for your answer. however, in my previous question (http://www.codeproject.com/Questions/390531/SQL-server-Programing) you said that if I change the computer I should change the string connection in order to establish correct connection. I can not save connection string inside the application because the nature of my program is in the way that it should be run on the other computers so the string connection will be changed.

Wendelius 23-May-12 17:33pm

What I mean is that if you change the setup so that you now connect to your own local database you would have one kind of connection string. When you want to connect to another, remote Sql Server you need to change the connection string. However, all the clients that connect to the same Sql Server database on the same remote server have the same connection string. Well, there are some situations when this isn't correct, but usually it is.

So when you have built your connection string, all the clients should be able to use the same.

It's a good practice not to store the connection string, but you don't need to change the connection string unless you want to connect to a different server. :)

I updated the answer with examples.

Espen Harlinn 23-May-12 18:23pm

Well done :-D

Wendelius 24-May-12 15:03pm

Thanks :)

VJ Reddy 23-May-12 20:58pm

Well explained. 5!

Wendelius 24-May-12 15:04pm

Thank you VJ :)

Mmohmmad 24-May-12 0:52am

Dear Mika:

I think I should open my problem. I design my application in my own computer as well as its sql db. Then I will sell my application an its sql file to a customer. The customer set up my application in his own computer so the sitution should be in the way that he can use his own sql file not mine. So Here the problem is raised and his application should obtain the SERVER and DATA SOURCE for correct connection to sql. I think now you can guide me better

Wendelius 24-May-12 15:07pm

I see your problem. However, the basic idea doesn't change. Store the connection string in a configuration file which is distributed with the application.

During the installation the configuration file should be modified to contain proper information regarding to client environment. This can be done manually you you can create a small app to do it.

Either way the connection string should contain a proper server and instance information regarding clients SQL Server installation.

Mmohmmad 25-May-12 13:57pm

Dear Mika :
Thanks for your answer. I am not as expert as you in C#. Would you please guide my how to create an app to provide my necessary info in configuration file. Is it possible for you to show me an example program?

Yours.

Mmohmmad 25-May-12 13:53pm

Dear Mika :
Thanks for your answer. I am not as expert as you in C#. Would you please guide my how to create an app to provide my necessary info in configuration file. Is it possible for you to show me an example program?

Yours.

Mmohmmad 25-May-12 14:42pm

Dear Mika :
Thanks for your answer. I am not as expert as you in C#. Would you please guide my how to create an app to provide my necessary info in configuration file. Is it possible for you to show me an example program?

Yours..