Knowledge Base Article

Real Estate Software - ProGold i2 web site:

Real Estate Search Engine - web site:

Search Local Classifieds –

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.


Related articles: N/A


Keywords:  Install, MSDE 2000, SQL Express 2005, 4282




Search All Knowledgebase Articles (click here)

Company Info
  About Us
  Contact Us
  Login to My Account
  Create Account
  ViewMyListing 9ae
  Pro Gold i2
  Latest News

Home Page | Taro Systems, Inc.  | Terms  | FHEO Fair Housing and Equal Opportunity
© 2014 Taro Systems, Inc.