1. From the Start menu, select Programs (or All Programs)
2. Select Microsoft SQL Server 2005, Configuration Tools
3. Select SQL Server Configuration Manager

If you cannot find this entry, then the SQL Server software did not install properly.  Please see Manual Installation of the SQL Server on how to install the SQL Server manually.

When the SQL Server Configuration Manager appears, click on SQL Server 2005 Services on the left.  The right side should show, among other things, SQL Server (HORTPROSQL) with a state of Running.  If the entry, SQL Server (HORTPROSQL) appears but the state is Stopped,

1. Double click on SQL Server (HORTPROSQL)
2. Click on the Service tab and make sure the Start Mode is Automatic
3. Click on the Log On tab and Start the service
4. Close out the SQL Server Configuration Manager

If the state is Running and there’s an SQL Server (HORTPROSQL) entry, there is a different problem. Click on the Back button on your browser and proceed to the next step.

If the state is Stopped or Paused and there’s an SQL Server (HORTPROSQL) entry, right-click on the SQL Server (HORTPROSQL) entry and select Start or Resume.

If SQL Server (HORTPROSQL) does not appear, but other SQL Server entries do appear, you may modify the HORTICOPIA Professional SQL Connection string.  This should be done by someone familiar with the SQL Server installation on the system.

1. The SQL Connection string is in the file Horticopia.ini in the Horticopia Data Folder
• To find the Horticopia Data folder location, open the HORTICOPIA Control Panel (Start menu, Programs, Horticopia Pro V, Horticopia Control Control Panel V).
• In the HORTICOPIA Control Panel, click on Show System Parameters.
• Under Directories and Paths, locate HORTICOPIA Data Path
• Hint: Select the path after HORTICOPIA Data Path copy it and then paste it into the address bar in My Computer
• 
2. In the Horticopia.ini file (you may not see the .ini, but it's a "Configuration Settings" file), the line SQL Connect will contain a parameter of Data Source=xxxxxx\yyyyy; (usually, LOCALHOST\HORTPROSQL). 
3. Modify the data source to conform to your SQL configuration and save the file