Tuesday, March 27, 2012

EnumAvailableSqlServers does not return version numbers correctly

Hi,
I have a machine that has just SQL2005 (as default instance with no instance
name.) I am trying to list all SQL 2005 server instances on the network usin
g
SmoApplication.EnumAvailableSqlServers( ) and trying to filter the servers
based on version information. This machine shows up in the list, but does no
t
have version information. I saw another post on Sql Server Programming
newgroup without any response. Is this a known bug in SMO? If it is, does
anyone know how I can list SQL2005 servers only on a network that has both
SQL2005 and SQL2000 servers?
Any help is geratly appreciated.SMO in its current implementation uses
SqlDataSourceEnumerator.GetDataSources under the cover (
http://msdn2.microsoft.com/en-us/li...
etdatasources(VS.80).aspx)
Can you try writing calling this instead and see if you get the version?
This can help us isolate the problem.
Thanks,
--
Ciprian Gerea
SDE, SqlServer
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raghu" <Raghu@.discussions.microsoft.com> wrote in message
news:7EB858DE-22E5-41B3-B46A-1D8229406630@.microsoft.com...
> Hi,
> I have a machine that has just SQL2005 (as default instance with no
> instance
> name.) I am trying to list all SQL 2005 server instances on the network
> using
> SmoApplication.EnumAvailableSqlServers( ) and trying to filter the servers
> based on version information. This machine shows up in the list, but does
> not
> have version information. I saw another post on Sql Server Programming
> newgroup without any response. Is this a known bug in SMO? If it is, does
> anyone know how I can list SQL2005 servers only on a network that has both
> SQL2005 and SQL2000 servers?
> Any help is geratly appreciated.

No comments:

Post a Comment