How can I verify that the SQL Server database is in the evaluation period instead of active state on eSight?
If the installed SQL Server database is not activated, the database is in a 180-day evaluation period. After the evaluation period expires, the database startup is affected. As a result, the use of eSight is also affected. How can I quickly check whether the SQL Server is in the evaluation period?
There are two methods:
1. Log in to the eSight server and run the osql -E command in the Run text box to access the SQL CLI.
2. Run the following query statements:
if charindex('Evaluation', @@version) > 0 select 'unregistered' else select 'registered'
If information "unregistered" is displayed, the SQL Server is in the evaluation period. You need to obtain an activation code and activate the database.
Method 2: (This method is applicable to the scenario where the database cannot be started and accessed.)
1. Log in to the eSight server and run the services.msc command in the Run text box to access the service manager.
2. Right-click the SQL Server (MSSQLSERVER) service and choose related menu to start the service. If error code 17051 is reported, the database is in the evaluation period. You need to obtain an activation code and activate the database.