Fail in running DQSInstaller.exe

• Donnerstag, 25. August 2011 10:52

   

   
  

  0
  [25.8.2011 10:48:26] DQS Installer started. Installation log will be written to C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\..\Log\DQS_install.log

  [25.8.2011 10:48:28] Using instance: MSSQLSERVER, catalog: DQS.

  [25.8.2011 10:48:28] Executing action: Create data quality event source.

  [25.8.2011 10:48:28] Action 'Create data quality event source' finished successfully.

  [25.8.2011 10:48:28] Executing action: Request Database Master Key password from user..

  [25.8.2011 10:48:44] Action 'Request Database Master Key password from user.' finished successfully.

  [25.8.2011 10:48:44] Executing action: Approve removal of data quality services previous schema.

  [25.8.2011 10:48:45] Action 'Approve removal of data quality services previous schema' finished successfully.

  [25.8.2011 10:48:45] Executing action: Load Installation Scripts.

  [25.8.2011 10:48:45] Extracting script to: C:\Users\admin-jongs\AppData\Local\Temp\2\j0x0tics.l1h

  [25.8.2011 10:48:45] Extracting script: assembly_paths_retail.txt

  [25.8.2011 10:48:45] Extracting script: recreate_schema.bat

  [25.8.2011 10:48:45] Extracting script: register_dlls.cmd

  [25.8.2011 10:48:45] Extracting script: unregister_dlls.cmd

  [25.8.2011 10:48:45] Extracting script: db\create_core_db_objects.sql

  [25.8.2011 10:48:45] Extracting script: db\create_logic_db_objects.sql

  [25.8.2011 10:48:45] Extracting script: db\create_transient_db_objects.sql

  [25.8.2011 10:48:45] Extracting script: db\populate_default_kbs.sql

  [25.8.2011 10:48:45] Extracting script: db\populate_default_kbs_data.sql

  [25.8.2011 10:48:45] Extracting script: db\static_data.sql

  [25.8.2011 10:48:45] Extracting script: helper\DeleteSchemaDs.sql

  [25.8.2011 10:48:45] Extracting script: sql\create_databases.sql

  [25.8.2011 10:48:45] Extracting script: sql\create_service_broker_objects.sql

  [25.8.2011 10:48:45] Extracting script: sql\drop_all_assemblies.sql

  [25.8.2011 10:48:45] Extracting script: sql\drop_all_tables.sql

  [25.8.2011 10:48:45] Extracting script: sql\drop_database_properties.sql

  [25.8.2011 10:48:45] Extracting script: sql\drop_service_broker_objects.sql

  [25.8.2011 10:48:45] Extracting script: sql\master_create.sql

  [25.8.2011 10:48:45] Extracting script: sql\master_recreate.sql

  [25.8.2011 10:48:45] Extracting script: sql\register_assemblies.sql

  [25.8.2011 10:48:45] Extracting script: sql\register_assemblies_tsql.sql

  [25.8.2011 10:48:45] Extracting script: sql\register_dq_assemblies.sql

  [25.8.2011 10:48:45] Total scripts extracted: 22

  [25.8.2011 10:48:45] Action 'Load Installation Scripts' finished successfully.

  [25.8.2011 10:48:45] Executing action: Create data quality schema.

  [25.8.2011 10:48:45] Script: 'recreate_schema.bat SQL-T02 DQS'

  [25.8.2011 10:48:45] . 

  [25.8.2011 10:48:45] 

  [25.8.2011 10:48:45] .  USAGE: recreate_schema.bat host db_name_prefix <nodata> <master key password>

  [25.8.2011 10:48:45] . 

  [25.8.2011 10:48:45] .  WHERE:   

  [25.8.2011 10:48:45] .     db_name_prefix      - prefix of DQS SQL Server catalogs (e.g. for DQS_MAIN and DQS_PROJECTS pass DQS).

  [25.8.2011 10:48:45] .     host                - the name or IP of the database server.

  [25.8.2011 10:48:45] .     nodata              - if present, no out of the box data will be added to DQS default KBs.

  [25.8.2011 10:48:45] .     master key password - if present, will determine the password used to create the database master key.

  [25.8.2011 10:48:45] .  

  [25.8.2011 10:48:45] .  EXAMPLE: recreate_schema titan DQS nodata Pa$$word1

  [25.8.2011 10:48:45] 

  [25.8.2011 10:48:45] Action 'Create data quality schema' finished successfully.

  [25.8.2011 10:48:45] Executing action: Register data quality assemblies and stored procedures.

  [25.8.2011 10:48:45] Script: 'register_dlls.cmd SQL-T02 DQS '

  [25.8.2011 10:48:45] .  Trying to connect using Windows Authentication and db name...

  [25.8.2011 10:48:46] Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Login failed for user '****\*****'..

  [25.8.2011 10:48:46] Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Cannot open database "DQS_MAIN" requested by the login. The login failed..

  [25.8.2011 10:48:46] Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Packet size change not supported by server, default used.

  [25.8.2011 10:48:46] 

  [25.8.2011 10:48:46] 

  [25.8.2011 10:48:46] ERROR - An error occured, check message above

  [25.8.2011 10:48:46] 

  [25.8.2011 10:48:46] 

  [25.8.2011 10:48:46] Script process returned unexpected exit code: '1'.

  [25.8.2011 10:48:46] Action 'Register data quality assemblies and stored procedures' finished with errors, aborting installation.

  [25.8.2011 10:48:47] Starting installation rollback...

  [25.8.2011 10:48:47] Installation rollback completed successfully.

  [25.8.2011 10:48:47] DQS Installer finished with errors. Please see installation log file at C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\..\Log\DQS_install.log

  seems that DQSInstaller.exe does not create the Required Databases and my user failes to loging due to database mapping,, see errror below 

  Message

  Login failed for user '****\****'. Reason: Failed to open the explicitly specified database 

  Best Regards 

  Jon 

  ---

  Jón G Sævarsson
  
  • Antworten
  • Zitieren