Working with SQL Server Security Settings

This memo describes how to use SQL Server authentication in order to resolve access issues to the SQL Server.

Note that this method is not particularly secure within your local network, but it does not interface outside your local network.

The procedures described herein require the Microsoft SQL Server Management Studio (SSMS). The express version is available free of charge from Microsoft's website. Choose the version that's compatible with your SQL Server Express installation and your Windows operating system.

Once you have SSMS installed, open it and establish a connection:

Connection

You should be able to connect to the instance that was installed earlier. A default would look like:

Connect 2

Click on Connect.

If HORTICOPIA Professional was previously run, the database should already be attached. Expand the Databases to see if HortProData is attached If not, see if it can be attached:

Attach 1

Right-click on Databases and select Attach...

Attach 2

In the Attach window, click on Add...

Attach 3

Locate the Horticopia Data folder and then the Data folder. If HortData.mdf is not displayed and you've checked that it exists, you need to change the security settings for the Horticopia Data folder to allow the SQL Server to access it.

Select HortData.mdf and then click on OK

Attach 4

Click on Add... and then on OK.

At this point, you may detach the database. Under databases, right-click on HortProData and select Detach...

Next, expand Security and then right-click on Logins

Login 1

Select New Login...

New User

Enter a Login name. In our example, we'll use HortProUser.

Select SQL Server Authentication

Enter a password. In our example, we'll use Gobbledegook

Uncheck Enforce password expiration

More user

After clicking OK, click on Securables and check sysadmin

Click on OK

Right-Click on the SQL Server name in the Object Explorer (WINENT7\SQLEXPRESS in this example) and select Properties in the pop-up window.

Server Properties

In the Properties window, click on Security

Mixed Authentication

In the Security window, select SQL Server and Windows Authentication

Click on OK

From the File menu, select Disconnect Object Explorer...

You'll need to restart the SQL Service for the changes to tak effect. Restarting is as described at the end of Initial SQL Server Configuration

Now, open the Horticopia Control Panel (Start, All Programs, Horticopia Pro V, Horticopia Control Panel).

Ctl Panel

Click on the Setup tab and then Open the HORTICOPIA Data Folder in Windows Explorer

Data folder open

Double-click on the Horticopia (Horticopia.ini) file

INI file

Locate the [SQL] section and make the following modifications:

Finished ini

Save the Horticopia.ini file

At this point, you can close SSMS, Horticopia Control Panel, etc. Make sure HORTICOPIA Professional runs on the server before trying to execute on the client workstations.