Question

Changing password on LF SQL database

Updated September 17, 2014

asked on September 17, 2014

I have a customer that failed an audit on passwords in particularly the password on the Laserfiche SQL database. In order to change the password we would have to unregister the Laserfiche repository change the password and then register the repository is that correct? Or are there other steps that need to be taken?

0 0

Answer

APPROVED ANSWER

replied on September 17, 2014

Please review this page regarding changing the DBMS connection. You can update the authentication information to the database management system without having to unregister and re-register the repository.

1 0

replied on September 17, 2014 • Show version history

Oh yeah, I forgot about that method. I almost always end up having to re-attach the repository too in most cases where I'm working with a client (i.e. they have new hardware across the board so we are moving multiple items)

You can also use this to change from sql local authentication to windows authentication and then use my previously posted technique to change the password in the future by stopping the repository and changing it in services.msc while it's stopped then starting it again.

Technically Alexander's response is the one that should be marked as answered!

0 0

Replies

replied on September 17, 2014

As far as I know you would need to unregister/register the repository but that only takes a very small amount of time.

For greater security, I'd actually suggest changing Laserfiche to run under a windows service account and then grant that account access to the SQL server. If you do this you can change the password on the Laserfiche server whenever you need to by stopping the laserfiche service, changing the password, changing the password in services.msc and restarting Laserfiche.

It's always a debate but the majority of the articles I've seen suggest using windows credentials to connect to SQL server is more secure than using local sql server accounts.

0 0

You are not allowed to follow up in this post.

Question

Question

Changing password on LF SQL database

Answer

Replies

Sign in to reply to this post.