Is SQL installed on server?

[undrcovr]

How can I find out if SQL Server is installed on my sbs box? We have programs like ACT and Veritas that run an SQL service but I dont know if we have the full version installed.

When I look under %\ProgramFiles\Microsoft SQL Server I see the following folders:

80
MSSQL$ACT
MSSQL$BKUPEXEC
MSSQL$SBSMONITORING
MSSQL$SHAREPOINT

 

[SQLBill]

Go to Start>Programs and see if there is a Microsoft SQL Server entry. If so, find Query Analyzer. Then run this command:

SELECT ServerProperty('Edition'),
ServerProperty('ProductLevel'),
ServerProperty('ProductVersion')

That will tell you what you have installed.

-SQLBill

Posting advice: FAQ481-4875

 

[undrcovr]

That entry doesnt exist. However in the startup folder there is 'Service Manager' entry which start the SQL agent that runs with ACT and Veritas.

 

[paskuda]

Check whether the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion registry key exists - if it does, you have MSSQL set up on your machine, it contains the application version too.

 

[SQLBill]

You probably have MSDE installed. Several applications (such as Veritas Backup Exec) install MSDE if there isn't a 'full' version of SQL Server already installed.

MSDE is the 'desktop edition'.

-SQLBill

Posting advice: FAQ481-4875

 

[undrcovr]

+HKLM\Software\Microsoft\MSSQLSERVER
|
+----\Client
-----\ConnectTo
+----\SuperSocketNetLib
--------------\LastConnect
--------------\Tcp
--------------\VIA

This was faster than posting a screenshot

 

[undrcovr]

Im assuming the full version is not installed then?