blob: e4b8e7539246256d0fa3a99d588d49365ef37566 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
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.
|
