Aurora Keyscan will not Launch - SQL 2017

Question

What do you do if launching the Aurora client on the server is not successful?

Answer

The SQL data files may be corrupted. Here are a few items to check first:

1. Is the service SQL Server (AURORA) running?
2. Is the service SQL Server (AURORA) installed?
3. Is the Database Location set to LOCALHOST?

If the answer is yes to all, it is likely that the SQL is corrupted, and this document will attempt to repair the SQL.

The first step is to stop the following services. To do this, press the Windows key and the R key at the same time to open the Run command. Type in Service.msc and then press Enter.

• Keyscan Aurora Agent
• Keyscan Aurora Communications
• SQL Server (AURORA)
• SQL Server Browser
• dormakaba HMS (if installed)
• EPLEX Server (if installed)
• Keyscan Aurora Intrusion Communications (if installed)
• Keyscan Aurora Reverse Communications (if installed)
• Keyscan Aurora Virtual Elevator Communications (if installed)

Once the services are stopped, back up the raw data files located in the following location. Move them into a backup folder in the same folder, desktop, etc.

C:\Program Files\Microsoft SQL Server\MSSQL14.AURORA\MSSQL\DATA\

Copy the blank data files from this link back into the DATA folder.

Blank Aurora Data Folder Zip File

Start the SQL Server (AURORA) service only and see if the client launches.

• If the client launches successfully to a log-in screen, then close the client and restore a backup.
• If there is no backup to restore, log into the client and attempt a disaster recovery.
• If the client does not launch successfully, then complete SQL removal will be required.

Instructions to Uninstall SQL 2017