|
Question:
How do I create or reset the 'etuser' account in the SQL Server?
Answer:
ExpressMaintenance and ExpressRequest use a special etuser account to
actually make the connection to the Microsoft SQL Server / MSDE.
Usually, the account is setup automatically for you. However, in
certain instances where the user has their own version of Microsoft SQL
Server or where the 'sa' password is initially unknown by the
application, it may be necessarily to manually create the account.
You can
easily create or reset the 'etuser' account in the SQL server using our
ExpressUtility. Please follow the steps below to accomplish this.
-
Download
the ExpressUtility install program (EUInstall.exe) saving it to the
ExpressTech folder on the server computer.
Download Link - click
here.
-
Run the
ExpressUtility install program (EUInstall.exe) to install the
application.
-
Run the
ExpressUtility application
-
In
ExpressUtility, you must first establish a connection to the SQL
Server
-
Click on
the menu option File / Register New Server
-
Enter the
name or IP address of the server
-
Enter the
login account of 'sa'
-
Enter the
'sa' password that was used at installation
-
Click the
Save button
-
Click on
the Server listed in the upper left panel
-
Select
the database by clicking on ExpressMaintenance in the lower left
panel
-
Click on
the Explore Data tab
-
In the
Explore Data tab, click on the SQL Users tab
-
Click on
the 'Reset etuser SQL Account' button which is a yellow diamond with
an explanation mark in the middle
-
This will
drop and recreate the 'etuser' login account in SQL
-
Close
ExpressUtility after the confirmation message appears
This will
allow the applications to use the 'etuser' account to make the SQL
connections. If you have questions about the password for 'etuser',
please email our support department. |
