EnumAvailableSqlServers and sqlexpress

[Torben Laursen]

Hi

I am trying to find find the sqlserver express that is running on my
computer using:
DataTable dtSQLServers = SmoApplication.EnumAvailableSqlServers(false);

It returns one row that holds the name "Office1" but the sqlserver is:
"Office1\SQLExpress"

If I try to connect to "Office1" I get a very long errormessage while if I
connect to "Office1\SQLExpress" it works fine.

How do I get EnumAvailableSqlServers to return the "correct" name?

Thanks Torben

[Willy Denoyette [MVP]]

"Torben Laursen" <To****@newsgroups.nospamwrote in message
news:uE**************@TK2MSFTNGP04.phx.gbl...

Hi

I am trying to find find the sqlserver express that is running on my computer using:
DataTable dtSQLServers = SmoApplication.EnumAvailableSqlServers(false);

It returns one row that holds the name "Office1" but the sqlserver is:
"Office1\SQLExpress"

If I try to connect to "Office1" I get a very long errormessage while if I connect to
"Office1\SQLExpress" it works fine.

How do I get EnumAvailableSqlServers to return the "correct" name?

Thanks Torben

What column are you looking at?

Willy.

[Torben Laursen]

I am looking at Name and server.
I have a second office computer on the network that also runs sqlexpress and
the code returns the correct name for that one.

First row: (network computer)
Server: Office3
Name: Office3\\SQLexpress

Second row (computer where the code runs)
Server: Office1
Name: Office1

Torben
"Willy Denoyette [MVP]" <wi*************@telenet.bewrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...

"Torben Laursen" <To****@newsgroups.nospamwrote in message
news:uE**************@TK2MSFTNGP04.phx.gbl...

>Hi

I am trying to find find the sqlserver express that is running on my
computer using:
DataTable dtSQLServers = SmoApplication.EnumAvailableSqlServers(false);

It returns one row that holds the name "Office1" but the sqlserver is:
"Office1\SQLExpress"

If I try to connect to "Office1" I get a very long errormessage while if
I connect to "Office1\SQLExpress" it works fine.

How do I get EnumAvailableSqlServers to return the "correct" name?

Thanks Torben

What column are you looking at?

Willy.

[Willy Denoyette [MVP]]

"Torben Laursen" <To****@newsgroups.nospamwrote in message
news:u7**************@TK2MSFTNGP06.phx.gbl...

>I am looking at Name and server.
I have a second office computer on the network that also runs sqlexpress and the code
returns the correct name for that one.

First row: (network computer)
Server: Office3
Name: Office3\\SQLexpress

Second row (computer where the code runs)
Server: Office1
Name: Office1

Does this mean that the instance column is empty?

Willy.

[Torben Laursen]

Yes, the information is:
First row: (network computer)
Server: Office3
Instance: Sqlexpress

Name: Office3\\SQLexpress
Second row (computer where the code runs)
Server: Office1
Name: Office1
Instance: {}

Torben

"Willy Denoyette [MVP]" <wi*************@telenet.bewrote in message
news:uK**************@TK2MSFTNGP06.phx.gbl...

"Torben Laursen" <To****@newsgroups.nospamwrote in message
news:u7**************@TK2MSFTNGP06.phx.gbl...

>>I am looking at Name and server.
I have a second office computer on the network that also runs sqlexpress
and the code returns the correct name for that one.

First row: (network computer)
Server: Office3
Name: Office3\\SQLexpress

Second row (computer where the code runs)
Server: Office1
Name: Office1

Does this mean that the instance column is empty?

Willy.