Real Estate Software - ProGold i2 web site: www.progoldi2.com
Real Estate Search Engine - ViewMyListing.com web site: www.viewmylisting.com
Search Local Classifieds – www.viewmylisting.com/buy-sale-trade
Agent Tools web site: real estate agent software
Article ID: 4282
Subject: Manually Install SQL Express 2005
Last Modified: November 30, 2013
Applies to: ProGold i2 3.xx
Purpose: Provide instructions for manually installing SQL Express 2005. This action is typically required when a client is using Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) and needs to upgrade to SQL Express 2005.
Procedure: Actions required to install SQL Express 2005:
• Step 1: Go to progoldinstall folder:
- Open My Computer icon
- Select the drive (pick drive letter where Pro Gold i2 was installed)
- Select the Pro Gold i2 folder
- Select ProGoldInstall folder
• Step 2: Begin the installation:
- Select the setup.exe file
- Accept the license agreement
- Click the Next button (Installs the SQL 2005 Setup Support files)
- Click the Next button (Initiates the Microsoft SQL Server Installation Wizard))
- Click the Next button (Initiates the installation)
- Click the Next button (Confirms the System Configuration Check and stats the installation)
- Enter Registration information (Your name and company information)
• Note: Uncheck Hide Advanced Configuration options; click the Next button
• Step 3: Install Features:
- Install all features at the Feature Selection screen
- Verify/choose disk drive
- Click the Next button to continue
- Accept the default named instance: SQLExpress
- Click the Next button to continue
- At Service Account screen, click the Next button (Accept the default settings)
• Step 3: Set Authentication Mode:
- At Authentication Mode screen,
• Select the Mixed Mode option
• Enter è ProGold2002E in password and confirm password fields (password is case sensitive)
• Click the Next button
- At Collation screen, click the Next button (Accept default settings)
• Step 4: Set Configuration Options:
- At Configuration Options screen,
• Verify Enable User Instances box is checked (if not, check it)
• Check the Add User to the SQL Server Administrator Role box, click the Next button
- At Error and Usage Reporting screen, click the Next button to continue
- At Ready to Install screen, click the Install button to begin the installation
- At Setup Programs screen, click the Next button to continue
• Step 5: Activate Remote Client Connections:
- At Completing Microsoft SQL Server 2005 Setup screen, select the Surface Configuration Tool option
• At SQL Server 2005 Surface Area Configuration screen
• Select the SQLEXPRESS component option
• Select the Service option
• Click the Stop button to temporarily stop the service
• Select the Remote Connections option
• Select the Local and Remote Connections option
• Select Using both TCP/IP and named pipe options
• Select the Service option
• Click the Start button to restart the service
• Click the OK button to close the SQL Server 2005 Surface Area Configuration screen
• Click the Finish button the Completing Microsoft SQL Server 2005 Setup screen to complete the installation
Additional Information: Below is a link you can use to access Enhancement HelpNet Center resources, which includes the Knowledge Base Article (KBA) Library, Pro Gold i2 Documentation, and Training Webcasts:
The Enhancement HelpNet links are located on the right side of the web page.
Keywords: Install, MSDE 2000, SQL Express 2005, 4282