Install new site via DeployCenter and VS plugin fails

Vote:
 

Hi,

An error occurs when installing a new site using the deployment center and via the VS plugin.

The trace indicates "CREATE DATABASE permission denied in database 'master'.". I connect to the database using Windows Authentication...

I can install a new site using the deployment center option "without database".

Any ideas?

Full stack trace as follows:

Started a transacted install
Copying C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\application to C:\EPiServer\dave3\wwwroot
Copying C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin to C:\EPiServer\dave3\wwwroot\bin
productPath: C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\
installedVersion: 0.0.0.0
frameworkVersion: 7.5.394.2
AppData path: C:\EPiServer\dave3\appdata
Applying web config modification for EPiServer Framework 6.0.318.113
Applying web config modification for EPiServer Framework 6.1.79.0
Applying web config modification for EPiServer Framework 6.2.267.1
Applying web config modification for EPiServer Framework 7.5.394.2
Removing assembly redirect for EPiServer.Shell.UI
Skipping EPiServer.Shell.UI since assembly redirects are not found
Copying C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\bin to C:\EPiServer\dave3\wwwroot\bin
Assembly redirect for EPiServer.ApplicationModules.dll
Adding/Updating assembly redirect for EPiServer.ApplicationModules
Assembly redirect for EPiServer.Data.Cache.dll
Adding/Updating assembly redirect for EPiServer.Data.Cache
Assembly redirect for EPiServer.Data.dll
Adding/Updating assembly redirect for EPiServer.Data
Assembly redirect for EPiServer.Events.dll
Adding/Updating assembly redirect for EPiServer.Events
Assembly redirect for EPiServer.Framework.dll
Adding/Updating assembly redirect for EPiServer.Framework
Assembly redirect for EPiServer.Licensing.dll
Adding/Updating assembly redirect for EPiServer.Licensing
Assembly redirect for EPiServer.Shell.dll
Adding/Updating assembly redirect for EPiServer.Shell
Assembly redirect for Newtonsoft.Json.dll
Adding/Updating assembly redirect for Newtonsoft.Json
Assembly redirect for StructureMap.dll
Adding/Updating assembly redirect for StructureMap
Adding/Updating assembly redirect for System.Web.Mvc
Installing Add-Ons:


Id : EPiServer.Packaging
Title : EPiServer Add-On Store Platform
Version : 3.0.1845

Id : EPiServer.Packaging.UI
Title : EPiServer Add-On Store UI
Version : 3.0.1845

Id : Shell
Title : EPiServer UI Platform
Version : 3.0.1209

Copying C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Geolocation to C:\EPiServer\dave3\appdata\Geolocation
Assembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\Castle
.Core.dll
Adding/Updating assembly redirect for Castle.Core
Assembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\Castle
.Windsor.dll
Adding/Updating assembly redirect for Castle.Windsor
Assembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiSer
ver.BaseLibrary.dll
Adding/Updating assembly redirect for EPiServer.BaseLibrary
Assembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiSer
ver.Configuration.dll
Adding/Updating assembly redirect for EPiServer.Configuration
Assembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiSer
ver.dll
Adding/Updating assembly redirect for EPiServer
Assembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiSer
ver.Enterprise.dll
Adding/Updating assembly redirect for EPiServer.Enterprise
Assembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiSer
ver.ImageLibrary.dll
Adding/Updating assembly redirect for EPiServer.ImageLibrary
Assembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiSer
ver.Implementation.dll
Adding/Updating assembly redirect for EPiServer.Implementation
Assembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiSer
ver.LinkAnalyzer.dll
Adding/Updating assembly redirect for EPiServer.LinkAnalyzer
Assembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiSer
ver.UI.dll
Adding/Updating assembly redirect for EPiServer.UI
Assembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiSer
ver.Web.WebControls.dll
Adding/Updating assembly redirect for EPiServer.Web.WebControls
Assembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiSer
ver.WorkflowFoundation.dll
Adding/Updating assembly redirect for EPiServer.WorkflowFoundation
Assembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\EPiSer
ver.XForms.dll
Adding/Updating assembly redirect for EPiServer.XForms
Assembly redirect for C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\bin\log4ne
t.dll
Adding/Updating assembly redirect for log4net
Installing Add-Ons:


Id : CMS
Title : EPiServer Edit UI
Version : 3.0.1097

Id : EPiServer.Suite
Title : EPiServer
Version : 7.5.394

An error has occured and the transaction will be rolled back
Rolledback
CREATE DATABASE permission denied in database 'master'.
CREATE DATABASE permission denied in database 'master'.

An unhandled error has occured:
CREATE DATABASE permission denied in database 'master'.
When executing
At C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\Install\System Scripts\Instal
l Database (SqlServer).ps1:126 char:3
+ New-EPiSqlSvrDB `
+ ~~~~~~~~~~~~~~~~~

True
=
Get-EPiIsBulkInstalling

An unhandled error has occured:
CREATE DATABASE permission denied in database 'master'.
When executing
At C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\Install\System Scripts\Instal
l Database (SqlServer).ps1:126 char:3
+ New-EPiSqlSvrDB `
+ ~~~~~~~~~~~~~~~~~

=
Get-EPiIsBulkInstalling
At C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\Install\System Scripts\Install Database (SqlServer).ps1:126 char:3
+ New-EPiSqlSvrDB `
+ ~~~~~~~~~~~~~~~~~
System.Data.SqlClient.SqlException (0x80131904): CREATE DATABASE permission denied in database 'master'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at EPiServer.Install.SqlServer.Installers.NewDatabaseInstaller.Install(IDictionary stateSaver)
at EPiServer.Install.Common.AppDomains.NonTransactedSqlInstaller`1.Install()
at EPiServer.Install.Common.AppDomains.NonTransactedSqlInstaller`1.Install()
at EPiServer.Install.Common.AppDomains.RunInAppDomainInstaller.Install(IDictionary stateSaver)
at EPiServer.Install.InstallationManager.Install(Installer installer)
at EPiServer.Install.SqlServer.SqlServerInstallationManager.CreateDatabase(String sqlServerName, Nullable`1 sqlServerPort, String databaseName, String loginName, String loginPassword, String epiServerSqlScriptPath, Boolean isEPiServerScript, Boolean installAspNetSchema, Boolean installWFSchema, Int32 progressPercent)
at EPiServer.Install.SqlServer.Cmdlets.NewDatabaseCmdlet.ProcessRecord()
at System.Management.Automation.Cmdlet.DoProcessRecord()
at System.Management.Automation.CommandProcessor.ProcessRecord()
ClientConnectionId:5ac1fe32-a6e3-4a5c-b226-da89d25e37bf

#88694
Jul 25, 2014 11:38
Vote:
 

Hi, 

Make sure that SQL server has mixed mode authentication enabled (SQL server and Windows Authentication mode).

#88696
Jul 25, 2014 11:53
Vote:
 

Thanks for the advice Shahid, alas AFAIK the SQLServer is running in WA auth mode only. I've tried all sorts of ways to change it but without success. Therefore I tried uninstalling and reinstalling but that just messed things up. Have rolled back the VM and am just going to hack the existing Alloy demo site...

#88700
Jul 25, 2014 16:31
Vote:
 

It looks like your user has no right to create a database.

If you download the latest version of the EPiServer plugin you will not have to create a database in a database server, it just create a mdb-file in the appdata folder and use localDB-connection.

To install the latest version you have to uninstall the existing one and install it again, it seams like the check for new version does not work.

#88707
Jul 26, 2014 13:43
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.