26Chapter 3E 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, anddisplays the results of the test. Normally the test will be successful, so click OK. If the test is notsuccessful, you should make a note of any messages the system has displayed and then try toresolve 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 justcreated and click Remove. Confirm your request when prompted to do so.Checking that IIS is running correctlyNote: This is required on all machines that will host the Web, Interview, and/or the AccessoriesService. 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 localmachine.As long as your browser does not issue the message “Cannot find server or DNS Error” thenIIS is running.Creating the installing and running usersIBM® SPSS® Data Collection Interviewer Server must be installed by a user with localadministrative rights. This user must have SQL DB Creator permission on the Database serverwhile the installation is running, in order to create or update the main Interviewer Serverdatabases. Once the installation is finished you may remove this right.
