Question & Answer
Question
CREATE FILE encountered operating system error 5." unable to create the Tealeaf databases.
Answer
Contents
Problem
The following error is raised when initializing the databases through the Tealeaf Database Manager:? "2012-02-14T13:26:49 TL_SYSTEM ERROR There was an error executing the command list: CREATE FILE encountered operating system error 5 (Access is denied.) while attempting to open or create the physical file 'D:\tealeaf\sqldata\TL_SYSTEM_PRIMARY.mdf'. CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
At statement: CREATE DATABASE [TL_SYSTEM]".
Solution
This error means that SQL server cannot write at the destination specified because of a permission problem for example D:\tealeaf\sqldata.
Open the Windows services snap-in and check the Log On As column for the SQL Server services.? For example if it is running under the Network Service account be sure that this user account has full permissions on the sqldata folder.
Article Reference
00001319
"
[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSERNK","label":"Tealeaf Customer Experience"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
08 December 2018
UID
ibm10778171