14
Chapter 2
E
If you have installed SQL 2005 Developer Edition, enable remote connections as follows:
From the Start menu choose
Programs > Microsoft SQL Server 2005 > Con
fi
guration Tools > SQL Server Surface Area
Con
fi
guration
This opens the SQL Server 2005 Surface Area Con
fi
guration dialog box.
Click
Surface Area Con
fi
guration for Services and Connections
In the left-hand frame of the next screen, select the View by Instance tab. Expand the node for
the SQL instance that you are using and click
Remote Connections
.
In the right-hand frame, select
Local and remote connections
and then
Using both TCP/IP and
Named Pipes
.
Click
OK
to save your changes and then close the program.
Stop and restart SQL Server to implement the change.
Installing SQL Server on machines running the database service
You must have SQL Server, including the latest service packs, installed on all machines that will
run the Database Service. If you are going to have more than one machine running the Database
Service they must operate in Active–Passive mode rather than Active–Active mode. Refer to your
SQL documentation for further information about operation modes.
Note
: SQL Server 2005 comes in a number of different editions. Since it is only the feature set
that differs across editions, you should be able to use IBM® SPSS® Data Collection Interviewer
Server with any edition, but note that there are limitations on the maximum number of CPUs
supported and on memory.
For more information, see the topic
Installing Microsoft SQL Server
on p. 13.
Installing Microsoft Office Web Components (OWC)
If you will be using the charting feature, Microsoft Of
fi
ce Web Components (OWC) version
10 or later must be installed on your server. To view charts in IBM® SPSS® Data Collection
Survey Tabulation or IBM® SPSS® Data Collection Survey Reporter, you must also have a
license for Microsoft OWC on each client machine. Before enabling this feature for any user,
you
must
verify that the user is appropriately licensed for Microsoft OWC. Check your Microsoft
OWC license agreement or EULA.
On machines running the accessories service
Microsoft Of
fi
ce Web Components (OWC) version 10 or later is required for the charting feature
of the Phone Reports activity.
Note
: The charting facility is normally disabled in Phone Reports. Before enabling it for a user,
you
must
verify that the user is appropriately licensed for MS OWC. Check your MS OWC
license agreement or EULA.
