WEM Database Creation Error Message regarding "Path Specified" when creating WEM database

WEM Database Creation Error Message regarding "Path Specified" when creating WEM database

book

Article ID: CTX223883

calendar_today

Updated On:

Description

When attempting to create a WEM Database using the Database Management Utility Console, it fails with:  "Database Creation Error"

User-added image

The Citrix WEM Database Management Utility Debug Log shows the following exception: "Exception -> CreateVuemdb.Run() : SqlDatabaseHelper.() connection Error : 5133 | Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DBname_Data.mdf" failed with the operating system error 3(The system cannot find the path specified.).
CREATE DATABASE failed. Some file names listed could not be created. Check related errors."

Resolution

Change the default path for the "Data file" and the "Log file" in the Database Creation Wizard to a path that exists on the SQL Server specified in the "Server and instance name" field.

User-added image

 


Problem Cause

The default path used for "Data file" and "Log file"  in the Database Creation Wizard did not exist on the SQL server.