Type:
Information
Summary:
Even though “??” was specified as the key when building the security profile, SQL hangs at startup and user is not presented with a key entry dialog. NOTE: This is an option when securing SQL and most do not use this method.
Additional Information:
If you have specified ?? (two question marks) as a key when creating the security profile, the user is prompted with a dialog at SQL Startup to enter the key value. In Windows 2008 R2 and later you need to have Windows’ “Interactive Services Detection” Service running in order to interact with a Service from the Desktop:
To start this Service:
- Start Administrative Tools->Services (run Run “services.msc”).
- Locate the Interactive Services Detection Service.
- Start the Service.
- Change the Start type from Manual to Automatic so it will be started automatically next time you reboot.
If functioning properly, when starting SQL next time you will see an icon flashing on the Task Bar prompting you to interact with a Service.