none
MDS 2017 and older versions of SQL Server

    Question

  • Hi, I need help with installation of MDS.

    Can I install newer version od MDS (like MDS 2017) on older version od SQL Server (like SQL Server EE 2014)?
    I tried install it today, but got an error on attempt to create MDS database.

    Error was something about collation.....:

    Microsoft.MasterDataServices.Configuration.ConfigurationException: Conversion of one or more characters from XML to target collation impossible ---> System.Data.SqlClient.SqlException: Conversion of one or more characters from XML to target collation impossible
      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 Microsoft.MasterDataServices.Configuration.DatabaseUtilities.ProcessSqlStringWithTransaction(String commandSql, SqlConnection connection, SqlTransaction upgradeTransaction)
      at Microsoft.MasterDataServices.Configuration.DatabaseUtilities.InstallMasterDataServicesDatabase(SqlConnection connection, String databaseName, String collation, String adminAccount)
      at Microsoft.MasterDataServices.Configuration.Commands.NewMasterDataServicesDatabase.InternalProcess()
      at Microsoft.MasterDataServices.Configuration.Commands.SqlCmd`1.Execute()
      at Microsoft.MasterDataServices.Configuration.InstanceManager.CreateMasterDataServicesDatabase(DatabaseServerInformation serverInformation, DatabaseInformation databaseInformation)
      --- End of inner exception stack trace ---

    Monday, March 4, 2019 4:07 PM