diff options
| -rw-r--r-- | db/mssql/setup | 40 |
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. |