Installing I/NET Seven on a 64-bit operating system

[Product_Support]

Issue

Initialization errors when starting I/NET Seven 2.42 or higher

Error: "You must install an instance of SQL 2008R2 (64bit) before completing the INET install"

Product Line

TAC INET

Environment

• I/NET Seven 2.42

• Windows Server 2008 64-bit

• Windows 7 64-bit

• SQL 2008 64-bit

• Windows 8

Cause

I/NET 64-bit requires specific installation process in order to function on a 64-bit PC

Resolution

Installing SQL

1. Download SQL2008 R2 Express 64 bit (SQLEXPR_x64_ENU.exe) from this location: http://www.microsoft.com/en-us/download/details.aspx?id=30438
2. Run SQLEXPR_x64_ENU.exe
   
3. In the left hand section, select Installation
4. In the Right and section, select New SQL Server stand-alone installation of add features to an existing installation.
   
5. At the "Setup Support Rules" screen select OK
   
6. At the "Product Key" screen, select Next
   
7. At the "License Terms" screen, check accept and select "Next"
   
8. At the "Setup Support Files" screen, select Install
   
9. At the "Setup Support Rules" screen, select Next
   
10. At the "Feature Selection" screen select: Database Engine Services, SQL Server Replication, Management Tools - Basic (If Present) and SQL Client Connectivity SDK. Leave the Shared feature directory as default.
    
11. At the "Instance Configuration" screen, select the Default instance option, accept the default Instance ID, accept the Instance root directory default settings and select next.
    
12. At the "Disk Space Requirements" screen, select Next
    
13. At the "Server Configuration" screen, under SQL Server Database Engine set the Account name to NT AUTHORITY/SYSTEM, leave the password field blanks, and set the startup type to automatic. Under SQL Server Browser Service, set the Startup Type to Automatic
    
14. At the Database Engine Configuration screen, set the Authentication Mode to "Mixed Mode", Define a strong password (example: @sql2008), in the Specify SQL Server administrators section click "Add Current User". Select Next.
    
15. At the "Error and Usage Reporting" screen, select Next
    
16. At the "Installation Rules" screen, select Next
    
17. At the "Ready to Install" screen, select Install
    
18. At the Installation Progress screen, when the setup process is complete, select Next
    
19. At the "Complete" screen, select Close.
    

SQL Configuration:

1. In the Windows Start Menu, launch the SQL Server Configuration Manager
2. In the Left hand section of the window, highlight SQL Server Services
3. Verify that SQL Server Browser and SQL Server are Running
   
4. In the left hand section of the window, expand SQL Server Network Configuration and highlight Protocols for MSSQLSERVER
5. Enable Named pipes and TCP/IP
   
6. Close the SQL Server Configuration Manager
7. Restart the PC

Installing SQL Server 2005 Backward Compatibility

1. On the I/NET 2.42 or higher installation CD, look in Support\SQLBCM_64Bit and launch the SQLServer2005_BC_x64.msi file
   
2. Follow all the prompts on each screen and accept all defaults.

Install I/NET Seven 2.42 or higher

1. Install I/NET Seven 2.42 or higher using the installation CD
2. Follow prompts and use defaults
3. When prompted for the SQL password, select "Windows Authentication"
4. Restart the PC
5. Open I/NET Configuration through the start menu.
6. Modify the default Config profile or create a new profile.
7. Close I/NET Configuration
8. Start I/NET

NOTE:

If error occurs during SQL installation stating invoke or begin invoke failed, follow instructions at this link: http://support.microsoft.com/kb/975055

UPDATE: SQL2008 SP1 prevents the invoke failed error. It can be installed with the same instructions as above. Download it at this link: http://www.microsoft.com/en-us/download/details.aspx?id=25052