Receiving Access is Denied Error at the File System Level when Executing Create Task of MSBuild.ExtensionPack.Sql2008.Database

Aug 2, 2012 at 3:42 PM

I have tried everything I can think of to make this work.  Using a username and password of an SA account with no luck.  I'm able to connect to the server, even execute a delete, but for some reason I do not have the ability to create a file.  I've even gone as far as opening up that folder to the EVERYONE account, still no luck.  Any help will be greatly appreciated.  

Coordinator
Aug 2, 2012 at 3:54 PM

can you run with /v:diag and post the full log.

Aug 2, 2012 at 4:27 PM
Edited Aug 2, 2012 at 4:29 PM

 

Build started 8/2/2012 12:24:44 PM.Overriding target "ErrorTarget" in project "F:\CFF\Conversion\CV\CV 2.93.4.388640.install\Base\Blackbaud.ToolsFx.Build.DeployOperations.xml" with target "ErrorTarget" from project "F:\CFF\Conversion\CV\CV 2.93.4.388640.install\Base\Blackbaud.ToolsFx.Build.targets".__________________________________________________Project "F:\CFF\Conversion\CV\CV 2.93.4.388640.install\install.xml" (Conversion_GenerateStagingDB target(s)):
Initial Properties:ALLUSERSPROFILE                = C:\ProgramDataAPPDATA                        = C:\Users\JasonCu\AppData\RoamingBBDWETLUserPassword            = P@ssword1BBDWKickOffETL                 = FalseBBDWRunDeploy                  = FalseBBDWRunFullRedeploy            = FalseBBDWSettingsFile               = F:\CFF\Conversion\CV\CV 2.93.4.388640.install\Options\BBDW\[32568_CFF_EFA].[32568_CFF_EFA].BBDW.settings.xmlBBDWSettingsTemplate           = F:\CFF\Conversion\CV\CV 2.93.4.388640.install\Options\BBDW\sample.(2.9).BBDW.settings.xmlBBDWSQLAgentJobName            = BBETL_SSIS_[32568_CFF_EFA]_RPT_BBDWBBDWSQLDBConnectionString      = integrated security=sspi;Server=d2pbbdbcon003a\a;database=[32568_CFF_EFA]_RPT_BBDWBBDWSQLDBDataPath              = F:\CFF\SQL\32568_CFF_EFABBDWSQLDBLogPath               = E:\CFF\SQL\32568_CFF_EFABBDWSQLDBName                  = [32568_CFF_EFA]_RPT_BBDWBBDWSQLDBServerName            = d2pbbdbcon003a\aBBDWSSASDBName                 = [32568_CFF_EFA]_RPT_BBDW_UDMBBDWSSASServerName             = d2pbbdbcon003a\aBBDWSSISServerName             = d2pbbdbcon003a\aBBDWTrustedAccountUserName     = BBETL_BBDWBBISBinFolder                  = /binBBISConfigSourceConnectionString_NoDB = Server=d2pbbdbcon003a\a;User ID=jasoncu;Password=***BBISConfigSourceDataPath       = c:\bbisconfigsourcedataBBISConfigSourceDBBackupFile   = path.to.bakup.bakBBISConfigSourceDBConnectionString = Server=d2pbbdbcon003a\a;User ID=jasoncu;Password=***;Initial Catalog=BBISConfigSourceDBBBISConfigSourceDBLogPath      = c:\bbisconfigsourcedataBBISConfigSourceDBName         = BBISConfigSourceDBBBISConfigTargetConnectionString_NoDB = Server=d2pbbdbcon003a\a;User ID=jasoncu;Password=***BBISConfigTargetDataPath       = c:\bbisconfigtargetdataBBISConfigTargetDBBackupFile   = path.to.bakup.bakBBISConfigTargetDBConnectionString = Server=d2pbbdbcon003a\a;User ID=jasoncu;Password=***Initial Catalog=BBISConfigTargetDBBBISConfigTargetDBLogPath      = c:\bbisconfigtargetdataBBISConfigTargetDBName         = BBISConfigTargetDBBBISInstallPath                = BBISIsInstalled                = FalseBBISVirtualDirectory           = netcommunityBBISWebBuildType               = PipelinePreDeployCopyAllFilesToOneFolderBBISWebServerName              = D2PBBDBCON003ABuildArchitecture              = x86BuildConfiguration             = DebugBuildDatabaseFile              = c:\tmp\BBInfinity.bakBuildDeployClientPath          = C:\ClientInstalls\CFF_32568\EFA\bbappfx\vroot\browser\clientbin\customBuildDeployCustomCatalogPath   = C:\ClientInstalls\CFF_32568\EFA\bbappfx\vroot\bin\customBuildDeployHelpFilesPath       = C:\ClientInstalls\CFF_32568\EFA\bbappfx\vroot\helpBuildDeployHTMLFormsPath       = C:\ClientInstalls\CFF_32568\EFA\bbappfx\vroot\browser\htmlformsBuildDeployPath                = C:\ClientInstalls\CFF_32568\EFA\bbappfxBuildDeployRootSubpath         = \W3SVC\1\RootBuildID                        = ts.localbuildBuildInfinityPassword          = BuildInfinityUserName          = blackbaudhost\BuildPath                      = F:\CFF\Conversion\CV\CV 2.93.4.388640.installBuildReportServiceBaseURL      = http://localhost/ReportServer/ReportService2005.asmx?wsdlBuildReportServiceDatabaseName = [32568_CFF_EFA]BuildReportServiceHost         = localhostBuildReportServiceReportInstance = ReportServerBuildReportServiceRootFolder   = [32568_CFF_EFA]BuildReportServiceSQLServer    = d2pbbdbcon003a\aBuildReportServiceUser         = BBReportUserBuildReportServiceUserName     = D2PBBDBCON003A\BBReportUserBuildReportUserPassword        = ***BuildSaveFolder                = F:\CFF\Conversion\MSBuild\buildoutput\BuildSelectedDB                = [32568_CFF_EFA]BuildType                      = BuildBuildUseBasicAuthentication    = FalseBuildVirtualDir                = 32568_EFABuildWebServer                 = D2PBBDBCON003ABuildWebServerMachineName      = D2PBBDBCON003ABuildWebServerURL              = http://D2PBBDBCON003A/32568_EFABuildWebServiceDomain          = BuildWebServicePassword        = BuildWebServiceUser            = BuildWorkingFolder             = F:\CFF\Conversion\MSBuild\buildworking\CacheAlterPagesData            = FalseCLIENTNAME                     = CHS6JASONCUSA01CodeAnalysisTreatWarningsAsErrors = FalseCommonProgramFiles             = C:\Program Files (x86)\Common FilesCommonProgramW6432             = C:\Program Files\Common FilesCOMPUTERNAME                   = D2PBBDBCON003AComSpec                        = C:\Windows\system32\cmd.exeConversionBaseMapFolder        = ConversionScriptDBConnectionString = Server=d2pbbdbcon003a\a;User ID=jasoncu;Password=***ConversionStagingDatabase      = 32568_CFF_Staging_PM_001ConversionStagingDataFilePath  = F:\CFF\SQL\32568_CFF_Staging_PM_001ConversionStagingDBConnectionString = Server=d2pbbdbcon003a\a;User ID=jasoncu;Password=***;Initial Catalog=32568_CFF_Staging_PM_001ConversionStagingLogFilePath   = F:\CFF\SQL\32568_CFF_Staging_PM_001ConversionStagingServerName    = d2pbbdbcon003a\AConversionStagingServerPassword = ***ConversionStagingServerUserName = jasoncuDEFLOGDIR                      = C:\ProgramData\McAfee\DesktopProtectionDeployBizOps                   = FalseDLLReferencePath               = F:\CFF\Conversion\CV\CV 2.93.4.388640.install\..\DLLReferencesExtensionTasksPath             = F:\CFF\Conversion\CV\CV 2.93.4.388640.install\Tasks\v4.0\FP_NO_HOST_CHECK               = NOHOMEDRIVE                      = C:HOMEPATH                       = \Users\JasonCuInstallRootPath                = C:\ClientInstalls\CFF_32568\EFA\bbappfxLOCALAPPDATA                   = C:\Users\JasonCu\AppData\LocalLOGONSERVER                    = \\D2PBBDCBBH001MaxProcessThreads              = 40MSBuildBinPath                 = C:\Windows\Microsoft.NET\Framework\v2.0.50727MSBuildExtensionsPath          = C:\Program Files (x86)\MSBuildMSBuildExtensionsPath32        = C:\Program Files (x86)\MSBuildMSBuildExtensionsPath64        = C:\Program Files\MSBuildMSBuildNodeCount               = 1MSBuildProgramFiles32          = C:\Program Files (x86)MSBuildProjectDefaultTargets   = NoneMSBuildProjectDirectory        = F:\CFF\Conversion\CV\CV 2.93.4.388640.installMSBuildProjectDirectoryNoRoot  = CFF\Conversion\CV\CV 2.93.4.388640.installMSBuildProjectExtension        = .xmlMSBuildProjectFile             = install.xmlMSBuildProjectFullPath         = F:\CFF\Conversion\CV\CV 2.93.4.388640.install\install.xmlMSBuildProjectName             = installMSBuildStartupDirectory        = F:\CFF\Conversion\CV\CV 2.93.4.388640.installMSBuildToolsPath               = C:\Windows\Microsoft.NET\Framework\v2.0.50727MSBuildToolsVersion            = 2.0NUMBER_OF_PROCESSORS           = 12OptionsFile                    = Options/PM_D2PBBDBCON003A_dev.xmlOS                             = Windows_NTOverrideMapFolder              = Path                           = C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft Network Monitor 3\;C:\Program Files (x86)\Dell\SysMgt\oma\bin;C:\Program Files (x86)\Dell\SysMgt\idrac;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Blackbaud\Management Console\bin\;C:\Program Files (x86)\Blackbaud\The Raisers Edge 7\;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft Windows Performance Toolkit\;C:\Program Files (x86)\WinSCP\PATHEXT                        = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSCPROCESSOR_ARCHITECTURE         = x86PROCESSOR_ARCHITEW6432         = AMD64PROCESSOR_IDENTIFIER           = Intel64 Family 6 Model 44 Stepping 2, GenuineIntelPROCESSOR_LEVEL                = 6PROCESSOR_REVISION             = 2c02ProductFlagEmailAddress        = patrick.mcclory@blackbaud.comProgramData                    = C:\ProgramDataProgramFiles                   = C:\Program Files (x86)ProgramW6432                   = C:\Program FilesPROMPT                         = $P$GPSModulePath                   = C:\Windows\system32\WindowsPowerShell\v1.0\Modules\PUBLIC                         = C:\Users\PublicRedeployReportServer           = FalseRunCodeAnalysis                = FalseRunTests                       = FalseSESSIONNAME                    = RDP-Tcp#2SiteId                         = 5470SolutionRoot                   = F:\CFF\Conversion\CV\CV 2.93.4.388640.install\..\SQLConnectionString            = Server=d2pbbdbcon003a\a;User ID=jasoncu;Password=***;Initial Catalog=[32568_CFF_EFA]SQLConnectionString_NoDB       = Server=d2pbbdbcon003a\a;User ID=jasoncu;Password=***SQLExecuteTimeout              = 300SQLServer                      = d2pbbdbcon003a\aSQLServerAgent                 = SQLSERVERAGENTSQLServerDataPath              = F:\CFF\SQL\32568_CFF_EFASQLServerDB                    = [32568_CFF_EFA]SQLServerDBOwner               = saSQLServerLogPath               = E:\CFF\SQL\32568_CFF_EFASQLServerService               = MSSQLSERVERSystemDrive                    = C:SystemRoot                     = C:\WindowsTasksFolder                    = \MSBuild\Tasks\TaskToolsVersion               = v4.0TEAMCITY_DATA_PATH             = F:\TeamCity\.BuildServerTEMP                           = C:\Users\JasonCu\AppData\Local\Temp\3TMP                            = C:\Users\JasonCu\AppData\Local\Temp\3ToolsVersion                   = v4.0TreatWarningsAsErrors          = FalseUSERDNSDOMAIN                  = BLACKBAUDHOST.COMUSERDOMAIN                     = BLACKBAUDHOSTUSERNAME                       = jasoncuUSERPROFILE                    = C:\Users\JasonCuVS100COMNTOOLS                 = C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\Tools\VSEDEFLOGDIR                   = C:\ProgramData\McAfee\DesktopProtectionwindir                         = C:\WindowsYieldDuringToolExecution       = true
Initial Items:BuildDBUser    yesCatalogProject    F:\CFF\Conversion\CV\CV 2.93.4.388640.install\..\\Customizations\Blackbaud.CustomFx.FoodBank.Catalog\Blackbaud.CustomFx.FoodBank.Catalog.vbprojClientProject    F:\CFF\Conversion\CV\CV 2.93.4.388640.install\..\\Customizations\Blackbaud.CustomFx.FoodBank.Client\Blackbaud.CustomFx.FoodBank.Client.vbprojLoadCatalogProjectName    Food Bank Package (SDK Training)PostDBRestoreSQL    F:\CFF\Conversion\CV\CV 2.93.4.388640.install\..\\SQLScripts\ReencryptMasterKey.sqlSQLTokenValues    BuildIDTransferTable    ACTIONITEMPART    AnonymousNewsletterPart    AUDITS    ClientContentTypes    CLIENTDONATIONS    CLIENTS    CLIENTSITES    ClientUserMRU    CLIENTUSERS    CMSSITESETTING    ContentComparisonPart    contenttypes    DATASOURCES    DocUploadPart    ECardPart    EMAILLIST    EMAILTEMPLATE    MenuItems    MICROSITECONTENT    MICROSITEPAGE    MICROSITESETTING    PAGECONTENT    PAGEMODEL    PAGEMODELDESIGN    PAGEMODELITEM    PAGEVIEWDATA    QuickSearchPart    SearchPart    SharingPart    ShoppingCartPart    ShoppingCartSummaryPart    SITECONTENT    SITECONTENTVERSION    SITECOPY    SITECULTURES    SITEFOLDERS    SITEIMAGEFOLDERS    SITEIMAGES    SITEIMAGESEXTENSION    SITELAYOUTS    SITEMENU    SITEPAGES    SITESTYLESHEETS    TargetedContentPart    VANITYURLUIModelProject    F:\CFF\Conversion\CV\CV 2.93.4.388640.install\..\\Customizations\Blackbaud.CustomFx.FoodBank.UIModel\Blackbaud.CustomFx.FoodBank.UIModel.vbproj
Building with tools version "2.0".Target "Conversion_GenerateStagingDB" in file "F:\CFF\Conversion\CV\CV 2.93.4.388640.install\CustomTargets\Conversion_GenerateStagingDB.xml":  Using "Message" task from assembly "Microsoft.Build.Tasks, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a".  Task "Message"    Check to see if 32568_CFF_Staging_PM_001 Exists  Done executing task "Message".  Using "MSBuild.ExtensionPack.Sql2008.Database" task from assembly "F:\CFF\Conversion\CV\CV 2.93.4.388640.install\Tasks\v4.0\\MSBuild.ExtensionPack.Sql2008.dll".  Task "MSBuild.ExtensionPack.Sql2008.Database"    Using a Trusted Connection    Checking whether Database exists: 32568_CFF_Staging_PM_001  Done executing task "MSBuild.ExtensionPack.Sql2008.Database".  Task "Message"    Database Exists: False  Done executing task "Message".  Task "Message"    Set staging database offline...  Done executing task "Message".  Task "MSBuild.ExtensionPack.Sql2008.Database" skipped, due to false condition; ('$(DoesExist)'=='True') was evaluated as ('False'=='True').  Task "Message"    Set staging database online...  Done executing task "Message".  Task "MSBuild.ExtensionPack.Sql2008.Database" skipped, due to false condition; ('$(DoesExist)'=='True') was evaluated as ('False'=='True').  Task "Message"    Deleting staging database...  Done executing task "Message".  Task "MSBuild.ExtensionPack.Sql2008.Database" skipped, due to false condition; ('$(DoesExist)'=='True') was evaluated as ('False'=='True').  Task "Message"    Staging Database delete...  Done executing task "Message".  Task "Message"    Start create database...  Done executing task "Message".  Task "MSBuild.ExtensionPack.Sql2008.Database"    Creating Database: 32568_CFF_Staging_PM_001    F:\CFF\Conversion\CV\CV 2.93.4.388640.install\CustomTargets\Conversion_GenerateStagingDB.xml(45,5): error : FailedOperationException: Create failed for Database '32568_CFF_Staging_PM_001'. \r    F:\CFF\Conversion\CV\CV 2.93.4.388640.install\CustomTargets\Conversion_GenerateStagingDB.xml(45,5): error : ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch.\r    F:\CFF\Conversion\CV\CV 2.93.4.388640.install\CustomTargets\Conversion_GenerateStagingDB.xml(45,5): error : SqlException: CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'F:\CFF\SQL\32568_CFF_Staging_PM_001'.\r    F:\CFF\Conversion\CV\CV 2.93.4.388640.install\CustomTargets\Conversion_GenerateStagingDB.xml(45,5): error : CREATE DATABASE failed. Some file names listed could not be created. Check related errors.\r    F:\CFF\Conversion\CV\CV 2.93.4.388640.install\CustomTargets\Conversion_GenerateStagingDB.xml(45,5): error :   Done executing task "MSBuild.ExtensionPack.Sql2008.Database" -- FAILED.Done building target "Conversion_GenerateStagingDB" in project "install.xml" -- FAILED.
Done building project "install.xml" -- FAILED.
Detailed Build Summary======================    
============================== Build Hierarchy (IDs represent configurations) =====================================================Id                  : Exclusive Time   Total Time   Path (Targets)-----------------------------------------------------------------------------------------------------------------------------------0                   : 0.452s           0.452s       F:\CFF\Conversion\CV\CV 2.93.4.388640.install\install.xml (Conversion_GenerateStagingDB) 
============================== Node Utilization (IDs represent configurations) ====================================================Timestamp:            1        Duration   Cumulative-----------------------------------------------------------------------------------------------------------------------------------634795214844835396:   0        0.452s     0.452s #########-----------------------------------------------------------------------------------------------------------------------------------Utilization:          100.0    Average Utilization: 100.0
Project Performance Summary:      437 ms  F:\CFF\Conversion\CV\CV 2.93.4.388640.install\install.xml   1 calls
Target Performance Summary:      374 ms  Conversion_GenerateStagingDB               1 calls
Task Performance Summary:       16 ms  Message                                    7 calls      343 ms  MSBuild.ExtensionPack.Sql2008.Database     2 calls
Build FAILED.
F:\CFF\Conversion\CV\CV 2.93.4.388640.install\CustomTargets\Conversion_GenerateStagingDB.xml(45,5): error : FailedOperationException: Create failed for Database '32568_CFF_Staging_PM_001'. \rF:\CFF\Conversion\CV\CV 2.93.4.388640.install\CustomTargets\Conversion_GenerateStagingDB.xml(45,5): error : ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch.\rF:\CFF\Conversion\CV\CV 2.93.4.388640.install\CustomTargets\Conversion_GenerateStagingDB.xml(45,5): error : SqlException: CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'F:\CFF\SQL\32568_CFF_Staging_PM_001'.\rF:\CFF\Conversion\CV\CV 2.93.4.388640.install\CustomTargets\Conversion_GenerateStagingDB.xml(45,5): error : CREATE DATABASE failed. Some file names listed could not be created. Check related errors.\rF:\CFF\Conversion\CV\CV 2.93.4.388640.install\CustomTargets\Conversion_GenerateStagingDB.xml(45,5): error :     0 Warning(s)    1 Error(s)
Time Elapsed 00:00:00.46

Coordinator
Aug 2, 2012 at 5:17 PM

Does the account that sql runs as have the security privilege to access the directory?

Aug 2, 2012 at 5:26 PM
The SQL service account is an administrator on that box, and that folder has full acces to the administrators group. So at least from a configuration standpoint it appears to have access.

I've tried running the script using both a SQL login and integrated security and both time the same error. I've also logged in to SSMS using that user and created a db w no problem.

Thanks!
Jason

---------------
Jason Cusati

On Aug 2, 2012, at 13:17, mikefourie <notifications@codeplex.com> wrote:

From: mikefourie

Does the account that sql runs as have the security privilege to access the directory?

Coordinator
Aug 2, 2012 at 5:27 PM

Ok, can you post the Xml you are using.

Aug 2, 2012 at 5:55 PM
<?xml version="1.0" encoding="utf-8" ?>
<Project
xsi:schemaLocation="http://schemas.microsoft.com/developer/msbuild/2003 ..\Schemas\Microsoft.Build.xsd">

<Target Name="Conversion_GenerateStagingDB">

<Message Text="Check to see if $(ConversionStagingDatabase) Exists"/>
<MSBuild.ExtensionPack.Sql2008.Database
TaskAction="CheckExists"
MachineName="$(ConversionStagingServerName)"
DatabaseItem="$(ConversionStagingDatabase)">
<Output
TaskParameter="Exists"
PropertyName="DoesExist"/>
</MSBuild.ExtensionPack.Sql2008.Database>
<Message Text="Database Exists: $(DoesExist)"/>
<Message Text="Set staging database offline..."/>
<MSBuild.ExtensionPack.Sql2008.Database
Condition="'$(DoesExist)'=='True'"
TaskAction="SetOffline"
MachineName="$(ConversionStagingServerName)"
DatabaseItem="$(ConversionStagingDatabase)"
/>
<Message Text="Set staging database online..."/>
<MSBuild.ExtensionPack.Sql2008.Database
Condition="'$(DoesExist)'=='True'"
TaskAction="SetOnline"
MachineName="$(ConversionStagingServerName)"
DatabaseItem="$(ConversionStagingDatabase)"
/>

<Message Text="Deleting staging database..."/>
<MSBuild.ExtensionPack.Sql2008.Database
Condition="'$(DoesExist)'=='True'"
TaskAction="Delete"
MachineName="$(ConversionStagingServerName)"
DatabaseItem="$(ConversionStagingDatabase)"
/>
<Message Text="Staging Database delete..."/>

<Message Text="Start create database..."/>
<MSBuild.ExtensionPack.Sql2008.Database
TaskAction="Create"
MachineName="$(ConversionStagingServerName)"
DatabaseItem="$(ConversionStagingDatabase)"
DataFilePath="$(ConversionStagingDataFilePath)"
LogFilePath="$(ConversionStagingLogFilePath)"
UserName="$(ConversionStagingServerUserName)"
UserPassword="$(ConversionStagingServerPassword)"
/>
<Message Text="Database created..."/>

<Message Text="Execute table scripts..."/>
<ItemGroup>
<CreateTableScriptsToRun Include="$(MSBuildProjectDirectory)/Project Outputs/CV GUI/Staging Database/Creation Scripts/*.sql"/>
</ItemGroup>

<Message Text="Get item count"/>
<MSBuild.ExtensionPack.Framework.MSBuildHelper TaskAction="GetItemCount" InputItems1="@(CreateTableScriptsToRun)">
<Output TaskParameter="ItemCount" PropertyName="CreateTableScriptsCount"/>
</MSBuild.ExtensionPack.Framework.MSBuildHelper>
<Message Text="CreateTableScriptsCount = $(CreateTableScriptsCount)"/>
<Message Text="Starting Threaded SQL Runner..."/>
<ThreadedSQLRunner SQLFilesToRun="@(CreateTableScriptsToRun)" TargetConnectionString="$(ConversionStagingDBConnectionString)" MaxThreadPoolSize="$(MaxProcessThreads)" Condition="'$(CreateTableScriptsCount)'>'0'"/>
<Message Text="Completed Threaded SQL Runner"/>
<Message Text="Table scripts created..."/>

</Target>
</Project>
-------------------
Jason Cusati



On Thu, Aug 2, 2012 at 1:28 PM, mikefourie <notifications@codeplex.com> wrote:

From: mikefourie

Ok, can you post the Xml you are using.

Read the full discussion online.

To add a post to this discussion, reply to this email (MSBuildExtensionPack@discussions.codeplex.com)

To start a new discussion for this project, email MSBuildExtensionPack@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com


Aug 7, 2012 at 4:04 PM

I'm still getting an access denied error, do you have any suggestions?

Coordinator
Aug 8, 2012 at 11:00 PM

do your paths represent folders or files? I can repro this if for eg. ConversionStagingDataFilePath is C:\a, but if it's c:\a\mydatafile.mdf then it works


Aug 8, 2012 at 11:10 PM
They represent folders. Shall I change that to files?
-------------------
Jason Cusati



On Wed, Aug 8, 2012 at 7:00 PM, mikefourie <notifications@codeplex.com> wrote:

From: mikefourie

do your paths represent folders or files? I can repro this if for eg. ConversionStagingDataFilePath is C:\a, but if it's c:\a\mydatafile.mdf then it works


Read the full discussion online.

To add a post to this discussion, reply to this email (MSBuildExtensionPack@discussions.codeplex.com)

To start a new discussion for this project, email MSBuildExtensionPack@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com


Coordinator
Aug 8, 2012 at 11:12 PM

yes, please try the full file path. that should fix it.

 

Mike

Aug 9, 2012 at 2:30 PM

OK, so that solved my problem with the permissions error, however now when I try to run my batch of Create Table scripts, I am getting an out of space in the transaction logs error.  When I manually create the DB through SSMS or another script, and then execute my Create Table Scripts target this problem does not exist, so it must have something to do with how the Extension is creating the DB.  Do you know of any default settings that may cause this problem? 

Aug 9, 2012 at 3:56 PM

It looks as though the Create command is creating the database with Auto data/log file growth disabled, which is what is causing my problem.  I suppose I can issue a SQL command to fix that, but is there a way to do this during the create task execution so I do not need to execute two tasks with two separate connections?  

Coordinator
Aug 14, 2012 at 9:51 PM

Is it not a case of fixing your model database?