26
Chapter 3
E
Open Control Panel and choose:
Administrative Tools > Data Sources (ODBC)
This opens the ODBC Data Source Administrator dialog box.
E
On the System DSN tab, click
Add
.
This opens the Create New Data Source dialog box.
E
Choose SQL Server and then click
Finish
.
This opens the Create a New Data Source to SQL Server dialog box.
E
In Name, type a name for the test DSN.
E
In Server, select the name of the IBM® SPSS® Data Collection Interviewer Server database server.
E
Click
Next
.
E
On the next two screens, just click
Next
.
E
On the following screen, click
Finish
.
This opens the ODBC Microsoft Server Setup dialog box.
E
Click
Test Data Source
.
The system checks that it can access the database using the DSN you have just created, and
displays the results of the test. Normally the test will be successful, so click OK. If the test is not
successful, you should make a note of any messages the system has displayed and then try to
resolve the problem before trying to create a test DSN again.
E
Return to the ODBC Data Source Administrator dialog box. Select the test DSN you have just
created and click Remove. Con
fi
rm your request when prompted to do so.
Checking that IIS is running correctly
Note:
This is required on all machines that will host the Web, Interview, and/or the Accessories
Service. IIS is not required on machines running just the Interview Service.
E
In Internet Explorer, type
http://machine_name
, where
machine_name
is the name of your local
machine.
As long as your browser does not issue the message “Cannot
fi
nd server or DNS Error” then
IIS is running.
Creating the installing and running users
IBM® SPSS® Data Collection Interviewer Server must be installed by a user with local
administrative rights. This user must have SQL DB Creator permission on the Database server
while the installation is running, in order to create or update the main Interviewer Server
databases. Once the installation is
fi
nished you may remove this right.
