Create a DSN for a SQL Server 7 or SQL Server 2000 databaseDSN names are alias names that ODBC applications use to reference ODBC connections to a specific database. In order for the web reports to be able to access the PRISM database, you will need to create a DSN that points to it.
Create a DSN for a SQL Server 7 or SQL Server 2000 database
Create a DSN for an Oracle 8 database
1. On the report server, go to Start --> Settings --> Control Panel --> Data Sources (ODBC)
2. On the System DSN tab, click Add to add a new DSN.
3. Select the SQL Server driver from the drivers list, then click Finish.
4. On the next screen, enter the information for your database server, then click Next.
5. On the next screen, check the SQL Server Authentication radio box, and enter the appropriate database login and password. By default the prism 61 database user is "prism61" and the password is "prism61." If your organization has changed this, then be sure to enter the information as appropriate. Click Next to continue.
|
|
For SQL 2000 users, you may need to additionally click the Client Configuration button and change the connection type from TCPIP to Named Pipes. |
6. On the next screen, verify that the default database to attach to is "prism61", then click Next to continue.
7. Accept all the defaults on the next screen by clicking Finish.
8. Test your database connectivity by clicking Test Data Source. A successful test will yield the following message.
Once you’ve finished creating your DSN, continue setting up the web report scripts..
1. On the report server, go to Start --> Settings --> Control Panel --> Data Sources (ODBC)
2. On the System DSN tab, click Add to add a new DSN.
3. Select the Oracle driver from the drivers list, then click Next to continue.
4. On the next screen, enter the information for your database server, then click OK.
Once you’ve finished creating your DSN, continue setting up the web report scripts..
