How to find Installed Sql Servers & Instances in Local Machine?

Question

0.00/5 (No votes)

See more:

VB

Hi,

How to list the installed Sql Servers and instances in Local Machine using VB.Net?

Posted 2-Mar-15 1:40am

kgmmurugesh

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 · 2015-03-02T01:42:00

Solution 1

Try starting here:

VB

Dim instance As SqlDataSourceEnumerator = SqlDataSourceEnumerator.Instance
Dim dt As DataTable = instance.GetDataSources()
For Each row As System.Data.DataRow In dt.Rows
    Console.WriteLine("ServerName = {0}", row("ServerName"))
Next

Posted 2-Mar-15 1:42am

OriginalGriff

Comments

kgmmurugesh 2-Mar-15 8:00am

It shows network servers only. I want local server (My Computer)

OriginalGriff 2-Mar-15 8:14am

Why?
The only time you should be using a local server is in development: proliferating SQL servers in a production environment is a very, very bad idea.

And for development, it's simple: you just need to use VS and it'll give you the complete connection string...

kgmmurugesh 2-Mar-15 8:23am

No, What I want is to check the given sql server instance is in Local Computer or Network Computer?

OriginalGriff 2-Mar-15 8:34am

Two things you can do:
1) Look at the instances returned, and check for you PC host name at the start.
2) Connect to teh server, and issue the query:
SELECT HOST_NAME()
which will return the PC ID. But...what it will return for a clustered SQL farm, I don't know... :laugh:

kgmmurugesh 2-Mar-15 8:38am

It will not return instances installed in my PC. It only return the instances installed in network systems.

OriginalGriff 2-Mar-15 10:57am

Then you need to look at the instances installed on your machine, and make sure they are running: it returns the names of all visible SQL server instances - and that includes local one. It certainly works on my PC!

kgmmurugesh 3-Mar-15 4:48am

But, It will not show in my computer, SQL Server Management Studio shows local servers, How?

OriginalGriff 3-Mar-15 5:52am

I can;t say - it does show in mine.
Did you check that the local instances are running?

kgmmurugesh 7-Mar-15 4:14am

Yes, It is running

OriginalGriff 7-Mar-15 5:11am

And when you copy and paste that code, what exactly does it output?

kgmmurugesh 7-Mar-15 6:08am

use the following link to see the output.

Screen file is the output of your code, Screen1, Screen2 are the output taken from SQL Server Management Studio.

https://drive.google.com/folderview?id=0B5a-bv4fFkeGfnNUUXJCRElVOEp4amtCV0x6TklrN2VQdEYwTWxMUFh1elhtYklYWHNESkE&usp=sharing

OriginalGriff 7-Mar-15 6:33am

You are kidding, right?
It's been four days, and you never considered that there might be more information in the datatable than just the server name? Like a column called "InstanceName" as well?

:sigh:

Add this line to the loop:

Console.WriteLine("InstanceName = {0}", row("InstanceName"))

And try it again...

And are you seriously running 4 SQL server instances on one computer? Why? Even if there two different revisions...

kgmmurugesh 7-Mar-15 6:58am

use the old link to see the screen shot. It is in the name of screen3

OriginalGriff 7-Mar-15 7:05am

Yes. Any more questions?

kgmmurugesh 7-Mar-15 7:08am

I've not yet got the result.

OriginalGriff 7-Mar-15 7:21am

I do hope you are joking.
The thought that you can't connect two pieces of information in separate strings together is a little frightening...

Please, tell me you are joking!

kgmmurugesh 7-Mar-15 7:49am

No, It is true, If you have any doubt see my system through teamviewer.

OriginalGriff 7-Mar-15 8:04am

So...in your DropBox, you have the results from SSMS that you want:
OFFICE\GFT
OFFICE\KGMEXPRESS
OFFICE\SERVERR2
OFFICE\SQLEXPRESS

And also in your dropbox, you have the results:
ServerName = OFFICE
InstanceName = KGMEXPRTESS
ServerName = OFFICE
InstanceName = SERVERR2
ServerName = OFFICE
InstanceName = GFT
ServerName = OFFICE
InstanceName = SQLEXPRESS

And you can't convert the latter to the former?
Here is a clue:

Dim MyServerComplete As String = "OFFICE" & "\" & "KGMEXPRESS"

Does that make sense?

If not, add this line to the loop:

Console.WriteLine("The full name I am looking for is: {0}\{1}", row("ServerName"), row("InstanceName"))

And see if that tells you anything...

kgmmurugesh 9-Mar-15 0:37am

I want the output shown in screen1 (Local Instances) & Screen2 (Network Instances),
the screen1 & screen2 are taken from SSMS.