[ 
https://issues.apache.org/jira/browse/GUACAMOLE-363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16266205#comment-16266205
 ] 

Michael Jumper commented on GUACAMOLE-363:
------------------------------------------

Also worth noting - I tried spinning up an instance of SQL Server as old as 
still available on AWS RDS (SQL Server 2008), and the following fails due to 
syntax:

{code:sql}
ALTER DATABASE CURRENT SET ANSI_NULLS ON;
GO
{code}

the error being:

{quote}
Msg 156, Level 15, State 1, Line 24
Incorrect syntax near the keyword 'CURRENT'.
{quote}

I presume this is a recent addition to SQL Server's dialect of SQL. Unless 
there are any objections, I'd be in favor of simply removing these. As long as 
Guacamole's SQL queries are kept as standard as possible, the presence/absence 
of these options will have no effect.

> Support Microsoft SQL Server Authentication
> -------------------------------------------
>
>                 Key: GUACAMOLE-363
>                 URL: https://issues.apache.org/jira/browse/GUACAMOLE-363
>             Project: Guacamole
>          Issue Type: Improvement
>          Components: guacamole-auth-jdbc
>    Affects Versions: 0.9.13-incubating
>            Reporter: Nick Couchman
>            Assignee: Nick Couchman
>            Priority: Minor
>             Fix For: 0.9.14
>
>
> Given recent focus on renewing Guacamole compatibility with Windows, having 
> Microsoft SQL Server support seems like a good move.  Also, SQL Server is now 
> available on Linux, since (apparently) Microsoft <3 Linux, so this will 
> provide SQL Server as a backend for those who want to run that.
> Pull Request coming in just a little while.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to