Checking that SQL Server is running correctly
The computers running the Interview Service need to be able to connect to the Database server. You can test that these connections work by creating a test DSN on each of the Interviewing computers in turn.
1 Open Control Panel and choose Administrative Tools > Data Sources (ODBC)
This opens the ODBC Data Source Administrator dialog box.
2 On the System DSN tab, click Add.
This opens the Create New Data Source dialog box.
3 Choose SQL Server and then click Finish.
This opens the Create a New Data Source to SQL Server dialog box.
4 In Name, type a name for the test DSN.
5 In Server, select the name of the UNICOM Intelligence Interviewer - Server database server, and then click Next.
6 On the next two screens, just click Next.
7 On the following screen, click Finish.
This opens the ODBC Microsoft Server Setup dialog box.
8 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.
9 Return to the ODBC Data Source Administrator dialog box. Select the test DSN you have just created and click Remove. Confirm your request when prompted to do so.
See