SSDT connection error RRS feed

  • Question

  • User639567535 posted

    I follow this tutorial


    for learning SSDT

    now when i install first SSDT this setupd "SSDTBI_x86_ENU"  then when i open visual studio and perform all setup but i stuck on task 7  i try to create DQS cleaning connection manager but this shows an error

    Failed to connect to DQS server the connection manager 'DQS Cleansing Connection Manager.local' as a result of the following value:
    A connection could not be made. Ensure that the server is running.
    System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.ComponentModel.Win32Exception (0x80004005): The network path was not found
       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.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
       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.ProviderBase.DbConnectionClosed.TryOpenConnection(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.Proxy.Database.DBAccessClient..ctor(IDictionary`2 connectionData)
       at Microsoft.Ssdqs.Proxy.Database.DatabaseMetadataUtility..ctor(String instanceName, Boolean useEncryption)
       at Microsoft.Ssdqs.Component.Common.Utilities.ComponentUtility.GetDQDataBases(String connectionString)
       at Microsoft.Ssdqs.Component.Common.Utilities.ComponentUtility.IsDatabaseExist(String connectionString)
       at Microsoft.Ssdqs.Component.Common.UI.Common.DataCorrectionForm.ConnectionManagerChanged(Object sender, EventArgs e)
    Error Number:53,State:0,Class:20

    from SQL server configuration manager all services are up and running and when i try to run DQSInstaller from this path

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

    this shows an error

    when i click SQL Server Data quality client and try to connect

    this shows an error

    how i resolve this

    Tuesday, August 1, 2017 5:57 AM

All replies

  • User347430248 posted

    Hi Capricon Use...,

    please check that your server name  and user name are correct.

    it is possible that you misspelled it or use any other name and because of that you got this error.



    Wednesday, August 2, 2017 2:29 AM
  • User639567535 posted

    username is correct which i enter if that is error then where i check

    Wednesday, August 2, 2017 5:33 AM
  • User347430248 posted

    Hi Capricon Use...,

    please try to follow steps below.

    make sure that your machine have SQL Server Management Studio installed.

    Open  SQL Server Management Studio

    • In the "Connect to Server" window (File->Connect object explorer) enter the following:
    • Server type    : Database Engine
    • Server name    (localdb)\v11.0
    • Authentication : [Whatever you used when you created your local db. Probably Windows Authentication).
    • Click "Connect"
    • Expand the "Databases" folder in the Object Explorer (View->Object Explorer, F8)
    • Find your database. It should be named as the full path to your database (.mdf) file
    • You should see it says "(Pending Recovery)" at the end of the database name or when you try to expand the database it won't be able to and may or may not give you an error message.
    • This the issue! Your database has crashed essentially..
    • Right click on the database then select "Tasks -> Detach...".
    • In the detach window, select your database in the list and check the column that says "Drop Connections"
    • Click OK.
    • You should see the database disappear from the list of databases. Your problem should now be fixed. Go and run your application that uses your localdb.
    • After running your application, your database will re-appear in the list of databases - this is correct. It should not say "Pending recovery" any more since it should be working properly.



    Tuesday, August 8, 2017 6:35 AM