available databases wont show up when creating a repository. LF 902, SQL 2012

asked on December 10, 2014

I am in the process of moving a clients data from a Windows 7 "server" over to their new Server 2008 R2 machine with a separate server running SQL Server 2012.

When creating a new repository(for testing purposes) I am having issues with the "SQL Server Specific Settings". I was getting an error saying, "Could not log in to Microsoft SQL Server. Please ensure that SQL Native Client 2005 is installed and that the database credentials are correct." This issue was related to the credentials and permissions with the database. We were able to resolve that message.

The problem I have now is that when you click the "v" to populate the available databases it is just blank. I can click refresh as many times as I want and it still shows nothing. If I type in a database name to create one and get to the end to finish creating the repository I get a different error. "The Laserfiche server encountered an error when trying to create or attach the repository: 9025 - Error reading the repository information, or repository misconfigured."

0 0

replied on December 10, 2014 • Show version history

What account is the LF server service using? If you are using local system, change it to an account with rights to SQL.

You should also make sure that the SQL native client is installed and that the server is properly licensed.

I am also unsure what you mean by "available repositories won't show up". If you are creating a new repository, then there won't be any. You should let the repository creation wizard create the db for you too. If you are attaching an existing repository, you would not do that from the creation wizard.

0 0

View 1 previous reply

replied on December 10, 2014

Raymond-

I have confirmed that the SQL Native Client is installed, which I reran the install file from within the LF 902 support folder. The server is properly licensed at the moment as well. The account running the LF Server service is the same account that I am currently logged into the server as. That same account is the db_owner of the database I am trying to get to show up within the list, but still nothing.

Thanks,
Chad

0 0

replied on December 10, 2014 • Show version history

Is the SQL instance local to the machine or on another machine?

If you use SQL server management studio, can you connect to the SQL instance?

Can you create a blank db using SQL server management studio when you connect?

0 0

replied on December 10, 2014

The SQL instance is on a separate dedicated SQL server. The security it pretty tight with this client and since the SQL server is a production server I do not have direct access to it. Let me talk with the DBA to see if we can do some testing with this.

0 0

replied on December 10, 2014

Chad, make sure the account logged onto the LF Server service has the sysadmin Server role in SQL.

3 0

Question

Question

available databases wont show up when creating a repository. LF 902, SQL 2012

Replies

Sign in to reply to this post.