bakhtawar avatar image
bakhtawar asked

Data quality server connection and installation error

I am trying to install Data quality server installer when i install SQL on feature selection i select all features and installed now i am try to use SSDT SQL Server Data tools first i installed then i try to run DQSinstaller.exe from MS SQL Server bin folder but when i run this shows an error on command prompt that login failed for user 'CORP\MYNAME' then i try to connect on MS SQL Server 2014 Management Studio then this shows an error please check image image ![image][1] is there any solution please after that when i open SQL Server 2014 Data Quality Client and try to connect then this shows same error which is in SQL appear but when i connected with sa i successfully connected but after that when i try to DQSinstaller this shows an error Microsoft (R) DQS Installer Command Line Tool Copyright (c) 2014 Microsoft. All rights reserved. [8/2/2017 12:40:15 PM] DQS Installer started. Installation log will be written to C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log\DQS_install.log [8/2/2017 12:40:15 PM] Setting the collation to default value: SQL_Latin1_General_CP1_CI_AS [8/2/2017 12:40:15 PM] Failed to connect to local instance 'HRS-myname'. System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'CORP\myname'. at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.Ssdqs.DqsInstaller.Utilities.InstallerUtility.TestConnection(String instance, Exception& exception) ClientConnectionId:2c51b0c3-fbb9-4eec-a416-b5deacbdff27 Error Number:18456,State:1,Class:14 Press any key to continue... and also SQL Server Data quality client is not connected also ![image2][1] [1]:
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers


Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.