An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 5123 RSS

• • Reply
  

  MKozlowski

  Member

  500 Points

  573 Posts

  An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number ...

  May 09, 2012 01:00 PM|LINK

  Hi,

  I am tring to get my website going and I am getting the following error?:

  An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 5123 and the SqlException message is: CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:\INETPUB\WWWROOT\TIMETRACKER\APP_DATA\TIMETRACKER_TMP.MDF'.
  CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
  Creating the TIMETRACKER_fea1a4f7e6164f3c8b5186887f485b61 database...

  <?xml version="1.0"?>
  <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
    <connectionStrings>
      <add name="aspnet_staterKits_TimeTracker" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=true"/>
      <remove name="LocalSqlServer"/>
      <add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=true"/>
  
      <add name="TimeTrackerConnectionString" connectionString="Data Source=WEBSERVER\SQLEXPRESS;Initial Catalog=TimeTracker;Integrated Security=True" providerName="System.Data.SqlClient"/>
    </connectionStrings>
    <system.web>
      <siteMap defaultProvider="AspNetXmlSiteMapProvider" enabled="true">
        <providers>
          <clear/>
          <add name="AspNetXmlSiteMapProvider" type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" siteMapFile="web.sitemap" securityTrimmingEnabled="true"/>
        </providers>
      </siteMap>
      <authentication mode="Windows"/>
      <identity impersonate="true"/>
      <compilation debug="true" targetFramework="4.0">
        <assemblies>
          <add assembly="System.DirectoryServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
          <add assembly="System.DirectoryServices.AccountManagement, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
        </assemblies>
      </compilation>
      <customErrors mode="RemoteOnly"/>
      <machineKey decryptionKey="AutoGenerate,IsolateApps"/>
      <roleManager enabled="true"/>
      <pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID"/>
    </system.web>
  
  </configuration>

  
  

• • Reply
  

  MKozlowski

  Member

  500 Points

  573 Posts

  Re: An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error num...

  May 09, 2012 01:14 PM|LINK

  I am not sure why it is trying to create an aspnetdb file? I dont need one.

  • Edited by MKozlowski on May 09, 2012 01:51 PM
  • Edited by MKozlowski on May 09, 2012 01:53 PM
• • Reply
  

  christiandev

  Star

  8597 Points

  1841 Posts

  Re: An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error num...

  May 09, 2012 01:52 PM|LINK

  Do you have any code in your global.asax that creates a DB? have you searched the solution for CREATE? where is that script being called from? Does the script create a DB? if so, the script might need some code to check if the DB exists first?

  Please remember to Mark As Answer if helpful
  
  Regards, Christiandev (@chrisdev80), MCPD Web (2 & 4) & MCTS Windows (www.ScoreDonkey.com)
  
  • Marked as answer by MKozlowski on May 09, 2012 04:14 PM
• • Reply
  

  MKozlowski

  Member

  500 Points

  573 Posts

  Re: An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error num...

  May 09, 2012 01:54 PM|LINK

  I deleted the global asax file and searched for create and didnt find anything related

• • Reply
  

  christiandev

  Star

  8597 Points

  1841 Posts

  Re: An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error num...

  May 09, 2012 01:58 PM|LINK

  where is the InstallCommon.sql being called from?

  Please remember to Mark As Answer if helpful
  
  Regards, Christiandev (@chrisdev80), MCPD Web (2 & 4) & MCTS Windows (www.ScoreDonkey.com)
  
• • Reply
  

  MKozlowski

  Member

  500 Points

  573 Posts

  Re: An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error num...

  May 09, 2012 02:51 PM|LINK

  Thats what I am confused on, I search the whole project for InstallCommon.sql and it does not exist?

  I recycled IIS and now i get this error:

  Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.

  • Edited by MKozlowski on May 09, 2012 03:07 PM
• • Reply
  

  MKozlowski

  Member

  500 Points

  573 Posts

  Re: An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error num...

  May 09, 2012 04:14 PM|LINK

  Thanks for the suggestions I got it working. It was accessing roles in the websitemap.