Can't connect to SQL Server during repository creation

asked on April 7, 2015

Using Admin 9.0 to create a second repository on the server, getting the error:

Could not log in to Microsoft SQL Server. Please ensure that SQL Native Client 2005 is installed and database credentials are correct.

I'm using SQL server authentication and the credentials are correct, because I can log in via SQL Management Studio just fine. Native Client 5.0 is also installed. The SQL database is on another server.

I see in other threads that having multiple native clients can cause problems, and on the LF server I notice that Microsoft SQL Server Native Client 11.0 is also installed. Is this a potential source of the conflict? I don't know why or how it is installed, or how to tell if it is used. Is it possibly used by something else in Laserfiche?

0 0

replied on April 7, 2015

It's SQL 2012 R2, and yes it's set for mixed mode.

0 0

View 6 previous replies

replied on April 7, 2015

If the Laserfiche Server is the only application on that computer that needs to connect to SQL, then it should be safe to uninstall all other versions of the SQL Native Client and just keep the 2005 version.

There may be a chance that you need to uninstall all instances of the SQL Native Client and then reinstall the one that ships with the Laserfiche installation package.

Please see if you are able to create the repository then. If there's still an issue, it may be best to contact your Laserfiche reseller and open a case.

0 0

replied on April 7, 2015

Barry I ran into the same thing and if you have mixed mode on normally like Alex said uninstalling the other clients and installed the one that came with LF will do the trick.

0 0

replied on April 7, 2015

Note that starting in Laserfiche 9.2, we've switched to using the SQL 2008 R2 Native Client for the repository creation/registration wizard. Also, it should no longer fail when other versions of the SQL Native Client are also installed.

0 0

replied on April 7, 2015

Thanks for the pointers!

I don't see anything about an option to install just the SQL drivers in the Rio install setup wizard on the server. Do I have to re-run the whole Laserfiche server installation to get the native client re-installed? Or can I just download the same version?

0 0

replied on April 7, 2015

In your LF installer folder go to the folder labeled EN. Then open the folder called Support. It is called sqlncli_x64.msi for 64bit systems.

0 0

replied on April 7, 2015

You'll need to browse the installation files and manually install the .msi. If you look in the en\Support folder, you'll see sqlncli.msi and sqlncli_x64.msi. Install the valid version based on the architecture you're using (32 or 64 bit).

0 0

replied on April 8, 2015

Any update Barry? How did you make out?

John

0 0

replied on April 8, 2015

Thanks, everyone for all the info.

Just to add all the details to this, I found a way around the error. I just entered the SQL authentication details and the name of the new database normally -- then, without hitting Enter or Tabbing out of the 'database name' field (which triggers the error message) I clicked the 'Next' button to continue and it goes through the rest of the screens and at the end creates the repository with no errors raised. However, if you use the Admin UI to delete the repository you just created, (because you accidentally misnamed it like I did) it deletes it from Laserfiche, but the database itself is not deleted and has to be deleted manually before you try again.

0 0

replied on April 8, 2015

Yep that is correct Barry. The LF admin console will not tell SQL to delete the DB. You will need to go into SQL to do that. Sounds like you got it working. That is great to hear.

0 0

Question

Question

Can't connect to SQL Server during repository creation

Replies

Sign in to reply to this post.