automating SQL installation

[bjham13]

Hello All,

I am new to AutoIt, and hope that someone out there can help me with my issue.

The problem I am having is that the script is exiting part-way through (See script below).

Line 1 and 2 run without any issue. But when it gets to the end of the second line, the script exits with and exit code of '0'. So line 3 and 4 get missed.

Any help that can be given on this one would be highly appreciated.

Thanks in advance.

RunWait("Windows XP Power Shell /quiet /norestart")

RunWait('SQLEXPR.EXE /qb ADDLOCAL="SQL_Engine,SQL_Data_Files,Connectivity" INSTANCENAME="instance" install=SQL_Engine SECURITYMODE=SQL SAPWD="password" DISABLENETWORKPROTOCOLS=0 SKUUPGRADE=1 SQLACCOUNT="NT AUTHORITY\SYSTEM" AGTACCOUNT="NT AUTHORITY\SYSTEM" SQLBROWSERACCOUNT="NT AUTHORITY\SYSTEM" SQLBROWSERAUTOSTART=1 SQLAUTOSTART=1 AGTAUTOSTART=1 SQLCOLLATION="Latin1_General_CI_AS"')

RunWait('sqlcmd -U sa -P password -S .\instance -d "MASTER" -i addVBQUser.sql')

RunWait("SQLServer2005_SSMSEE.msi /q")

Exit

[jchd]

Multi-line AutoIt statements require AutoIt line continuation:

RunWait("Windows XP Power Shell /quiet /norestart")
RunWait('SQLEXPR.EXE /qb ADDLOCAL="SQL_Engine,SQL_Data_Files,Connectivity" INSTANCENAME="instance" ' & _
'install=SQL_Engine SECURITYMODE=SQL SAPWD="password" DISABLENETWORKPROTOCOLS=0 ' & _
'SKUUPGRADE=1 SQLACCOUNT="NT AUTHORITYSYSTEM" AGTACCOUNT="NT AUTHORITYSYSTEM" ' & _
'SQLBROWSERACCOUNT="NT AUTHORITYSYSTEM" SQLBROWSERAUTOSTART=1 SQLAUTOSTART=1 AGTAUTOSTART=1 ' & _
'SQLCOLLATION="Latin1_General_CI_AS"')
RunWait('sqlcmd -U sa -P password -S .instance -d "MASTER" -i addVBQUser.sql')
RunWait("SQLServer2005_SSMSEE.msi /q")
Exit