RE: Can't access Sql Server Express 2005

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello Dave,

I assume you are using the SqlDataSourceEnumerator class to enumerate the
server.

The GetDataSource method for the SqlDataSourceEnumerator class will return
a datatable.

The table returned from the method call contains the following columns, all
of which contain string values:

Column Description :
ServerName
Name of the server.

InstanceName
Name of the server instance. Blank if the server is running as the default
instance.

IsClustered
Indicates whether the server is part of a cluster.

Version
Version of the server (8.00.x for SQL Server 2000, and 9.00.x for SQL
Server 2005).

You need to check the InstanceName in your application to decide which
instance you need to connect.

Retrieving an Enumerator Instance
http://msdn2.microsoft.com/en-us/a6t1z9x2.aspx

Hope this will be helpful.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • Re: Enumerate volumes on a server
    ... To enumreate volumes the server is offering or sharing via a NAS protocol, ... To enumerate volumes attached to the server, ... Use your favorite search web site and you should find plenty of WMI scripting examples. ...
    (microsoft.public.windows.file_system)
  • Re: Pen-Testing New Server - Where to start?
    ... For example, you can enumerate services ... attacker gets access) you could smoke a joint (thinking higher, ... running on the HTTP port) and try to exploit them. ... penetration-testing a new server I've set up at home. ...
    (Security-Basics)
  • ASP.NET site hangs when schtasks /v switch is invoked
    ... will enumerate the scheduled tasks on a certain server. ... However, when I tack on a /v switch to the end of that, the site hangs ... fine from a command prompt against remote servers so it is something to ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Cant access Sql Server Express 2005
    ... I assume you are using the SqlDataSourceEnumerator class to enumerate the ... The GetDataSource method for the SqlDataSourceEnumerator class will return ... Name of the server. ...
    (microsoft.public.sqlserver.setup)
  • Re: Get SQL Server version of each instance installed
    ... There must be an SQL query (when you connect to the default ... The problem is that I don't know how many instances each server is ... ' Enumerate account balances. ...
    (microsoft.public.windows.server.scripting)