Hi,

I am trying to install SMA 2012 R2 and the setup did not complete with that i cannot diagnose.

The only section in the log where i can find the "error" word is here:

Calling custom action WebServiceCustomActions!WebServiceCustomActions.CustomActions.ValidateProductKey
WebServiceCustomActions:  Validate Product Key.
WebServiceCustomActions:  Product Key:  XXXXX-XXXXX-XXXXX-XXXXX-XXXXX, folder: C:\inetpub\Service Management Automation\bin\
Product key is valid. Pid: 00000-000-0000000-00000 LicenseType: Select
WebServiceCustomActions:  Existing Database
WebServiceCustomActions:  Executing SQL command:  DELETE FROM .. WHERE Name='LicenseInformation'
Invalid object name 'SMA.Configuration.AdminConfigurations'.
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'SMA.Configuration.AdminConfigurations'.
   at System.Data.SqlClient.SqlConnection.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 System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object parentArgs, Object userArgs, ICompiledSubQuery subQueries, Object lastResult)
   at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo queryInfos, IObjectReaderFactory factory, Object userArguments, ICompiledSubQuery subQueries)
   at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
   at System.Data.Linq.DataContext.ExecuteCommand(String command, Object parameters)
   at WebServiceCustomActions.CustomActions.WriteExpirationDatoToDB(Session session, DateTime expirationDate, String connectionString, String database)
ClientConnectionId:4ae43a15-1b5a-462c-96d3-78517aba909b
CustomAction ValidateProductKey returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)

The product key and Product Pid were hidden in the log.

Do you have any idea about this issue ?

Regards.

Yannick

• Edited by YannickBrun Thursday, February 27, 2014 10:08 AM

Hi,

The database server you specified, are you sure you can contact it and have permissions to create the database? No firewall or wrong server name?

Hello Anders,

I am pretty sure i do not have permissions issues.

I manually create the database and the service account is sysadmin on the SQL Server. I succesfully pass the screen where the information for the database connection is entered. If i made a mistake on this screen, i cannot coninue the wizard.

Regards.

Yannick 

Hi,

Just to make sure, you should not pre-create the database. Let the setup wizard create the database and setup permissions.

Hi,

If i do not pre-create the database on the SQL Server, i get an error :"Could not connect with the database or user does not have permission." and the wizard stop.

The user is SYSADMIN in the server and i tryed with Windows Authentication ans SQL Server Authentication.

If i pre-create the database, the wizard continues correctly but failed at the end.

Regards.

• Edited by YannickBrun Thursday, February 27, 2014 5:53 PM

Hi,

I have never pre-created the database, the setup wizard always creates it. I think it is something with your account or the server name, instance name

Hello Anders,

I'm back from vacation and i hope i will succeed in installing SMA :-)

If i do not precreate the database on the SQL server, i obtained the following error in the setup process "Could not connect with the database or user does not have permission.".

The user is full admin in the SQL Server. In the SQL Logs, i have the following errors

Error: 18456, Severity: 14, State 38.

Login failed for user 'XXXX\SmaSvc'. reason: Failed to open the explicitly specified database 'SMA'.

Error: 18456, Severity: 14, State: 40.

Login failed for user 'XXXX\SmaSvc'.Reason: Failed to open the database 'SMA' specified in the login properties.

Regards.

Yannick Brun

OK, i solved my problem. The Login Properties in the SQL Server for the service account does not have a Default database specified. I specified the master database and the setup ends correctly.

Thanks for your help.

Yannick

• Proposed as answer by Jeohist Wednesday, October 15, 2014 10:51 AM

Hi there,

When i install the SMA i face to the same issue. 

By the way i have four instances on my sql server. During the installation when you reach the dbserver settings you must enter the  name of the dbserver and instance like DBSERVER\SMA(Instance name).

Then follow the enter db name that you want to create it.

Regards.

Enis Goktay