Specifing a $ (dollar) in an ADS task sequence
Today I scripted a SQL Install Task Sequence for Automated Deployment Services (ADS) for a non-default instance. Part of the sequence does a DIR on the SQLSERVER.EXE item in the SQL Server folder which in any instance other the the default is in the \MSSQL$INSTANCE folder.
I created the sequence and went to test it so I tried to run it and the ADS Management console came back with the following error:
Code: 80040861
Description: Failed to validate the command syntax in the task sequence XML document.
Because ADS uses $ (dollar) signs to mark a device variables, putting a single $ in somewhere in the sequence forced it to break.
To work around this issue, you need to escape the single $ sign with $$ (dollar dollar).
With this change I was able to finish my Task Sequence to install SQL Server and SP4 and now have a daily build test environment being build and completly configured that consists of 4 IIS applciation servers (2 load balanced pairs) and a SQL Server 2000 servers.
The whole environment, including all custom applications to be installed takes about an hour to build on a Virtual Server.
![]()
No Comments »
Filed under: Automated Deployment Services (ADS)