none
Sqlcmd: error: error de conexión. Microsoft SQL Native Client no está instalado correctamente. Para solucionarlo, ejecute el programa

    Frage

  • Hi!

    I want to install Data Quality Server in my laptop Win 7 64 bit, SQL Server 2012 BI Edt. I installed all the sql services. I want to use Data Quality Services, but when I run the Data Quaity Server Installer this error is displaying me:

    Sqlcmd: error: error de conexión. Microsoft SQL Native Client no está instalado correctamente.

    Bellow I enclosed the log.

    What do you suggest me to fix this error? I have reinstalled Microsoft SQL Native Client but didn't work.

    Thanks for your help.

    Regards,

    Laura C.

    ------------------------------------------------------------

    [21/02/2013 10:40:23 a.m.] DQS Installer started. Installation log will be written to C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\DQS_install.log

    [21/02/2013 10:40:23 a.m.] Setting the collation to default value: SQL_Latin1_General_CP1_CI_AS
    [21/02/2013 10:40:23 a.m.] Using instance: MSSQLSERVER, catalog: DQS.
    [21/02/2013 10:40:23 a.m.] Executing action: Validate collation argument.
    [21/02/2013 10:40:23 a.m.] Action 'Validate collation argument' finished successfully.
    [21/02/2013 10:40:23 a.m.] Executing action: Check whether system reboot is pending.
    [21/02/2013 10:40:23 a.m.] Action 'Check whether system reboot is pending' finished successfully.
    [21/02/2013 10:40:23 a.m.] Executing action: Create data quality event source.
    [21/02/2013 10:40:24 a.m.] Action 'Create data quality event source' finished successfully.
    [21/02/2013 10:40:24 a.m.] Executing action: Request Database Master Key password from user..
    Database Master Key password must be at least 8 characters long, and must contain characters from three of the following four categories:  an English uppercase letter (A, B, C,. Z), an English lowercase letter (a, b, c,. z), a numeral (0, 1, 2,. 9), and a special character (~, !, @, #, $, %, ^, &, *, _, -, +, =, `, |,\, (, ), {, }, [, ], :, ;, ", ', <, >, ., ?, /, and ,).

    Please enter a password for the Database Master Key:
    ********
    Please confirm the password entered for the Database Master Key:
    ********
    [21/02/2013 10:40:38 a.m.] Action 'Request Database Master Key password from user.' finished successfully.
    [21/02/2013 10:40:38 a.m.] Executing action: Approve removal of data quality services previous schema.
    [21/02/2013 10:40:38 a.m.] Action 'Approve removal of data quality services previous schema' finished successfully.
    [21/02/2013 10:40:38 a.m.] Executing action: Load Installation Scripts.
    [21/02/2013 10:40:38 a.m.] Extracting script to: C:\Users\Administrador\AppData\Local\Temp\snypu3ak.k0u
    [21/02/2013 10:40:38 a.m.] Extracting script: db\create_core_db_objects.sql
    [21/02/2013 10:40:38 a.m.] Extracting script: db\create_logic_db_objects.sql
    [21/02/2013 10:40:39 a.m.] Extracting script: db\create_transient_db_objects.sql

    [21/02/2013 10:40:39 a.m.] Extracting script: db\static_data.sql
    [21/02/2013 10:40:39 a.m.] Extracting script: db\drop_dq_databases.sql
    [21/02/2013 10:40:39 a.m.] Extracting script: helper\DeleteSchemaDs.sql
    [21/02/2013 10:40:39 a.m.] Extracting script: sql\drop_all_assemblies.sql
    [21/02/2013 10:40:39 a.m.] Extracting script: sql\create_databases.sql
    [21/02/2013 10:40:39 a.m.] Extracting script: sql\drop_databases.sql
    [21/02/2013 10:40:39 a.m.] Extracting script: sql\drop_all_tables.sql
    [21/02/2013 10:40:39 a.m.] Extracting script: sql\drop_database_properties.sql
    [21/02/2013 10:40:39 a.m.] Extracting script: sql\master_create.sql
    [21/02/2013 10:40:39 a.m.] Extracting script: sql\master_recreate.sql
    [21/02/2013 10:40:39 a.m.] Extracting script: sql\register_assemblies.sql
    [21/02/2013 10:40:39 a.m.] Extracting script: sql\register_assemblies_tsql.sql
    [21/02/2013 10:40:39 a.m.] Extracting script: sql\register_dq_assemblies.sql
    [21/02/2013 10:40:39 a.m.] Extracting script: sql\create_service_broker_objects.sql
    [21/02/2013 10:40:39 a.m.] Extracting script: sql\drop_service_broker_objects.sql
    [21/02/2013 10:40:39 a.m.] Extracting script: recreate_schema.bat
    [21/02/2013 10:40:39 a.m.] Extracting script: drop_databases.cmd
    [21/02/2013 10:40:39 a.m.] Extracting script: register_dlls.cmd
    [21/02/2013 10:40:39 a.m.] Extracting script: unregister_dlls.cmd
    [21/02/2013 10:40:39 a.m.] Extracting script: assembly_paths_retail.txt
    [21/02/2013 10:40:39 a.m.] Extracting script: DQS_Data.dqs
    [21/02/2013 10:40:39 a.m.] Extracting script: DefaultKbs.xml
    [21/02/2013 10:40:39 a.m.] Total scripts extracted: 25
    [21/02/2013 10:40:39 a.m.] Action 'Load Installation Scripts' finished successfully.
    [21/02/2013 10:40:39 a.m.] Executing action: Create data quality schema.
    [21/02/2013 10:40:39 a.m.] Script: 'recreate_schema.bat IMSLAURACANO DQS SQL_Latin1_General_CP1_CI_AS'
    [21/02/2013 10:40:39 a.m.] .  Trying to connect using Windows Authentication and db name...
    [21/02/2013 10:40:39 a.m.] Sqlcmd: error: error de conexión. Microsoft SQL Native Client no está instalado correctamente. Para solucionarlo, ejecute el programa  de instalación de SQL Server.
    [21/02/2013 10:40:39 a.m.] ERROR - An error occured, check message above
    [21/02/2013 10:40:40 a.m.]
    [21/02/2013 10:40:40 a.m.]
    [21/02/2013 10:40:40 a.m.] Script process returned unexpected exit code: '1'.
    [21/02/2013 10:40:40 a.m.] Action 'Create data quality schema' finished with errors, aborting installation.
    [21/02/2013 10:40:40 a.m.] Starting installation rollback...
    [21/02/2013 10:40:40 a.m.] Installation rollback completed successfully.
    [21/02/2013 10:40:40 a.m.] DQS Installer finished with errors. Please see installation log file at C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSS
    QL\Log\DQS_install.log
    Press any key to continue...

    ------------------------------------------------------------

    20/02/2013 04:32:02 p.m.|[]|1|INFO|PUID|Microsoft.Ssdqs.Proxy.EntryPoint.ProxyInit|Starting DQS ProxyInit: version [11.0.2100.60], machine name [DEVELOP], user name [DEVELOP\Administrador], operating system [Microsoft Windows NT 6.1.7601 Service Pack 1]...
    20/02/2013 04:32:03 p.m.|[]|1|INFO|PUID|Microsoft.Ssdqs.Proxy.EntryPoint.ProxyInit|DQS ProxyInit started.


    Laura Cano

    Donnerstag, 21. Februar 2013 18:10

Alle Antworten