check if there is a running mssql server on your computer

* can I get some code to check wheater there is a runnung mssql server on a machine

* can i check that for a remote PC  (based on IP adress)

* can I check wheater express or full edition

* can I evaluate the server name ?

---------------  need it as delphi code -------------------------
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

ThommyConnect With a Mentor Commented:
Enumerating available SQL Servers. Retrieving databases on a SQL Server
ThommyConnect With a Mentor Commented:
Furthermore, to explore the structure of a known MSSQL database you can use this...

Access / SQL Server Database Explorer with full Delphi source code
jimyXConnect With a Mentor Commented:
I can't test this but the solution for the first two points is in these links:

I did not get what you mean in point three. What do you mean by evaluate the server name?
BdLmAuthor Commented:
what product has to be installed on the client to use sql Server DMO?
could not find that type lib on my computer, using WIN7 prof. and MSSQL Server Express
Ephraim WangoyaConnect With a Mentor Commented:

FYI: DMO is to be discontinued (If not discontinued already) so be very careful if you use it

You will be better of finding a solution that uses ADO
All Courses

From novice to tech pro — start learning today.