1. Installed Visual studio SP1(because i was having visual studion ultimate early).
2. Installed MVC4
3. Installed EPI server 7
4. Deployment center installed properly - after that i was trying yo install CMS(Install site and SQL server database), At first it installed properly and created the db.But After clicking install in "install episerver CMS user input screen" i got the following error..
An error has occured and the transaction will be rolled back
Error dropping database user '299067'. Please drop manually.
A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Rolledback
An unhandled error has occured:
CREATE DATABASE permission denied in database 'master'.
User does not have permission to alter database 'dbMyEPiServerSite6', the datab
ase does not exist, or the database is not in a state that allows access checks
.
ALTER DATABASE statement failed.
When executing
At C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Install\Modules\CMO7.0.518.1\
Install EPiServer CMO.ps1:333 char:20
+ New-EPiSqlSvrDB <<<< `
True
=
Get-EPiIsBulkInstalling
Installation failed
An unhandled error has occured:
CREATE DATABASE permission denied in database 'master'.
User does not have permission to alter database 'dbMyEPiServerSite6', the datab
ase does not exist, or the database is not in a state that allows access checks
.
ALTER DATABASE statement failed.
When executing
At C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Install\Modules\CMO7.0.518.1\
Install EPiServer CMO.ps1:333 char:20
+ New-EPiSqlSvrDB <<<< `
=
Get-EPiIsBulkInstalling
At C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Install\Modules\CMO7.0.518.1\Install EPiServer CMO.ps1:333 char:20
+ New-EPiSqlSvrDB <<<< `
System.Data.SqlClient.SqlException (0x80131904): CREATE DATABASE permission denied in database 'master'.
User does not have permission to alter database 'dbMyEPiServerSite6', the database does not exist, or the database is not in a state that allows access checks.
ALTER DATABASE statement failed.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at EPiServer.Install.SqlServer.Cmdlets.NewDatabaseCmdlet.ProcessRecord()
at System.Management.Automation.Cmdlet.DoProcessRecord()
at System.Management.Automation.CommandProcessor.ProcessRecord()
Error - CREATE DATABASE permission denied in database 'master'.
User does not have permission to alter database 'dbMyEPiServerSite6', the database does not exist, or the database is not in a state that allows access checks.
Here are the steps i followed:
1. Installed Visual studio SP1(because i was having visual studion ultimate early).
2. Installed MVC4
3. Installed EPI server 7
4. Deployment center installed properly - after that i was trying yo install CMS(Install site and SQL server database), At first it installed properly and created the db.But After clicking install in "install episerver CMS user input screen" i got the following error..
C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Install\Modules\CMO7.0.518.1\Ins
tall EPiServer CMO.ps1
Installation started
EPiServer CMS version is 7.0.586.1
Wizard created
User input gathered
Creating 'dbMyEPiServerSite6' database
An error has occured and the transaction will be rolled back
Error dropping database user '299067'. Please drop manually.
A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Rolledback
An unhandled error has occured:
CREATE DATABASE permission denied in database 'master'.
User does not have permission to alter database 'dbMyEPiServerSite6', the datab
ase does not exist, or the database is not in a state that allows access checks
.
ALTER DATABASE statement failed.
When executing
At C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Install\Modules\CMO7.0.518.1\
Install EPiServer CMO.ps1:333 char:20
+ New-EPiSqlSvrDB <<<< `
True
=
Get-EPiIsBulkInstalling
Installation failed
An unhandled error has occured:
CREATE DATABASE permission denied in database 'master'.
User does not have permission to alter database 'dbMyEPiServerSite6', the datab
ase does not exist, or the database is not in a state that allows access checks
.
ALTER DATABASE statement failed.
When executing
At C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Install\Modules\CMO7.0.518.1\
Install EPiServer CMO.ps1:333 char:20
+ New-EPiSqlSvrDB <<<< `
=
Get-EPiIsBulkInstalling
At C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Install\Modules\CMO7.0.518.1\Install EPiServer CMO.ps1:333 char:20
+ New-EPiSqlSvrDB <<<< `
System.Data.SqlClient.SqlException (0x80131904): CREATE DATABASE permission denied in database 'master'.
User does not have permission to alter database 'dbMyEPiServerSite6', the database does not exist, or the database is not in a state that allows access checks.
ALTER DATABASE statement failed.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
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()
Error - CREATE DATABASE permission denied in database 'master'.
User does not have permission to alter database 'dbMyEPiServerSite6', the database does not exist, or the database is not in a state that allows access checks.
ALTER DATABASE statement failed.