• MSSQL 2000 SP4, MSSQL 2005 or higher.
• Windows 2000, XP, 2003 or higher.

Go to http://support.microsoft.com/kb/301202 and follow the steps described there.

Go to:https://www.microsoft.com/en-us/download/details.aspx?id=21995 and download Microsoft Data Access Components (MDAC) 2.8 Software Development Kit.

1. Install the application and then restart the server.
2. Follow the steps in Checking the MDAC version to confirm the version installed.

• If you mainly use Microsoft software and have Domain Controllers established, then select all the defaults from the wizard provided by the SQL Server installation tool.
• This sets your SQL Server to listen for secure connections only. Any user IDs that need to be created must be added as Windows users and mapped to the correct group in SQL Server.
• Please consult Microsoft help for more information.

• If you do not primarily use Microsoft software and do not run domain controllers, then do not accept all the defaults for the SQL Server install.
• During the installation, choose Advanced Options select Mixed Mode authentication to allow both Windows authentication and SQL Server authentication. This is the only change needed. Otherwise, accept the remaining defaults.
• As the SQL database password is saved unencrypted in a file (lmcfg.txt), it is recommended to remove the password saved in this file and then specify that the password is provided on startup by altering this file.

• If you are not running MS SQL on your Aurea List Manager (not recommended), it is mandatory to install the MS SQL Client Tools on the machine that is running Aurea List Manager (and any other machine that is connecting to the SQL Server). Client Tools are auxiliary programs that are necessary to connect to and manage the MS SQL server.
• These tools come in two installation forms: Connectivity Only, or Server and Client Tools. All that is needed is the client tools (connectivity). The Server option also installs the client tools, so either choice is fine.
• If you are running MS SQL Server and Aurea List Manager on the same machine (not recommended), you may skip this step, as the required client tools have already been installed as part of the server installation.

After the installation of Microsoft SQL, a database needs to be created for Aurea List Manager to use. Follow the steps below to create the database:

1. Open Enterprise Manager, a tool included with your SQL Server installation.
2. Register the preferred SQL server to use with Enterprise Manager. If the SQL Server is on the same machine which, is running Enterprise Manager, you can register the name of the server as “(local),” or just leave the entry blank. Otherwise, enter the name of the remote server.
3. Choose the entry for Connection that matches your configuration described above. If you mainly use Microsoft software, then leave the selection on Use Windows Authentication. If not, choose Use SQL Server Authentication and supply the user name and password to connect. If you have just installed the server for the first time, you can use the login SA with a blank password, all the other options on that dialog box can be left as defaulted.
4. Once you have defined a connection to your server, expand the tree for that selection by clicking on the + sign next to the server.
5. Right-click the databases folder and select the option to create a new database.
6. Give the database an appropriate name for use. If you are uncertain, you can name it Aurea List Manager. The database name cannot have spaces or hyphens. All other choices in this dialog box may be left with the default value; however, we recommend setting the database autogrow size to 1 Gigabyte.
7. At this point you have the SQL Server installed with an empty database ready for Aurea List Manager to run with.