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

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Capacity Management for Mainframes


    COMPONENT:

    Capacity Management Database


    APPLIES TO:

    BMC MainView Performance Reporting Family for Mainframes



    PROBLEM:

     

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

      

     

     


    SOLUTION:

     

    Legacy ID:KA390536

      
      Prerequisite:  The SQL Server Client must already be installed on the PC.  A SQL Server database, a SQL Server UserID and password 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. techsvr2-wal-11\SQL2008).  Click Next to continue.    
      
        
      
     
      
        
      
        
      
      4.  Click the radio button in front of “With SQL Server authentication…”.  Enter the SQL Server Login ID and Password previously created by the DBA.  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, userid and password. 
      
        
      
        
      
        
      
        
      
      10.  Click OK to continue. 
      
        
      
        
      
        
      
        
      
      11.  The new ODBC Data Source should be displayed.  Click OK to close the ODBC Data Source Administrator. 
      

     

      

     

     


    Article Number:

    000097441


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles