summaryrefslogtreecommitdiff
path: root/db/mssql
diff options
context:
space:
mode:
Diffstat (limited to 'db/mssql')
-rw-r--r--db/mssql/setup40
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.