Grouper Developers Forum

["Hafer, Christopher G" <>]

Chris, to yours or anyone else's knowledge, has Grouper been tested with an 
installation using MS SQL 2016? 

Thank you,
Christopher G. Hafer 
MUSC Information Solutions
System Analyst II | Administrative & Financial Applications
Medical University of South Carolina

 | Ph: 843-209-3315

"Harnessing the power of information to improve the lives we touch"


-----Original Message-----
From: Hyzer, Chris 
[mailto:]
 
Sent: Wednesday, July 19, 2017 4:55 PM
To: Hafer, Christopher G 
<>
Cc: Imholz, John J. 
<>
Subject: RE: [grouper-dev] Grouper 2.3.0 with MS-SQL 2016



It does work (maybe not with AD authn) but people have better experiences 
with other databases...

-----Original Message-----
From: Hafer, Christopher G 
[mailto:]
Sent: Wednesday, July 19, 2017 4:30 PM
To: Hyzer, Chris 
<>
Cc: Imholz, John J. 
<>
Subject: Re: [grouper-dev] Grouper 2.3.0 with MS-SQL 2016

Hi Chris, There is a MS SQL Connection string for MS SQL and the Grouper web 
site states the same.  Why would these be included if MS SQL doesn't work?

Thank you, Christopher Hafer
Sent from my phone

> On Jul 19, 2017, at 4:25 PM, Hyzer, Chris 
> <>
>  wrote:
>
>
>
> Grouper does work with sql server though we recommend oracle, mysql, or 
> postgres...
>
> I don't know about DB with AD account...
>
> Thanks
> Chris
>
> -----Original Message-----
> From: 
> 
>  
> [mailto:]
>  On Behalf Of [Christopher] 
> [Hafer]
> Sent: Monday, July 17, 2017 4:48 PM
> To: 
> 
> Subject: [grouper-dev] Grouper 2.3.0 with MS-SQL 2016
>
> We are trying to install Grouper 2.3.0, using the installer, with 
> MS-SQL 2016 database. The user login is an Active Directory account, 
> not a local database account. The server is Ubuntu 16.04 LTS.
>
> The database connection string is similar to below:
> jdbc:jtds:sqlserver://grouperxx.domain.edu:1433;databaseName=grouper_x
> x;useNTL
> Mv2=true;domain=domainName
>
> Grouper installer can't connect to the database (we have tried several 
> different ways) but we can connect using sqlline (SQL commandline) on 
> the same server grouper is being installed on using the same connection 
> string.
>
> Has anyone been successful with installing Grouper 2.3.0 using an 
> MS-SQL database with an Active Directory user account?
>
> Thank you for any help with this,
> Christopher Hafer









-------------------------------------------------------------------------
This message was secured via TLS by MUSC.