The following is required to install and work with the MS SQL Server agent.
  • A full (thick) installation of AIS. This should include Attunity Studio and the Attunity Server. Make sure that you have a valid licence for all Attunity products.
  • Microsoft SQL Server 2000 (Standard, Enterprise, or SBS editions).
  • You must have an account with administrator rights to run the MS SQL Server and MS SQL Server agent services.
  • The agent and CDC agent service setup are executed as members of the sysadmin server role.
  • Back up the Transaction Log.

The Microsoft SQL Server agent works on Windows platforms only. It works according to standard Windows requirements.