Software deployment via GPO error: Event ID 107 query syntax invalid or unsupported.
Posted on 2010-11-08
I am busy deploying a Helpdesk monitoring software package to 50 dif client sites. Each client has its own Domain & DC etc, utilising MS SBS 2003/2008 or MS Server 2003 or Server 2008.
I've created the deployment in the following manner.
Created the MSI using builtin network creation package with the software.
Created network share & assigned both share permissions & NTFS permissions to "All computers Security group I created with all machines in it" Everyone & authenticated users.with full controll assigned to all.
Created a separate deployment OU in AD & moved the workstations & laptops to it.
Created a GPO for the new OU using GPO snapin
Used UNC path & created the assigned software package
Assigned the permissions in the GPO delegates to the sec group created.
Now the big one. As soon as the GPO etc is set, Event viewer gives me
Software Installation was unable to read the MSI file \\xxxxx\NetworkInstaller\xxxx.msi. The following error was encountered: SQL query syntax invalid or unsupported. Event ID 107
When setting the GPO using the older version where GPO was set within the GPO tab it appears to be ok. Either way the software appears to be deploying.
Some assistance please guys.