sql-serversql-server-2017ssms-17data-quality-services

while runing DQSinstaller.exe it fails with following description why?


I have installed sql server 2017 and SSMS 2017 but when i run dqsintaller.exe it fails with errors which are as follows

Please help me resolve issue as i am newbie and still learning and working out how things works around



[16/03/2020 4:38:38 pm]      * Clear the Code Member Table A_CODE_MEMBER.
[16/03/2020 4:38:38 pm] 
[16/03/2020 4:38:38 pm] (0 rows affected)
[16/03/2020 4:38:38 pm]  
[16/03/2020 4:38:38 pm]      * Clear the Code Group Table A_CODE_GROUP.
[16/03/2020 4:38:38 pm] 
[16/03/2020 4:38:38 pm] (0 rows affected)
[16/03/2020 4:38:38 pm]  
[16/03/2020 4:38:38 pm]      * Register assemblies T-SQL executable objects
[16/03/2020 4:38:38 pm]         - Creating assemblies T-SQL registeration stored procedure.
[16/03/2020 4:38:38 pm]  
[16/03/2020 4:38:38 pm]      * Creating the internal_core schema
[16/03/2020 4:38:38 pm]         - Registering Microsoft.Ssdqs.Infra T-SQL executable objects.
[16/03/2020 4:38:40 pm] HResult 0x197A, Level 16, State 1
[16/03/2020 4:38:40 pm] A .NET Framework error occurred during execution of user-defined routine or aggregate "RegisterAssembly": 
[16/03/2020 4:38:40 pm] System.TypeInitializationException: The type initializer for 'Microsoft.Ssdqs.Core.Startup.ServerInit' threw an exception. ---> Microsoft.Ssdqs.Infra.Exceptions.ServerException: Failed to initialize configuration. ---> Microsoft.Ssdqs.Infra.Log.LogMessageFormatException: Failed to init log configuration. ---> System.Data.SqlClient.SqlException: The locale identifier (LCID) 8192 is not supported by SQL Server.
[16/03/2020 4:38:40 pm] System.Data.SqlClient.SqlException: 
[16/03/2020 4:38:40 pm]    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
[16/03/2020 4:38:40 pm]    at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.DispatchMessages(Boolean ignoreNonFatalMessages)
[16/03/2020 4:38:40 pm]    at System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)
[16/03/2020 4:38:40 pm]    at System.Data.SqlClient.SqlDataReaderSmi.NextResult()
[16/03/2020 4:38:40 pm]    at System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
[16/03/2020 4:38:40 pm]    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
[16/03/2020 4:38:40 pm]    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
[16/03/2020 4:38:40 pm]    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
[16/03/2020 4:38:40 pm]    at System.Data.SqlClient.SqlCommand.ExecuteReader()
[16/03/2020 4:38:40 pm]    at Microsoft.Ssdqs.Infra.Database.DBAccess.ExecCommand()
[16/03/2020 4:38:40 pm]    at Microsoft.Ssdqs.Infra.Database.Dao.DaoControllerBase`5.Execute()
[16/03/2020 4:38:40 pm]    at Microsoft.Ssdqs.Infra.Log.LLogger.InitLogWriter()
[16/03/2020 4:38:40 pm]    at Microsoft.Ssdqs.Infra.Log.LLogger.InitConfiguration()
[16/03/2020 4:38:40 pm] Microsoft.Ssdqs.Infra.Log.LogMessageFormatException: 
[16/03/2020 4:38:40 pm]    at Microsoft.Ssdqs.Infra.Log.LLogger.InitConfiguration()
[16/03/2020 4:38:40 pm]    at Microsoft.Ss...
[16/03/2020 4:38:40 pm] 
[16/03/2020 4:38:40 pm] 
[16/03/2020 4:38:40 pm] ERROR - An error occured, check message above
[16/03/2020 4:38:40 pm] 
[16/03/2020 4:38:40 pm] 
[16/03/2020 4:38:40 pm] Script process returned unexpected exit code: '1'.
[16/03/2020 4:38:40 pm] Action 'Register data quality assemblies and stored procedures' finished with errors, aborting installation.
[16/03/2020 4:38:40 pm] Starting installation rollback...
[16/03/2020 4:38:40 pm] Installation rollback completed successfully.
[16/03/2020 4:38:40 pm] DQS Installer finished with errors. Please see installation log file at C:\Program Files\Microsoft SQL Server\MSSQL14.SQLSERVER\MSSQL\Log\DQS_install.log

After changing my locale ID and and Locale Name i have successfully installed DQS server . But when i enter the server as local server in DQS Client Application it is arising the same error again please see the following Snapshot

enter image description here


Solution

  • After 3 days of searching and implementing different techniques i came to solution.The solution is very simple but tricky

    First of all open cmd and run as administrator

    then run following command

    WMIC current useraccount get name,sid
    

    Then run registory editor and go to

    HKEY_USER -> SID_as_Folder_Name -> Control Panel -> International

    There you will see your locale and LocaleName according to your local you have to change it according to SQL Server locale like in my case i cahnged Locale = 1 and LocaleName = en-US .

    Then Uninstall the server and reinstall the server before running command to install DSQinstaller.exe go to Services and select SQL server service

    right click on it and goto properties Select Log On Tab and select local System account radio option.

    Then run CMD as administrator and locate your DQSinstaller location as in my case it was

    C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Binn

    then execute following command

    DQSInstaller.exe –upgradedlls –instance MSSQLSERVER
    

    after completion of installation open DSQ client application if you still getting error as in mentioned in my question detail run the following command in cmd after locating your SQL Server instance run following command

    DQSInstaller.exe -upgradedlls
    

    after finishing upgradedlls you will be able to connect to DQS successfully.