1
Vote

Unable to install CHEF 2012 version

description

I am getting below error while installing CHEF 2012, pl help. I checked permissions and the account used has create db permission

Build started 10/15/2014 3:04:44 PM.

Project "C:\Program Files\Microsoft\CHEF\MSBuild\scripts\CHEF.proj" (default targets):

Target Scripts:
MSBUILD : warning MSB4010: The "*.tasks" files could not be successfully loaded from their expected location "C:\Program Files\Microsoft\CHEF\MSBuild". Default tasks will not be available.
Updating contents of file "..\..\Database\CHEF.publish.xml".
"C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\SqlPackage" /Action:Publish /SourceFile:"..\..\Database\CHEF.dacpac" /TargetDatabaseName:CHEF /TargetServerName:"BKS023\SQL2K12" /Profile:"..\..\Database\CHEF.publish.xml" /Variables:OutputPackagePath="C:\Program Files\Microsoft\CHEF"
Publishing to database 'CHEF' on server 'BKS023\SQL2K12'.
Initializing deployment (Start)
Initializing deployment (Complete)
Analyzing deployment plan (Start)
Analyzing deployment plan (Complete)
Updating database (Start)
Creating CHEF...
An error occurred while the batch was being executed.
Updating database (Failed)
*** Could not deploy package.
EXEC : error SQL72014: .Net SqlClient Data Provider: Msg 262, Level 14, State 1, Line 1 CREATE DATABASE permission denied in database 'master'.
EXEC : error SQL72045: Script execution error.  The executed script:
CREATE DATABASE [$(DatabaseName)]
    ON 
    PRIMARY(NAME = [$(DatabaseName)], FILENAME = N'$(DefaultDataPath)$(DefaultFilePrefix)_Primary.mdf')
    LOG ON (NAME = [$(DatabaseName)_log], FILENAME = N'$(DefaultLogPath)$(DefaultFilePrefix)_Primary.ldf') COLLATE SQL_Latin1_General_CP1_CI_AS;



C:\Program Files\Microsoft\CHEF\MSBuild\scripts\Scripts.Target(13,5): error MSB3073: The command ""C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\SqlPackage" /Action:Publish /SourceFile:"..\..\Database\CHEF.dacpac" /TargetDatabaseName:CHEF /TargetServerName:"BKS023\SQL2K12" /Profile:"..\..\Database\CHEF.publish.xml" /Variables:OutputPackagePath="C:\Program Files\Microsoft\CHEF"" exited with code 1.
Done building target "Scripts" in project "CHEF.proj" -- FAILED.

Done building project "CHEF.proj" -- FAILED.

Build FAILED.
MSBUILD : warning MSB4010: The "*.tasks" files could not be successfully loaded from their expected location "C:\Program Files\Microsoft\CHEF\MSBuild". Default tasks will not be available.
EXEC : error SQL72014: .Net SqlClient Data Provider: Msg 262, Level 14, State 1, Line 1 CREATE DATABASE permission denied in database 'master'.
EXEC : error SQL72045: Script execution error. The executed script:
C:\Program Files\Microsoft\CHEF\MSBuild\scripts\Scripts.Target(13,5): error MSB3073: The command ""C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\SqlPackage" /Action:Publish /SourceFile:"....\Database\CHEF.dacpac" /TargetDatabaseName:CHEF /TargetServerName:"BKS023\SQL2K12" /Profile:"....\Database\CHEF.publish.xml" /Variables:OutputPackagePath="C:\Program Files\Microsoft\CHEF"" exited with code 1.
1 Warning(s)
3 Error(s)
Time Elapsed 00:00:10.39

comments

NareshRavula wrote Jan 9, 2015 at 11:40 AM

Hi Jayantjape,

I am facing the same error what as you faced while installing the CHEF tool.

Can you please let me know the solution for this?

Is your issue resolved?

Thanks and Regards,
Naresh Ravula

rjsingh wrote Feb 12, 2015 at 12:51 PM

Hi Naresh,

Could you please try executing the Setup.MSI file as Administrator?

Regards,
Ram