Question

Unable to create a new repository

Administration

Updated August 11, 2014

asked on August 11, 2014

I am trying to create a new repository where LF Server is installed on one server and SQL Server is installed on another server.

Troubleshooting steps performed so far are as follows:

Confirmed that correct instance name for SQL server is used in repository creation wizard
Checked the rights for windows account (Windows user have administrator rights in SQL server)
I am also able to share files between two servers

On checking the event viewer, I am getting the following lfs error:

"There was an error attempting to execute SQL when creating or attaching a repository: [Microsoft][SQL Native Client][SQL Server]Login failed for user '[domain]\[username]'.; SQL State: 28000; Native error code: 18456; Database server: [servername]; Database/Schema: x."

1 0

Answer

SELECTED ANSWER

replied on August 11, 2014

Can you confirm that the domain account you specified as the Laserfiche Server service account can be used to connect to the SQL instance through SQL Server Management Studio and Windows Authentication?

Also, can you try creating the repository again, but when specifying how to connect to SQL, try using a SQL account instead of Windows Authentication. Is there still an error in that scenario?

If the issue is only when trying to use Windows Authentication, but you're certain the Laserfiche Server service account is a domain account that has necessary rights to SQL, then please contact Laserfiche Support to open a case.

0 0

Replies

replied on August 11, 2014

Alex,

I changed the Lon On User of the Laserfiche Server Service Account to the domain account that has admin rights on the SQL Server and it allowed me to create the repository.

Thanks!

0 0

You are not allowed to follow up in this post.

Question

Question

Unable to create a new repository

Answer

Replies

Sign in to reply to this post.