• Sign In
  1. Messages

SQL Server Windows Authentication

Installation Forum (Inactive)

View Message

view list print
SQL Server Windows Authentication Bob Kinoshita  2019-04-23 11:14
Status: Active
 

Hello,

I have a Labkey Community 19.1.1 installation running successfully with a remote SQL Server 2016 database using SQL Server Authentication.

The database administrators here much prefer the use of Windows Authentication for such databases. Is this possible?

Thank you.
 
 
hannahb responded:  2019-04-24 09:42

Hi Bob,
Thank you for contacting LabKey! As discussed in our email thread, let's move this question to Jim for now. While we often respond to forum posts, responses to technical questions in addition to in-depth developer support are reserved for our Premium Edition partners. We are eager to help you be successful - we invite you to contact us about expert support and premium features. A detailed overview of our Editions can be found here https://www.labkey.com/platform/labkey-server-editions-feature-comparison
Kind regards,
Hannah
 
Jon (LabKey DevOps) responded:  2019-04-26 10:53
Status: Closed
Hi Bob,

Unfortunately we are not able to support Windows Authentication for Microsoft SQL Server and it would require your SQL Server to be in Mixed Mode with a SQL database user to allow LabKey to connect to it. (See https://www.labkey.org/Documentation/wiki-page.view?name=cpasxml#db for more information).

If your SQL Server is already running and isn't in Mixed Mode, we do have some information on how you can change it:

https://www.labkey.org/Documentation/wiki-page.view?name=installMicrosoftSQL#configure

Regards,

Jon