How to get Sever name to be used for SQL Server instance

Question

0.00/5 (No votes)

See more:

Hi,
Could any body give me code to get server name of the computer that client computers connect to access SQL Server database?

Thanks

Posted 19-Jan-12 3:19am

Furqan Sehgal

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)

OriginalGriff · Answer 1 · 2012-01-19T03:33:00

Solution 1

Not the specific one, if there are more than one, but:

C#

SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance;
DataTable dt = instance.GetDataSources();
foreach (System.Data.DataRow row in dt.Rows)
    {
    Console.WriteLine("ServerName = {0}", row["ServerName"]);
    }

Posted 19-Jan-12 3:33am

OriginalGriff

Comments

Furqan Sehgal 19-Jan-12 11:58am

Added to my confusion. My purpose is that when I my client installs client side of the application, he could enter the server name on which database has been attached by the Server side installation.
Don't we need to know exact server name in the given case?

OriginalGriff 19-Jan-12 12:08pm

Yes, but unless your software installed the database - in which case you already know the server instance and the database name - he probably won't.
Most users don't even know their own PC name, let alone the SQL server instance names. :laugh:
That fragment lists all the instance names - you could let the user pick one (if there is more than one) or scan each looking for your database. The latter is much more user friendly - and not that hard to do.