Issue
Running SQL 2008 on a Windows 7 OS
Product Line
TAC INET
Environment
- I/NET version 2.41
- SQL 2008
- Windows 7
Cause
SQL 2008 and I/NET version 2.41 on a Windows 7 PC.
Resolution
Note: Do not install Microsoft SQL Server 2008 Express Edition on the filemaster of an equalized TAC I/NET Seven system. This database engine does not provide the replication services that are required on the filemaster.
Microsoft SQL Server 2008 Express Edition is a scaled down, free edition of Microsoft SQL Server 2008, which includes the core database engine. While there are no limitations on the number of databases or users supported, it is limited to using one processor, 1 GB memory and 10 GB database files. Microsoft SQL Server 2008 Express is included on the TAC I/NET Seven installation disk in the SQLExpress folder (installation instructions are in the SQL2008 Expr Install Inst.pdf file included in the folder).
Microsoft SQL Server 2008 Express Edition does not provide the replication services that are required on the filemaster. To use Microsoft SQL 2008 as the SQL engine for an equalized TAC I/NET Seven system, install Microsoft SQL Server 2008 Standard Edition on the filemaster. You can then use Microsoft SQL Server 2008 Express Edition on each equalized client.
I/NET Seven supports the use of Microsoft SQL Server 2008 Express 32-bit Edition running on Windows 7 Professional 32-bit. The PC should have at least 2 gigabytes of RAM.
| Microsoft SQL Server 2008 32-bit (see notes 1, 2, 3, and 5 | ||||
|---|---|---|---|---|
| Freely Distributed with I/NET | Maximum Database Size | Maximum Concurrent Users | Operating Systems Supported | |
| SQL Server 2008 Express (32-bit) (See note 4) | Yes | 10 GB | Unlimited | Windows 7 Professional 32-bit |
| SQL Server 2008 Standard (32-bit) | No | Unlimited | Unlimited | Windows 7 Professional 32-bit |
- Do not mix versions of SQL server among equalized or client/server workstations in your TAC I/NET Seven system. Ensure that the edition of SQL server installed on each workstation used in a client/server or equalized setting are based on the same version of Microsoft SQL, either 2000, 2005, or 2008
- It is strongly recommended that you defragment the PC’s hard drives on a regular basis. Severely fragmented hard drives can cause poor system performance and in some cases can introduce data errors.
- The use of Microsoft SQL Server 2005 Standard or Enterprise edition, or any edition of Microsoft SQL Server 2008 will require that the PC have at least 2 GB of RAM.
- Microsoft SQL Server 2005/2008 Express Edition cannot be used on a TAC I/NET Seven filemaster.
- Only 32-bit versions of SQL Server and Windows 7 Professional are supported.
