Home » blog » ericf@far.org's blog

iMIS 15.03 - sa password change

Posted July 23rd, 2008 by ericf@far.org

We have changed our SQL Server sa password in our iMIS 15.0.3 database. User logins to the back office and web\public view components no longer worked. Found and changed the sa password embedded in the IIS Virtual Driectories \iMIS15 and \iMISPublic in the .NET configuration. Also changed in the ODBC connections to test out the connection, though appears that it would be the user's invidual credentials that would be used to authenticate through ODBC . The web\public views logins now work. The back office login still does not, still invalid sa password error. Is there somewhere else that the sa password is embedded that needs to be changed?

Thanks,
Eric

ericf@far.org's blog | login or register to post comments | printer friendly version

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

try rebuilding the SQL logins used by desktop

On July 25th, 2008 Henry Huey says:

Use the dbrepair utility and choose the Prepare Database button. You can also run the CreateSqlLogins.sql script, found under the IMIS153DBUpgrade subfolder.

login or register to post comments

Thanks for the information.

On July 25th, 2008 ericf@far.org says:

Thanks for the information. Am attaching the response from ASI Tech Support on all of the places that need to be changed after an sa password change. Kind of scary that in at least one of the files: Asi.Workflow.Services.exe.config the password is stored in clear text.

ASI Response:
For iMIS15, if you change the SA password after it is installed, then you will need to also change it in the following files:

Web.config located in C:\Program Files\ASI\iMIS15\Net\
Web.config located in C:\Program Files\ASI\iMIS15\iMIS_Public
Asi.Workflow.Services.exe.config located in C:\Program Files\ASI\iMIS15\Net\bin

If you have Content Manager:
PublishService.exe.config located in C:\Program Files\ASI\iMIS15\PublishingService.

If you have eSeries and/or Content Manager:
eSeries ODBC DSN
ColdFusion Data Source
eSeries Wizard – rerun using new SA password if you used the SA the first time you ran the wizard.
eCM Wizard - rerun using new SA password if you used the SA the first time you ran the wizard.

After making the above changes, you will need to restart the IIS services, the workflow service and the publishing service (if applicable).

After that, run the DBRepair Tool on your iMIS Application server, login as sa with your new sa password, connect to your iMIS database and then run “Prepare iMIS Database”. Then test the login to the iMIS Desktop.

login or register to post comments