CDB - How to create an ODBC Data Source for a SQL Server database using Windows Authentication.

Knowledge Article

CDB - How to create an ODBC Data Source for a SQL Server database using Windows Authentication.
How to create an ODBC Data Source for a SQL Server database using Windows Authentication.
BMC AMI Capacity Management
Capacity Management Database
BMC AMI Cost Management, BMC Capacity Optimization for Mainframes, Visualizer
BMC AMI Capacity Management
Capacity Management Database
BMC AMI Cost Management, BMC Capacity Optimization for Mainframes, Visualizer
What are the steps required to create an ODBC Data Source for a SQL Server database using Windows Authentication.
 How to create an ODBC Data Source for a SQL Server database using Windows Authentication.
 
Prerequisite:  The SQL Server Client must already be installed on the PC.  A SQL Server database and Windows authenticated UserID must already be created.
Visualizer is a 32-bit application so the 32-bit ODBC Data Source Panel must be used to create the Data Sources used with Visualizer.
  • On a 32-bit version of Windows only the 32-bit ODBC Data Source Panel is available.  It can be found under Control Panel>Administrative Tools>Data Sources ODBC or at the directory\filename “<Windir>\system32\odbcad32.exe” (i.e.  C:\Windows\system32\odbcad32.exe). 
     
  • On a 64-bit version of Windows both the 32-bit and 64-bit ODBC Data Source Panels are available.  The 32-bit ODBC Data Sources Panel can be found under Control Panel>Administrative Tools>Data Sources ODBC 32-bit or at the directory\filename “<Windir>\SysWOW64\odbcad32.exe”  (i.e.  C:\Windows\SysWOW64\odbcad32.exe).
See Knowledge Article:  /apex/KAredirectPage?Type=Solution&KA=KA339636
 
 
Proceed with the following steps to create a SQL Server ODBC Data Source that can be used with Visualizer to access the Capacity Database (CDB).
1.  Once in the ODBC Data Source Panel, first click on the System DSN tab and then on the Add button.

 
2.  Click on the SQL Server Native Client driver and then the Finish button.

 
3.  Enter a name for the Data Source in the Name box, a comment in the Description box is optional and enter the name of the SQL Server instance in the Server.  In the example the SQL Server instance name is the same as the Windows server where it is located, but it’s possible it could be some other name.  Also the example is an un-named SQL Server instance.  A SQL Server named instance would have a naming convention of <server>\<instance> (i.e. techsvr1-wal-11\SQL2012).  Click Next to continue.

 
4.  Click the radio button in front of “With Integrated Windows authentication.”  Click Next to continue.

 
5.  Click in the check box in front of “Change the default database to”.  Next click on the pull down button to show a list of the databases on this SQL Server instance, then click on the database your setting up this data source for.

 
6.  This database will be listed in the “Change the default database to” box.  Click Next to continue.

 
7.  Nothing needs to be changed on this screen.  Just click Finish.

 
8.  Click on “Test Data Source” to verify the settings are valid and a connection can be made to the database.

 
9.  If the connection is successful this screen will be displayed.  If it fails verify the database name, database configuration and if your Windows domain userid was setup in this SQL Server instance.

 
10.  Click OK to continue.

 
11.  The new ODBC Data Source should be displayed.  Click OK to close the ODBC Data Source Administrator.

 
 
BMC AMI Capacity Management
Capacity Management Database
BMC AMI Cost Management, BMC Capacity Optimization for Mainframes, Visualizer
Attachment(s):