Sunday 29 September 2013

Error -26204: Failed to execute SQL String during Sitecore Installation

Leave a Comment
I was trying to install Sitecore CMS on computer and I got following error while installation :
Error 26204. Error -2147217900: failed to execute SQL string, error detail: Could not open File Control Bank (FCB) for invalid file ID 2 in database 'sitecoreSitecore_Core'. Verify the file location. Execute DBCC CHECKDB., SQL key: AttachSitecore_CoreSqlAuth SQL string: CREATE DATABASE [sitecoreSitecore_Core] ON ( FILENAME = N'E:\Inetpub\wwwroot\sitecore\Database\MDF\sitecoreSitecore.Core.MDF' ), ( FILENAME = N'E:\Inetpub\wwwroot\sitecore\Database\LDF\sitecoreSitecore.Core.ldf' ) FOR ATTACH
The Sitecore installation wizard kept failing at the Executing SQL Install Script step. Following steps resolved the issue:
  1. If you are using SQL Server, the user account configured to run the SQL server application requires Full access to the /Databases folder containing MDF and LDF database files. Typically, the SQL server application runs within the context of the NETWORK SERVICE account.
    In my case, database folder path was 'E:\Inetpub\wwwroot\sitecore\Database'. I've given EVERYONE and NETWORK SERVICE account full access on above path.
  2. Also, I've found that database folder path 'E:\Inetpub\wwwroot\sitecore\Database' was set as compressed to save disk space. I'd uncompressed 'E:\Inetpub\' folder. Below are the steps to set as uncompressed:
    • Right Click on Inetpub folder.
    • Click on Properties.
    • Click on Advanced.
    • Unchecked checkbox in front of Compress content to save disk space. See below screenshot for your reference:


Post a Comment