Wednesday, May 24, 2017

Sitecore Demo Retail installation error

After pulling down Sitecore Demo Retail, and attempting to deploy it over Habitat, a couple errors came up during the install-commerce-sites PowerShell script. This one occurred during step 6
Invoke-Sqlcmd : Cannot drop the database 'demo.local_SitecoreCommerce.SharedEnvironments', because it does not exist or you do not have permission.

It traced back to one of the scripts being run: ManageSqlServer.psm1. The line where the dacservice for SQL server was originally the following:
$dacService = new-object Microsoft.SqlServer.Dac.DacServices "server=$server"
Updating the connection string to use windows credentials then allowed it to run correctly.
$dacService = new-object Microsoft.SqlServer.Dac.DacServices "server=$server;Integrated Security = True;"


No comments:

Post a Comment