Database

Submitted by Carl on Sun, 5 May 2013 11:05pm

Auction Manager connects to a Microsoft SQL Server database. To get setup, you must first install Microsoft SQL Server 2008 Express or newer. The information below is for version 2008, but the same should also apply to 2012 and 2014.

For help with installing Sql Server 2008, see this guide here or a guide to installing Sql Server 2014.

Sql Server Management Studio Install

You will need the Sql Server Management Studio installed, so follow this guide here.

Sql Server Setup

After SQL Server is installed, there are a few things to configure first. Firstly we need to set the port that Sql Server will listen on by following the steps below:

Step 1. Open the SQL Server Configuration Manager (Click Start > All Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager)

Step 2. Go to SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for

Step 3. Double Click on TCP/IP.

Step 4. In TCP/IP Properties dialog box, go to IP Addresses tab and scroll down to IPAll group.

Step 5. Enter a port number (typically 1433) in the TCP Port field and click OK.

Step 6. Go to SQL Server Configuration Manager > SQL Server Services, right click on Sql Server (SQLEXPRESS) and select Restart.

Create User Account

Windows authentication can often cause problems, so it is best to create a login for the Sql Server. Follow these steps to create an account:

Step 1. Open Sql Server Management Studio and connect to the Server.

Step 2. Expand the Security Tab, right click on Logins and select 'New Login...'.

Step 3. Choose a login name and password using Sql Server Authentication.

Step 4. On the Server Roles tab, tick sysadmin. Click Ok to create the login.

Tip: You can create a different login for each instance of Auction Manager for better security.

You can now finally run Auction Manager. Read the Getting Started section for setting up Auction Manager and connecting to the SQL Server.

Other Information

If you are running Windows XP and the installation Setup Support Rules is failing on Windows PowerShell, then this needs to be installed. See this page here for some details on this. The download links are about half way down.