Question

Which SQL account is required when installing Laserfiche and having LF auto create the Database?

Laserfiche Version 9 Security Installation and Upgrades

Updated July 21, 2014

asked on July 10, 2014

Can someone confirm what rights the SQL server account needs when creating the database during the Laserfiche install? I know that the SA account will work but can an account be used that is more limited? or does it just need to be the SA account.

If so what will the SQL account need, DBcreate, DBowner?

Thanks

0 0

Answer

SELECTED ANSWER

replied on July 21, 2014 • Show version history

The security section says:

Requires CREATE DATABASE permission in the master database, or requires CREATE ANY DATABASE, or ALTER ANY DATABASE permission.

So all you should need is a user that has one of those specific permissions. Note that ALTER is more permissive than CREATE, as it includes CREATE, ALTER, and DROP.

If you are having trouble creating a SQL user or viewing rights on existing SQL users, then the SQL documentation and SQL forums would be the place to go.

0 0

Replies

replied on July 10, 2014

See the Security section on the SQL Server documentation.

0 0

replied on July 14, 2014

Hi David,

If your question has been answered, please click the "This answered my question" button on the response.

If you still need assistance with this matter, just update this thread. Thanks!

0 0

replied on July 21, 2014

The Security section of the SQL documentation describes all SQL Accounts.

Is there specific ones that are used when LF creates the databases? We would not want ask the customer to use the SA account every time would we?

0 0

SELECTED ANSWER

replied on July 21, 2014 • Show version history

The security section says:

Requires CREATE DATABASE permission in the master database, or requires CREATE ANY DATABASE, or ALTER ANY DATABASE permission.

So all you should need is a user that has one of those specific permissions. Note that ALTER is more permissive than CREATE, as it includes CREATE, ALTER, and DROP.

If you are having trouble creating a SQL user or viewing rights on existing SQL users, then the SQL documentation and SQL forums would be the place to go.

0 0

You are not allowed to follow up in this post.

Question

Question

Which SQL account is required when installing Laserfiche and having LF auto create the Database?

Answer

Replies

Sign in to reply to this post.