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

Question

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

Answer 1

The error is telling "SQL Native client is not correctly installed"

So I think the error is probably accurate. Something may have gone wrong in the setup.

Options are

1. You could try to repair the SQL 2012 RTM setup

http://msdn.microsoft.com/en-us/library/cc646006.aspx

2. You could try to install SQL 2012 Service Pack 1

http://www.microsoft.com/en-us/download/details.aspx?id=35575

3. You could try to replace just the SQL Native Client part in isolation (a faster approach)

A. If you have SQL 2012 RTM (no service pack) download SQL 2012 RTM's SQL Native client and rerun that part of the from here:

X86 Package (sqlncli.msi)
X64 Package (sqlncli.msi)

B. If you already have Service Pack 1 for SQL Server 2012 installed, use this copy of SQLNCLI for SP1 instead:

x86 http://download.microsoft.com/download/4/B/1/4B1E9B0E-A4F3-4715-B417-31C82302A70A/ENU/x86/sqlncli.msi

x64 http://download.microsoft.com/download/4/B/1/4B1E9B0E-A4F3-4715-B417-31C82302A70A/ENU/x64/sqlncli.msi

Thanks, Jason

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance