So far i have been testing the SBC using the express database that SBC installs, because i didnt want to much hassle to test the product itself.
At this point i have reached the point that i need to test the SBC in a replication of my production environment. (yes i have virtualisation luckily)
I am installing SBC in my test environment which is an exact copy of my production environment tho only the needed servers i replicated, the data on the servers is exactly the same:
Domain controller
File server (currently has ADNM installed, SBC is going to replace that)
Database server
In the test environment i uninstalled ADNM without problem and removed the AVAST database on the database server, but i left the instance running for the new database from SBC.
I started the installer.
Did the EXPERT setup.
Went on installing until i reached the database selection screen in the setup.
(accepting default settings because i want to test the database installation with this test)
I choose to use an excisting database server and clicked SEARCH.
In the dropdown i saw the servername from the database server itself, but without any instances.
so i selected the database server name and added \avast for the instance (excisting instance)
i clicked next and the program went installing when suddenly it did a rollback.
I checked the logfiles (see below) and found that the installation wants to login the database server as the computer account. This is ofcourse absolutely not wanted.
I have an SA account for this database from the ADNM installation and the account used to install SBC has the right to install databases in the instance.
Is this a BUG?
OR (and ofcourse its never the users fault ;)) do i do something wrong?
I installed SBC using the windows account that also has rights to go into the database instance and have fun in it (i.e. confirm the SSPI concept).
[Header - Application started at 04-aug-2011 09:58:46,783 local/09:58:46,783 UTC]
08-04 11:58:46,892 [1] INFO SbcServiceInstaller - Installing main avast! Administration Console service.
08-04 11:58:47,002 [1] INFO Net - Preferred NIC initialized: 192.168.100.121
08-04 11:58:47,017 [1] INFO ConnectionStringFactory - Connection string read from stream: Data Source=BZW-DB-01\avast;Initial Catalog=avast_sbc_db;Integrated Security=SSPI;
08-04 11:58:47,080 [1] INFO ConnectionStringFactory - Connection string read from stream: Data Source=BZW-DB-01\avast;Initial Catalog=avast_sbc_db;Integrated Security=SSPI;
08-04 11:58:47,142 [1] INFO DatabaseInstaller - Checking for existing DB or creating a new one.
08-04 11:58:47,906 [1] ERROR SbcServiceInstaller - Problem while installing the service.
System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'BOZW\BZW-CL-000$'.
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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
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)
08-04 11:58:48,155 [1] WARN SbcServiceInstaller - Rolling back the installation
08-04 11:58:48,358 [1] INFO Net - Trying to resolve fully qualified domain name.
08-04 11:58:48,405 [1] INFO Net - Trying to find preferred NIC: 192.168.100.121
08-04 11:58:48,420 [1] INFO Net - Preferred NIC 192.168.100.121 not found.
08-04 11:58:48,420 [1] INFO Net - Parsed!
08-04 11:58:48,420 [1] INFO Net - Using IP address 192.168.100.121.
08-04 11:58:48,420 [1] INFO Net - Resolved DNS name bzw-cl-000.bozw.local, trying to verify reachability.
08-04 11:58:48,436 [1] INFO Net - Target successfully reached using bzw-cl-000.bozw.local.
08-04 11:58:48,436 [1] INFO Net - DNS name resolved to bzw-cl-000.bozw.local.
08-04 11:58:49,246 [1] WARN HttpAclInstaller - Unable to remove URL ACL reservation http://bzw-cl-000.bozw.local:8731/
08-04 11:58:49,246 [1] WARN HttpAclInstaller - Unable to remove URL ACL reservation https://bzw-cl-000.bozw.local:8732/
08-04 11:58:49,246 [1] WARN HttpAclInstaller - Unable to remove URL ACL reservation http://+:8731/Design_Time_Addresses/Avast.Sbc.Service.Core/SbcConnectionPoint/
08-04 11:58:49,246 [1] WARN HttpAclInstaller - Unable to remove URL ACL reservation https://+:8732/Design_Time_Addresses/Avast.Sbc.Service.Core/SbcConnectionPoint/
[Footer]
Its essential that i can install SBC database on the dedicated database server, and its dictating the final approving for buying the product extending my license.
I can use a temporary server with a local installed SBC database but that would be temporary clearly but this would not be more then 1 month possible.
At a less positive note:
The documentation about the database installation is extremely poor, even non-existent. Same goes for the installation options in the database part for the installer.
This exact same problem was present in the ADNM and has been mentioned in the forum more then once. In fact i had a wishlist in the ADNM part which addresses this too. Why has this been
ignored…
When i use a database discovery tool (QUEST DATABASE DISCOVERY WIZARD) i do find the database server together with the instances on that server.
When installing WSUS i can also choose from the db server WITH instances…
If this Quest program can do this and WSUS installer too, then it should be possible for the Avast installer to do this too. Has the trip to Redmond not covered this?