This is my setting during installation of ESMC on our application server. Db is on another server. I put in a brand new name for the db and I use the sa account to set it up. See attached Pic1.
I get an error like in Pic2, saying 'The specified database was not used for this purpose before or it is corrupted.'. Which I think stands for "Db_Invalid".
I have tried as above but with preparing a db and another owner user (then sa) but wwhen I install with those settings it has not been working either!
What am I missing? Why is the database not accepted?
Here is the last part of the log produced by the installer;
Action start 10:06:26: CA_DbCheckConnection.
MSI (c) (B8:D4) [10:06:26:237]: Invoking remote custom action. DLL: C:\Users\ADMINI~1.HPT\AppData\Local\Temp\2\MSI9A8D.tmp, Entrypoint: DbCheckConnection
MSI (c) (B8!A8) [10:06:26:317]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Custom action 'CheckStringWithRegex' ended.'. Its new value: 'INFO: Custom action 'DbCheckConnection' successfully initialized.'.
MSI (c) (B8!A8) [10:06:26:317]: PROPERTY CHANGE: Deleting P_DB_CONNECTION_STATUS property. Its current value is '77701'.
MSI (c) (B8!A8) [10:06:26:317]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Custom action 'DbCheckConnection' successfully initialized.'. Its new value: 'INFO: (SetProperty) Successful SET property 'P_DB_CONNECTION_STATUS' with value - '.
MSI (c) (B8!A8) [10:06:26:317]: PROPERTY CHANGE: Deleting P_DB_STATUS property. Its current value is 'DB_INVALID'.
MSI (c) (B8!A8) [10:06:26:317]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: (SetProperty) Successful SET property 'P_DB_CONNECTION_STATUS' with value - '. Its new value: 'INFO: (SetProperty) Successful SET property 'P_DB_STATUS' with value - '.
MSI (c) (B8!A8) [10:06:26:317]: PROPERTY CHANGE: Deleting P_DB_UPGRADE property. Its current value is '0'.
MSI (c) (B8!A8) [10:06:26:317]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: (SetProperty) Successful SET property 'P_DB_STATUS' with value - '. Its new value: 'INFO: (SetProperty) Successful SET property 'P_DB_UPGRADE' with value - '.
MSI (c) (B8!A8) [10:06:26:317]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: (SetProperty) Successful SET property 'P_DB_UPGRADE' with value - '. Its new value: 'INFO: (SetProperty) Successful SET property 'P_DB_USE_FIRST_USER' with value - '.
MSI (c) (B8!A8) [10:06:26:317]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: (SetProperty) Successful SET property 'P_DB_USE_FIRST_USER' with value - '. Its new value: 'INFO: Successful GET property 'Installed' with value - '.
MSI (c) (B8!A8) [10:06:26:318]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'Installed' with value - '. Its new value: 'INFO: Successful GET property 'P_UPGRADE' with value - '.
MSI (c) (B8!A8) [10:06:26:318]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_UPGRADE' with value - '. Its new value: 'INFO: Successful GET property 'P_DB_TYPE' with value - MS SQL Server'.
MSI (c) (B8!A8) [10:06:26:318]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_DB_TYPE' with value - MS SQL Server'. Its new value: 'INFO: Successful GET property 'P_PRODUCT_NAME' with value - Server'.
MSI (c) (B8!A8) [10:06:26:318]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_PRODUCT_NAME' with value - Server'. Its new value: 'INFO: Successful GET property 'P_DB_CONNECTORS_DIR' with value - C:\Users\ADMINI~1.HPT\AppData\Local\Temp\2\EsetRemoteAdminServer\{22DBE555-DD68-4A8A-90D2-A2827D021097}\'.
MSI (c) (B8!A8) [10:06:26:318]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_DB_CONNECTORS_DIR' with value - C:\Users\ADMINI~1.HPT\AppData\Local\Temp\2\EsetRemoteAdminServer\{22DBE555-DD68-4A8A-90D2-A2827D021097}\'. Its new value: 'INFO: Successful GET property 'P_DB_SCRIPTS_DIR' with value - C:\Users\ADMINI~1.HPT\AppData\Local\Temp\2\EsetRemoteAdminServer\{22DBE555-DD68-4A8A-90D2-A2827D021097}\Database'.
MSI (c) (B8!A8) [10:06:26:318]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_DB_SCRIPTS_DIR' with value - C:\Users\ADMINI~1.HPT\AppData\Local\Temp\2\EsetRemoteAdminServer\{22DBE555-DD68-4A8A-90D2-A2827D021097}\Database'. Its new value: 'INFO: Successful GET property 'P_DB_DRIVER' with value - SQL Server'.
MSI (c) (B8!A8) [10:06:26:318]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_DB_DRIVER' with value - SQL Server'. Its new value: 'INFO: Successful GET property 'P_DB_HOSTNAME' with value - vi8srvdba004'.
MSI (c) (B8!A8) [10:06:26:318]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_DB_HOSTNAME' with value - vi8srvdba004'. Its new value: 'INFO: Successful GET property 'P_DB_PORT' with value - 1433'.
MSI (c) (B8!A8) [10:06:26:319]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_DB_PORT' with value - 1433'. Its new value: 'INFO: (SetProperty) Successful SET property 'P_DB_PORT' with value - 1433'.
MSI (c) (B8!A8) [10:06:26:319]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: (SetProperty) Successful SET property 'P_DB_PORT' with value - 1433'. Its new value: 'INFO: Successful GET property 'P_DB_NAME' with value - eset_smc_db'.
MSI (c) (B8!A8) [10:06:26:319]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_DB_NAME' with value - eset_smc_db'. Its new value: 'INFO: Successful GET property 'P_DB_ADMIN_USERNAME' with value - **********'.
MSI (c) (B8!A8) [10:06:26:319]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_DB_ADMIN_USERNAME' with value - **********'. Its new value: 'INFO: Successful GET property 'P_DB_ADMIN_PASSWORD' with value - **********'.
MSI (c) (B8!A8) [10:06:26:319]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Successful GET property 'P_DB_ADMIN_PASSWORD' with value - **********'. Its new value: 'INFO: (GetDatabaseServerConnectionStringWithoutEscape) Created connection string: 'Driver=SQL Server;Server=vi8srvdba004,1433;Uid=******;Pwd={******};CharSet=utf8;''.
MSI (c) (B8!A8) [10:06:26:319]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: (GetDatabaseServerConnectionStringWithoutEscape) Created connection string: 'Driver=SQL Server;Server=vi8srvdba004,1433;Uid=******;Pwd={******};CharSet=utf8;''. Its new value: 'INFO: Entering function: void __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,class Era::Setup::Common::Database::Framework::ConnectOptions)'.
MSI (c) (B8!A8) [10:06:26:335]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Entering function: void __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,class Era::Setup::Common::Database::Framework::ConnectOptions)'. Its new value: 'INFO: Leaving function: void __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,class Era::Setup::Common::Database::Framework::ConnectOptions)'.
MSI (c) (B8!A8) [10:06:26:335]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Leaving function: void __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::TestConnection(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,class Era::Setup::Common::Database::Framework::ConnectOptions)'. Its new value: 'INFO: Entering function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionOfDbServer(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)'.
MSI (c) (B8!A8) [10:06:26:336]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Entering function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionOfDbServer(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)'. Its new value: 'INFO: DatabaseReader: Recycling current DB connection.'.
MSI (c) (B8!A8) [10:06:26:336]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: DatabaseReader: Recycling current DB connection.'. Its new value: 'INFO: Leaving function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionOfDbServer(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)'.
MSI (c) (B8!A8) [10:06:26:336]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Leaving function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetVersionOfDbServer(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)'. Its new value: 'INFO: SQL Database server version is '12.0.5223.6', which is considered as SUPPORTED.'.
MSI (c) (B8!A8) [10:06:26:337]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: SQL Database server version is '12.0.5223.6', which is considered as SUPPORTED.'. Its new value: 'INFO: DatabaseReader: Recycling current DB connection.'.
MSI (c) (B8!A8) [10:06:26:623]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: DatabaseReader: Recycling current DB connection.'. Its new value: 'INFO: Entering function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetDatabaseStatusForDBServer(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)'.
MSI (c) (B8!A8) [10:06:26:623]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Entering function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetDatabaseStatusForDBServer(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &)'. Its new value: 'INFO: DatabaseReader: Recycling current DB connection.'.
MSI (c) (B8!A8) [10:06:26:634]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: DatabaseReader: Recycling current DB connection.'. Its new value: 'INFO: Entering function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetDatabaseStatus(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,class std::basic_stringstream<char,struct std::char_traits<char>,class std::allocator<char> > &,class std::vector<class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> >,class std::allocator<class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > > > &)'.
MSI (c) (B8!A8) [10:06:26:635]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Entering function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetDatabaseStatus(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,class std::basic_stringstream<char,struct std::char_traits<char>,class std::allocator<char> > &,class std::vector<class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> >,class std::allocator<class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > > > &)'. Its new value: 'INFO: Leaving function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::Ge
MSI (c) (B8!A8) [10:06:26:635]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Leaving function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetDatabaseStatus(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,class std::basic_stringstream<char,struct std::char_traits<char>,class std::allocator<char> > &,class std::vector<class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> >,class std::allocator<class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > > > &)'. Its new value: 'INFO: Leaving function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::Get
MSI (c) (B8!A8) [10:06:26:635]: PROPERTY CHANGE: Adding P_DB_STATUS property. Its value is 'DB_INVALID'.
MSI (c) (B8!A8) [10:06:26:635]: PROPERTY CHANGE: Modifying P_LAST_LOG_MESSAGE property. Its current value is 'INFO: Leaving function: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > __cdecl Era::Setup::Common::CustomActions::CDatabaseReader::GetDatabaseStatusForDBServer(const class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > &,const class std::basic_string<char,struct std::char_t