About this task
In these steps you create an ODBC data source that is used
by a Windows-based Management Console to access the database you created
in Microsoft SQL Server. You must create a 32-bit ODBC data source
regardless of whether you are running a 32-bit Windows system or a
64-bit Windows system.
Procedure
- Start the Data Source Administrator.
- For 32-bit Windows systems: From the Windows start menu, select .
- For 64-bit Windows systems: double-click the file C:\Windows\SysWOW64\odbcad32.exe.
The Data Source Administrator dialog
box is displayed so that you can create the required 32-bit ODBC data
source on the 64-bit system.
- On the System DSN tab, click Add. A list of drivers appears.
- Select MS SQL Server from the list
of drivers, then click Finish. In
the ODBC Setup dialog box that appears, enter
the following information:
- Data Source Name: the name for this data source, must
be the same as Database Name and must not be the same as the schema
name associated with the database.
- Description: description for this data source.
- Server Name: host name of the host where the MS SQL Server
database is installed.
- Database Name: database name you created above.
Click OK to close ODBC Setup,
then OK to close ODBC Data Source Administrator.
The data source is created.
Results
Make a note of the following information. It is requested
by the installation program when you install the Management Console.
- Data source name: as you assigned when creating the ODBC
data source
- Data source type: SQL Server
- User name: user name you created for the database (for
example, build)
- Password: password for the user name (for example, build)
Important: Use the same value for the Database Name
and Data Source Name. A limitation in JDBC drivers requires this constraint.
If they are not the same, the Quick Report reporting feature and the
services-layer APIs for Java and Perl do not work.