Use SQL Authentication instead of NT (Windows) Authentication

This assumes familiarity with SQL Server Management Studio (SSMS), and the proper permissions to make these changes.

1. Enable Mixed Mode Authentication
2. Create an SQL User
3. Create a "UDL" file on the Client machine
4. Make changes to the ini file

Ensure that Mixed Mode authentication is enabled using SQL Server Management Studio

1. In SSMS Object Explorer, right-click the server, and then click Properties.
2. On the Security page, under Server authentication, select the new server authentication mode, and then click OK.
3. In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.
4. In Object Explorer, right-click your server, and then click Restart.  Note: this will disrupt any users currently connected to this database.

Create an SQL User

1. Launch the Database Utility Program (located on the database server).  For older versions of Windows, right-click the shortcut and choose Run As Administrator.
2. Connect to the proper SQL Server hosting your ESHA Database.
3. From the drop-down on the toolbar, verify the correct database is selected (typically 'eshadata' for Food Processor).
4. Click on Users > Manage.
5. Click the New button.
6. For Authentication, select SQL Authentication
7. Type in a User Name and Password (repeated for verification).
8. Click "Create"

NOTE: If using SQL Server Management Studio to create the SQL user, it is recommended to deselect 'User must change password at next login'.  Also, this Login must be made a member of the ESHA Database role 'FPRole', found under User Mapping.

Create a "UDL" file on the Client machine

• On the client machine, create a new file called "esha.udl" in the "c:\program files\esha research\{program}sql" folder.  Make sure that file extensions aren't hidden or else this will look like a text file.

1. Open the "esha.udl" file.  It should open as a Properties -type dialog.
   
2. Click the "Provider" tab. 
3. Select "Microsoft OLE Provider for SQL Server".
4. Press "Next" (Connection tab).
5. Choose your server from the list, or type it in. Generally this is "servername\esha".
6. Choose to "Use a specific user name and password".
7. Type in the user name and password created above.
8. From the database list, select the database you wish to connect to (typically 'eshadata' for Food Processor).
9. Press "Test Connection" to test the database connectivity.
10. If the test is successful, press "Ok".

Make changes to the ini file

1. Open the program's ini file, located in "c:\program files\esha research\{program}sql".
2. Change "UsesUDLFileConnection=0" to "UsesUDLFileConnection=1".
3. Change "UDLFilePathString=" to "UDLFilePathString=c:\program files\esha research\{program}sql\esha.udl".
4. Save the changes to the ini file and exit.