Ah, thanks, it was lost a bit in the translation. In English I would have said:

NetServerEnum only returns servers, whereas SQLDMO.ListAvailableSQLServers lists servers and services.

(Assuming that I am now understanding what you meant.)

So my next question is why am I not getting my SAMAAN3\SQLEXPRESS listed by the SQLDMO method?

Basically, what I am trying to do is if my initial SQLCONNECT() does not work I want to prompt the user for the server and database, then use that in the connection string.


>>Hi Fabio,
>>
>>I'm afraid that you've lost me here.
>>
>
>>Is it that SQLEXPRESS is a service running on the server SAMAAN5?
>
>Of course, the service name is SAMAAN5\SQLEXPRESS
>
>>
>>Are you saying that I can use ListAvailableSQLServices instead of ListAvailableSQLServers in my code to get the services? I tried that but there is no such property of the SQLDMO object that I can see.
>>
>>Thanks for your help.
>>
>
>I said that SQLDMO.ListAvailableSQLServers mean ListAvailableSQLServices.
>
>NetServerEnum don't return services.
>
>>>
>>>NetServerEnum return Server list where a specified service run
>>>
>>>SAMAAN5\SQLEXPRESS is a MSSQL service running in SAMAAN5.
>>>
>>>With other words, the list contain unique names.
>>>
>>>the SQLDMO's property "ListAvailableSQLServers"
>>>is "ListAvailableSQLServices"
>>>