Knowledge Base Article



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:

        

   http://secured.progoldi2.com

 

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
  News
  Help
  Contact Us
Opportunities
  Careers
  Advertising
  FAQ
Login
  Login to My Account
  Create Account
Products
  ViewMyListing 9ae
  Pro Gold i2
  MyListingBlog
  Latest News


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