Github user mike-jumper commented on a diff in the pull request:
https://github.com/apache/guacamole-manual/pull/66#discussion_r159112121
--- Diff: src/chapters/jdbc-auth.xml ---
@@ -299,6 +343,61 @@ Type "help" for help.
to run any database upgrade scripts.</para>
</important>
</section>
+ <section xml:id="jdbc-auth-sqlserver">
+ <title>SQL Server</title>
+ <para>If using SQL Server, the database and schema must be
created first. The example below assumes
+ that you are running SQL Server on Linux, using the
command-line tools to manage it, however, this
+ code can be run using any tool capable of running SQL
against a SQL Server database.</para>
+ <informalexample>
+ <screen><prompt>$</prompt>
<userinput>/opt/mssql-tools/bin/sqlcmd -S localhost -U SA</userinput>
+<prompt>Password:</prompt>
<userinput><replaceable>password</replaceable></userinput>
+<prompt>1></prompt> <userinput>CREATE DATABASE
<replaceable>guacamole_db</replaceable>;</userinput>
+<prompt>2></prompt> <userinput>GO</userinput>
+<prompt>1></prompt> <userinput>CREATE LOGIN
<replaceable>guacamole_user</replaceable> WITH PASSWORD =
'<replaceable>some_password</replaceable>';</userinput>
+<prompt>2></prompt> <userinput>GO</userinput>
+<prompt>1></prompt> <userinput>USE
<replaceable>guacamole_db</replaceable>;</userinput>
+<prompt>2></prompt> <userinput>GO</userinput>
+<prompt>1></prompt> <userinput>CREATE USER
<replaceable>guacamole_user</replaceable>;</userinput>
+<prompt>2></prompt> <userinput>GO</userinput>
+<prompt>1></prompt> <userinput>ALTER ROLE db_datawriter ADD MEMBER
<replaceable>guacamole_user</replaceable>;</userinput>
+<prompt>2></prompt> <userinput>ALTER ROLE db_datareader ADD MEMBER
<replaceable>guacamole_user</replaceable>;</userinput>
+<prompt>3></prompt> <userinput>GO</userinput></screen>
+ </informalexample>
+ <para>Once the database and user account is created, and the
user associated with the database, you can use
+ the supplied scripts to load the schema into the database.
These scripts are included in the
+ <filename>sqlserver/schema/</filename> directory of the
archive you downloaded from the Guacamole
+ web site.</para>
+ <informalexample>
+ <screen><prompt>$</prompt>
<userinput>/opt/mssql-tools/bin/sqlcmd -S localhost -U
<replaceable>guacamole_user</replaceable> -d
<replaceable>guacamole_db</replaceable> -i
schema/001-create-schema.sql</userinput>
+<prompt>Password:</prompt>
<userinput><replaceable>some_password</replaceable></userinput>
+<computeroutput>Rule bound to data type.
+The new rule has been bound to column(s) of the specified user data type.
+Rule bound to data type.
+The new rule has been bound to column(s) of the specified user data
type.</computeroutput>
+<prompt>$</prompt> <userinput>/opt/mssql-tools/bin/sqlcmd -S localhost -U
<replaceable>guacamole_user</replaceable> -d
<replaceable>guacamole_db</replaceable> -i
schema/002-create-admin-user.sql</userinput>
+<prompt>Password:</prompt>
<userinput><replaceable>some_password</replaceable></userinput>
+<computeroutput>
+(1 rows affected)
+
+(3 rows affected)
+
+(5 rows affected)</computeroutput></screen>
+ </informalexample>
+ <para>If the operation is successful, the tables and
permissions have been created successfully, and you
+ can now use the database with the Guacamole client web
application.</para>
+ <important xml:id="jdbc-auth-sqlserver-upgrade">
--- End diff --
Since this isn't yet relevant, we should probably just omit this. We can
re-add and update the `<important>` section when upgrade scripts exist.
---
