Search the Knowledgebase Browse by Category

[Advanced Search]
SQL Authentication
Would you like to...
Print this pagePrint this page
Email this pageEmail this page
Post a commentPost a comment
Subscribe me
Add to favoritesAdd to favorites
User Opinions
100% thumbs up 0% thumbs down (12 votes)
How would you rate this answer?
Helpful
Not helpful
To use SQL Authentication instead of the built-in NT Authentication follow the steps below:
  1. Create an SQL User
    1. Launch the Database Utility Program (located on the database server. If you are using Windows 7, Windows Vista, or Windows 2008 Server, 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 ('gendata' or 'eshadata')
    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"
  2. Create a "UDL" file on the Client machine
    1. 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)
    2. Open the "esha.udl" file and go to the "Provider" tab
    3. Select "Microsoft OLE Provider for SQL Server"
    4. Press "Next" (Connection tab)
    5. Choose your server from the list (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 ('eshadata' or 'gendata')
    9. Press "Test Connection" to test the database connectivity
    10. If the test is successful, press "Ok"
  3. 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
  4. That should be all
If you have any questions, regarding this procedure, let us know.
Attachments
No attachments were found.
Related Questions
No related questions were found.

Powered by ActiveKB Knowledgebase Software