Add setup instructions for SQL Server

1 files changed, 40 insertions, 0 deletions

diff --git a/db/mssql/setup b/db/mssql/setup
new file mode 100644
index 0000000..e4b8e75
--- /dev/null
+++ b/db/mssql/setup
@@ -0,0 +1,40 @@
+Setting Up
+==========
+
+1. Make sure SQL Server Management Studio or Management Studio Express
+   is installed. If adding Management Studio Express to an already
+   installed SQL Server Express (e.g., as part of VC++ install), then
+   make sure to install as a new instance:
+
+   http://blogs.msdn.com/b/bethmassi/archive/2011/02/18/step-by-step-installing-sql-server-management-studio-2008-express-after-visual-studio-2010.aspx
+
+2. Use Configuration Manager to enable Pipes and TCP/IP transports. In TCP/IP
+   do the following:
+
+   - change Listen All to No
+
+   - in IP Addresses tab, change one of them to
+       - IP address of the machine
+       - Enable to Yes
+       - Port to 1433(default) or some other port (e.g., 1434, 1435).
+
+   Also disable Windows Firewall (Control Panel).
+
+3. In Management Studio to View->Registered Servers, RC Local Server Group->
+   New Server Reistration, in Server Name select <browse for more>, then
+   choose Network Services. The server should be there.
+
+4. Connect to database as
+
+   sqlcmd -S <machine-name>\<db-instance-name>
+
+   sqlcmd -S WINDOWS7\SQLEXPRESS
+
+5. Enable SQL Authentication mode as described in:
+
+   http://msdn.microsoft.com/en-us/library/ms188670.aspx
+
+5. Using Management Studio create odb_test database and odb_test login
+   with odb_test password (sqlcmd does not support empty password).
+   Make odb_test the owner of the database and make default database
+   odb_test.