When installing HighGear with Microsoft SQL Server, certain caveats apply:
- HighGear can only run on SQL Server 2005 or later
- HighGear can only connect to SQL Server using “mixed mode” authentication
- Windows Authentication mode is not supported
When you install HighGear and connect it to a SQL Server, that server must use Mixed Mode authentication. SQL Server can run in two authentication modes. The first, Windows Authentication mode, requires services and or applications to run as a specific windows user to gain access to database resources. This is not practical in a large scale environment such as is often supported by HighGear. The second mode, mixed mode, allows SQL server to maintain an independent user account base. HighGear, like most web based applications, requires mixed mode authentication so that HighGear can control the access to the database resources regardless of windows accounts or licenses.