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.