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 the Windows Control Panel, and then choose Administrative Tools > Data Sources (ODBC)
The ODBC Data Source Administrator dialog opens.
2 On the System DSN tab, click Add.
The Create New Data Source dialog opens.
3 Select SQL Server, and then click Finish.
The Create a New Data Source to SQL Server dialog opens.
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.
The ODBC Microsoft Server Setup dialog opens.
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.
If the test is successful, click OK.
If the test is not successful, 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. Select the test DSN you have just created, and then click Remove.
See