Error when creating new database using SQL Express 2014 (4368907)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error when creating new database using SQL Express 2014
Description

When running the configuration wizard if you select to create a new database on SQL Express 2014 you will get an error
Cause

SQL Express does not use the "CREATE OR ALTER" command and will return an error once the configuration wizard runs CreateDatabase.sql.
Resolution

1. Find the script CreateDatabase.sql that will be in the server installation folder. "C:\Program Files\Quest\Active Administrator\Server" by default.

2. Search for the line "CREATE OR ALTER PROCEDURE [dbo].[GetCertificateExtensionsForComputer]"

3. Remove "OR ALTER" so it reads "CREATE PROCEDURE [dbo].[GetCertificateExtensionsForComputer]"

4. Save the script and run the configuration wizard again.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title