Servicing Director Database Installation Error: "Unable to write the ...SysData to the specified directory..."
Error!
Unable to write the EventMgr_SysData (or Service_SysData) to the specified directory: <a directory path on your system defined as the destination for the SQL database file>
Root Cause:
This error is caused by your Windows environment preventing the database installation program for deploying a database.
The error message may appear for a wide range of underlying Windows issues.
Workaround:
To resolve this Windows issue, have your local IT or system administrator use their Microsoft Windows support resources to do the following:
- Restart the Windows server.
- Retry the database installation.
If the error continues to appear, do the following:
Gather information: - Locate the Servicing Director installation log files, and particularly the "DB Install.log". For more information about finding the log files, search Knowledge Center with the key words Servicing Director Finding Log
- Confirm the Windows permissions to the folder described in the error message. Windows may be denying access to the destination path you have selected or configured for the SQL databases.
- Confirm the Windows permissions to the folders your SQL server configuration is set to use for new database files. View in SQL Server Management Studio under the SQL Server top level properties, on the Database Settings page of properties. Confirm the folders both for Data and Log. These will be called the database file destination folders.
- Confirm the other folder properties of the database file destination folders. For example, are the destination folders set to Read-Only, or are they using the Windows advanced property to compress the contents of the folder.
Note: Folder compression is not allowed by Microsoft SQL server for active read/write database files.
Review the Windows Account permissions. There are two Windows accounts writing files for this database: - The Windows account is used to open and perform the database installation program will write a database .MDF file to the folder.
- The SQL Server Windows service logon Windows account is used to create a database .LDF file, possibly in the same folder as the .MDF file in #1 but your SQL server may be set to place the LDF file in another folder.
Note: The Servicing Director SQL Server Required Configuration Settings Knowledge Center article referenced by the Servicing Director Installation Guide recommends selecting a Windows service logon account with elevated privileges such as the local system account or a suitable domain account. If you change the SQL Server Windows service logon account, you have to restart the SQL Server service for the change to take effect.
If these Windows accounts do not have permission to write to the database destination folders, either change the Windows accounts used or the folder permissions. To change the Windows account used by the SQL Server Windows service logon account, you have to set the logon account property of the service and then restart the service.
As a troubleshooting step, consider trying another database location, such as the default Microsoft location, by making that change in your SQL server settings first, restarting SQL server, and trying the installation again.
ArticleNumber:
000044354