while installing the LASERFICHE SA account is used for db authentication .
now like to replace with other sql server account with same privileges
Hi Mohammed,
As you said, make sure the user account as the same privilege, access right to the db, then go to
Laserfiche Administration Console -> Right Click Repository -> All Tasks -> Change DBMS connection.
Thanks.
thanks a lot Mahesh once done i will mark answer
Dear Mahesh,
Many thanks and greetings.
According to your suggestion an equivalent to “SA" account is created with name “LFSQL”.
At Laser fiche admin console when want to change DBMS connection it is giving the below warning message is attached .
Is this normal can i proceed or not.
Because we do not have support now, I am cautions is there any effect on license and application.
waiting for your great help .
Unless you blanked it out on the attached image, you did not provide a SQL server.
Also your DB name looks like it is the DB for LFDS. The instructions to change the DB connection using LF Admin Console is only for the repository and not LFDS.
Dear Bert ,
thanks for the answer it is not clear for me i like change SA account which is presently used with another account .
while changing i am getting the below warning message so i am concerned about this .
because we dont have the support as of know .
There are potentially multiple DBs and connections that you will need to change and the process will depend on the product that you are trying to address.
To change the DB connection for LFDS, you have to do that through the LFDS web site. (See the answer supplied by Chase Hill below).
To change the DB connection for the repository, you use the Admin Console (See the answer provided by Mahesh Ramchurn above).
To change the DB connection for Workflow, use the Workflow configuration utility.
To change the DB connection for Audit Trail, use the Audit Trail Configuration web site.
To change the connection string for Directory Server, go to Settings > General > "Modify connection string". Enter your new connection string using one of these formats:
Data Source=mySqlServerFqdn; Initial Catalog=myDatabaseName; Integrated Security=True
Data Source=mySqlServerFqdn; Initial Catalog=myDatabaseName; User ID=mySqlUsername; Password=mySqlPassword
The new value will not be used until the service is restarted. You can also achieve the same goal by detaching the database and re-attaching it with the new SQL user.
thanks a lot for your information .