You can use the Microsoft SQL Server Management Studio program to find the version and edition of Microsoft SQL Server on your Servicing Director server.

The Microsoft SQL Server product offers the optional SQL Server Management Studio application for a SQL Server.  For the Microsoft SQL Server Express product, the optional application is called SQL Server Management Studio Express, which works in the same way as SQL Server Management Studio, and you can apply the procedure below to the Express product.  

IMPORTANT! The procedure below is for your local IT or system administrator familiar with Windows and Microsoft SQL Server.

For more information about obtaining, installing, or using SQL Server Management Studio, please see your Microsoft SQL support information.

If you are not sure of your Servicing Director Server name, then please search the Knowledge Center for the related article using the key words Servicing Director SQL Name.

1. Log into Windows as an administrator user on the Servicing Director SQL Server.

2. Open the SQL Server Management Studio  application. Microsoft will have created a Windows Start menu shortcut for this application under All Programs > Microsoft SQL Server when SQL Server was first installed. You may have more than one version of Microsoft SQL Server listed in the Start menu, and if so, then select the highest numbered version to open SQL Server Management studio. When you open SQL Server Management Studio, the Connect to Server popup window will be displayed.

3. Skip the Server type on the Connect to Server login screen. The correct default of Database Engine should already be selected.

4. Select the SQL Server name which hosts your Servicing Director databases. The SQL Server name is the computer name of your SQL Server, and it may end with the optional backslash character and the add-on SQL Server instance name. When your SQL Server has more than one SQL Server installed, you would commonly have one SQL server without any instance name added onto the computer name, and then all other SQL Server installed will have the instance name added on. If your Servicing Director SQL Server name does have the optional SQL Server instance name, than always select the full name including the instance name.

5. Select SQL Server Authentication for the Authentication. 
6. Enter 'sa' for the Login name. 
7. Enter your 'sa' login password for the Password.

The 'sa' login password would have been created by your system administrator when SQL Server was first installed.  Your system administrator may have chosen to change the password since it was first created.  If you don't know what the 'sa' login password is, check with your system administrator. 

8. Click Connect.
9. Click New Query on the SQL Server Management Studio toolbar.
10. In the New Query screen on the right-hand window, enter this two line SQL Server command:

Select @@version
Select cast(serverproperty('edition') as varchar)

11. Click Execute on the SQL Server Management Studio toolbar.
12. Your Microsoft SQL Server version and edition will be displayed in the lower part of the New Query screen.
13. Close the SQL Server Management Studio. 
14. Click No when prompted with "Save changes to the following items?".

ArticleNumber:

000046494