DQS Installer ( DqsInstaller ) syntax error

DQS Installer ( DqsInstaller ) syntax error by MelColo

Closed

as Not Reproducible Help for as Not Reproducible

Type:	Bug
ID:	765967
Opened:	10/3/2012 12:07:18 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

I am getting error while executing Dqsinstaller.exe
the sql instance i attempting to configure is a CU3
and has never been configured for dqs before

the log extract is an excerpt from the log file,
all previous lines show no errors

Details (expand)

English

SQL Server 2012 - Developer Edition

Data Quality Services

Windows 7 Enterprise

US English

execute Dqsinstaller.exe
I have reproduced this numerous times

[10/1/2012 7:38:49 AM] Total scripts extracted: 31
[10/1/2012 7:38:49 AM] Action 'Load Installation Scripts' finished successfully.
[10/1/2012 7:38:49 AM] Executing action: Create data quality schema.
[10/1/2012 7:38:49 AM] Script: 'recreate_schema.bat SomeSqlInstnce DQS SQL_Latin1_General_CP1_CI_AS'
[10/1/2012 7:38:49 AM] . Trying to connect using Windows Authentication and db name...
[10/1/2012 7:38:49 AM] Changed database context to 'master'.
[10/1/2012 7:38:49 AM] Msg 911, Level 16, State 1, Server SomeSqlInstnce, Line 107
[10/1/2012 7:38:49 AM] Database 'DQS_MAIN' does not exist. Make sure that the name is entered correctly.
[10/1/2012 7:38:49 AM] Msg 102, Level 15, State 1, Server SomeSqlInstnce, Line 106
[10/1/2012 7:38:49 AM] Incorrect syntax near 'Creating'.
[10/1/2012 7:38:49 AM] ERROR - An error occured, check message above
[10/1/2012 7:38:49 AM]
[10/1/2012 7:38:49 AM]
[10/1/2012 7:38:49 AM] Script process returned unexpected exit code: '1'.
[10/1/2012 7:38:49 AM] Action 'Create data quality schema' finished with errors, aborting installation.
[10/1/2012 7:38:49 AM] Starting installation rollback...
[10/1/2012 7:38:49 AM] Installation rollback completed successfully.
[10/1/2012 7:38:49 AM] DQS Installer finished with errors. Please see installation log file at C:\MSSQL11.MSSQLSERVER\MSSQL\Log\DQS_install.log

DQS installed correctly with no errors

X64

0 attachments

Hi MelColo,

Jason Howell has responded to your sibling post on the MSDN forums ( http://social.msdn.microsoft.com/Forums/en-US/sqldataqualityservices/thread/66fa133d-a63e-4bab-aa00-d2ec5b1f9850/#66fa133d-a63e-4bab-aa00-d2ec5b1f9850 ) with proposed workarounds and suggestions. Have you had a chance to look at the information Jason shared?

Please let us know either way. If we don’t hear back from you this week we’re going to close this issue as “Can’t Reproduce” but we’ll help if we’re able.

Thanks in advance!

Matthew