Use the SQL Server 2005 Configuration Manager to determine if the SQL Server is running. How?

II. How are you running HORTICOPIA Professional?

You must run HORTICOPIA Professional from the same administrative privileges account you used to install HORTICOPIA Professional.

OR

You can add user accounts to the SQL Server groups to run from a different account

III. Reinitialize database settings

Using the HORTICOPIA Control Panel, reinitialize the database. How?

IV. Check communication with the SQL Server

Using the SQLCMD utility, check to see if communication can be established with the SQL Server 2005 on this computer. How?

V. Adding User Acounts in XP Professional and Server 2003

1. On the Start menu, click on Run...
2. In the text box after "Open:" enter compmgmt.mmc
3. The Computer Management snap-in opens
4. Expand Local Users and Groups
5. Click on Groups

You should see (among others) two groups:

·         SQLServer2005MSFTEUser$ComputerName$HORTPROSQL

·         SQLServer2005MSSQLUser$ComputerName$HORTPROSQL

Open each of these two groups by double-clicking on them and then use the Add button to add the user accounts that will be running HORTICOPIA Professional. Alternatively, you can make sure the Guest account is enabled and simply add Guest to the two SQL Server groups.

Once the user accounts have been added:

1.      Restart the SQL Server (you can use the SQL Server Configuration Manager to do a Restart)

2.      Log off and back into any accounts that were logged on for these changes to take effect. 

3.      It’s simplest to just restart the computer.

VI. The Computer Name was changed

If you first installed HORTICOPIA Professional before version 5.0.121 and you change the computer name, you’ll have to reinitialize the database connection. How?

If you are running the network edition of HORTICOPIA Professional and the Server connects but the clients do not, open the HORTICOPIA Control Panel, and, on the Licensing tab, Configure for network clients.

On the clients, reinitialize the path to the server. From the Start menu, select Programs, Horticopia Pro V, Reset Horticopia path

Site Map