Archive for February, 2012

SQL installer now includes required server permissions

Tuesday, February 28th, 2012

Following up on our last post, we have revised the SQL Installer so that it now sets the proper server permissions for each GIST database table. If you did not manually correct the settings yourself, you can simply download the installer and reinstall the tables. This will correct the SQL permissions errors experienced when loading the Database Manager addon.

SQL user permissions required for GIST tables

Thursday, February 23rd, 2012

We have recently added important information to the Acquisitions Manager Installation Guide. After installing the GIST tables to your SQL server, you need to also grant Select, Insert, Update, and Delete privileges to the ‘illiad’ SQL user on each new table. You can do this individually or by using the following query in SQL Server Management Studio:

Use ILLData




GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[GISTFunds] TO [illiad]


GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[GISTHistory] TO [illiad]


GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[GISTFundLink] TO [illiad]


GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[GISTInvoice] TO [illiad]


GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[GISTVendor] TO [illiad]


GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[GISTConspectus] TO [illiad]


We hope to release a new SQL script soon that will automatically assign these privileges for new Acquisitions Manager users. If you have already installed these tables, please follow the directions above.

Also note that we listed minimum system requirements for using the Acquisitions Manager and GIST for ILLiad Webpages. As explained in the ILLiad 8.1 release notes, prior versions of ILLiad will be unable to access third-party tables. This includes the GIST tables needed for the Acquisitions Manager. Please update your server and clients to the latest versions of ILLiad before implementing the Acquisitions Manager or GIST for ILLiad Webpages. This will also ensure that the ILLiad client is able to properly handle the GIST ILLiad Addons.

Slight modification to new GenericRequestGIST page

Saturday, February 18th, 2012

Hi everyone,

A minor code typo was discovered in the GenericRequestGIST page that was released on January 31. If you have not yet installed the new webpages, simply download the GIST for ILLiad Webpages full installer to get the corrected page. Otherwise, please download the upgrade installer (this will preserve your GIST.config file).

Sorry for the inconvenience.