Monday, March 19, 2012

ListAvailableSQLServers Problem

I have been using SQLDMO listavailableSQLServers . It displays all the
servers but it doesnt list the local machine in which SQL Server too is
running. Am i missin something?What is the local machine?

If it's xp with sp2 then see
http://support.microsoft.com/default.aspx?kbid=841249

Nigel Rivett
www.nigelrivett.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||What is the local machine?

If it's xp with sp2 then see
http://support.microsoft.com/default.aspx?kbid=841249

Nigel Rivett
www.nigelrivett.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||What is the local machine?

If it's xp with sp2 then see
http://support.microsoft.com/default.aspx?kbid=841249

Nigel Rivett
www.nigelrivett.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||What is the local machine?

If it's xp with sp2 then see
http://support.microsoft.com/default.aspx?kbid=841249

Nigel Rivett
www.nigelrivett.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||What is the local machine?

If it's xp with sp2 then see
http://support.microsoft.com/default.aspx?kbid=841249

Nigel Rivett
www.nigelrivett.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||What is the local machine?

If it's xp with sp2 then see
http://support.microsoft.com/default.aspx?kbid=841249

Nigel Rivett
www.nigelrivett.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||What is the local machine?

If it's xp with sp2 then see
http://support.microsoft.com/default.aspx?kbid=841249

Nigel Rivett
www.nigelrivett.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||What is the local machine?

If it's xp with sp2 then see
http://support.microsoft.com/default.aspx?kbid=841249

Nigel Rivett
www.nigelrivett.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||What is the local machine?

If it's xp with sp2 then see
http://support.microsoft.com/default.aspx?kbid=841249

Nigel Rivett
www.nigelrivett.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||no its not XP.. its 2000.
I have installed SQL server in 3 machines in network includin the one
where i am running the application. now with listavailableservers it
shows the other 2 machines but not the one on where i am working on.|||Is your local database available over the network? Have you enabled a
network protocal using svrnetcn.exe? I noticed the other day that the
documentation says that ListAvailableSQLServers lists 'network-visible
instances' of SQL Server...

I have been suffering a similar (but different) problem. On XP it
appears to decide that if you are not connected to a network then the
server is not 'network-visible' and therefore the (local) server is not
listed. Hmm...

Any suggestions on how to detect if SQLServer is running on the local
machine when it's not connected to a network?

Neil

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

No comments:

Post a Comment