# HG changeset patch
# User Aurelien Campeas <aurelien.campeas@logilab.fr>
# Date 1267542396 -3600
# Node ID 516e971f10ea0fa1f5d1e0abd56ef9da441a44b5
# Parent  f03be559f19397abe9539debad1886e9c37d9cab
[book/admin/setup] notes about configuration of sql server

diff -r f03be559f193 -r 516e971f10ea doc/book/en/admin/instance-config.rst
--- a/doc/book/en/admin/instance-config.rst	Tue Mar 02 15:47:26 2010 +0100
+++ b/doc/book/en/admin/instance-config.rst	Tue Mar 02 16:06:36 2010 +0100
@@ -12,7 +12,8 @@
 
     /etc/cubicweb.d/myblog/all-in-one.conf
 
-It is a simple text file format INI. In the following description,
+It is a simple text file in the INI format
+(http://en.wikipedia.org/wiki/INI_file). In the following description,
 each option name is prefixed with its own section and followed by its
 default value if necessary, e.g. "`<section>.<option>` [value]."
 
diff -r f03be559f193 -r 516e971f10ea doc/book/en/admin/setup.rst
--- a/doc/book/en/admin/setup.rst	Tue Mar 02 15:47:26 2010 +0100
+++ b/doc/book/en/admin/setup.rst	Tue Mar 02 16:06:36 2010 +0100
@@ -373,7 +373,7 @@
 ```````````````````
 Yout must add the following lines in ``/etc/mysql/my.cnf`` file::
 
-    transaction-isolation = READ-COMMITTED
+    transaction-isolation=READ-COMMITTED
     default-storage-engine=INNODB
     default-character-set=utf8
     max_allowed_packet = 128M
@@ -382,6 +382,26 @@
     It is unclear whether mysql supports indexed string of arbitrary lenght or
     not.
 
+SQLServer configuration
+-----------------------
+
+As of this writing, sqlserver support is in progress. You should be
+able to connect, create a database and go quite far, but some of the
+generated SQL is still currently not accepted by the backend.
+
+The `source` configuration file may look like this (specific parts
+only are shown)::
+
+  [system]
+  db-driver=sqlserver2005
+  db-user=someuser
+  # database password not needed
+  #db-password=toto123
+  #db-create/init may ask for a pwd: just say anything
+  db-extra-arguments=Trusted_Connection
+  db-encoding=utf8
+
+
 Pyro configuration
 ------------------