Hi I’m trying to install the new BP Console RTM with a remote SQL server but it just keeps throwing an error every time about not being able to create the SQL Database on the remote server (See below). I have permission to create DB’s on the server etc so I’m not sure what’s wrong, anyone have an idea?
[Header - Application started at 22-Jul-2011 10:50:14,359 local/10:50:14,359 UTC] 07-22 11:50:15,381 [1] INFO SbcServiceInstaller - Installing main avast! Administration Console service. 07-22 11:50:16,457 [1] INFO Net - Preferred NIC initialized: 10.1.10.80 07-22 11:50:16,460 [1] INFO ConnectionStringFactory - Connection string read from stream: Data Source=;Initial Catalog=avast_sbc_db;Integrated Security=SSPI; 07-22 11:50:16,979 [1] INFO ConnectionStringFactory - Connection string read from stream: Data Source=;Initial Catalog=avast_sbc_db;Integrated Security=SSPI; 07-22 11:50:17,206 [1] INFO DatabaseInstaller - Checking for existing DB or creating a new one. 07-22 11:50:19,823 [1] ERROR DatabaseInstaller - Error creating a new database. System.Data.SqlClient.SqlException (0x80131904): CREATE DATABASE permission denied in database 'master'. 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 Avast.Sbc.Service.Installer.DatabaseInstaller.executeNonQuery(SqlConnection connection, String sql) at Avast.Sbc.Service.Installer.DatabaseInstaller.CreateDatabase() 07-22 11:50:20,407 [1] ERROR SbcServiceInstaller - Problem while installing the service. System.Data.SqlClient.SqlException (0x80131904): CREATE DATABASE permission denied in database 'master'. 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 Avast.Sbc.Service.Installer.DatabaseInstaller.executeNonQuery(SqlConnection connection, String sql) at Avast.Sbc.Service.Installer.DatabaseInstaller.CreateDatabase() at Avast.Sbc.Service.Installer.DatabaseInstaller.ClaimDatabase() at Avast.Sbc.Service.Installer.DatabaseInstaller.Install() at Avast.Sbc.Service.SbcServiceInstaller.Install(IDictionary stateSaver) 07-22 11:50:21,508 [1] WARN SbcServiceInstaller - Rolling back the installation 07-22 11:50:22,502 [1] INFO Net - Trying to resolve fully qualified domain name.