← Back to Knowledge Base

KB #240095: User not being prompted to enter key when SQL starts

⏱️ 1 min read

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.

Was this article helpful?

Related Articles

KB #240020: APIs returning empty or invalid values when encrypting or decrypting (SQL Server)

Type: Information Summary: This article discusses why you may see the APIs returning empty or…

KB #240091: NLCBTASK Service fails to start with error “The system cannot find the file specified”

Type: Fix Summary: The installer added the ImagePath for the NLCBTASK Service without surrounding quotes. This…

KB #240133: sp_n_codelvl shows Encrypted when database Offline and Plain when Online

Type: Known Issue. Minor. Summary: sp_n_codelvl is an optional Encryptionizer SQL Stored Procedure which can…

Still need help?

Our support team is here to assist you.

NetLib Security
AI Assistant · Online
Hi! I'm the NetLib Security assistant. I can answer questions about our encryption solutions, HIPAA compliance, Encryptionizer, and more. How can I help you today?