From 89083807dc047bd86e71481dbbdf7c32d18cb2bc Mon Sep 17 00:00:00 2001 From: Boris Kolpackov Date: Mon, 16 Jan 2012 11:24:29 +0200 Subject: Add setup instructions for SQL Server --- db/mssql/setup | 40 ++++++++++++++++++++++++++++++++++++++++ 1 file changed, 40 insertions(+) create mode 100644 db/mssql/setup 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 , then + choose Network Services. The server should be there. + +4. Connect to database as + + sqlcmd -S \ + + 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. -- cgit v1.1