Configuring data source names for Microsoft SQL Server

Use the following procedure to configure data source names for Microsoft SQL servers.

Note

For more information, visit BMC Websiteand review the Technical Bulletin, Specifying SQL Server ODBC Data Source Definition. For more information, see Accessing-BMC-Software-on-the-Web.

  1. Choose Start > Settings > Control Panel.
  2. Double-click Administrative Tools.
    The Administrative Tools dialog box is displayed.
  3. Double-click Data Sources (ODBC).
    The ODBC Data Source Administrator dialog box is displayed.
  4. Click Add to display a list of installed ODBC drivers.
  5. Select SQL Server and click Finish
    The Create a New Data Source to SQL Server wizard is displayed.
  6. Enter the following:
    • A Name for the data source that you want to use
    • A meaningful Description that clarifies the use of this data source
    • Select a SQL Server from the Server drop down list. If the name is not on the list, please check with your DBA for a server name.
      worddav6a51c5de3066f9da59d28c735bc6df11.png
  7. Do one of the following:
    • If you want to use an SQL Server trusted connection configured on the Server side to connect to the database, click Finish and Test Data Source to test the connection.
      The following figures show what happens if you click Test Data Source and the trusted connection is not set up. 
      worddav411264dd186fb9fcae9aad3c597adfbd.png
      worddavb6b65fe8ee41bf04a791707fa3cb7da8.png
    • If the trusted connection was not configured on the Server side or you want SQL authentication to login, click Next.
      worddav12dc37c1faa3f32f52d0bcdd9654dbfe.png
  8. Choose either Windows NT authentication login or SQL Server authentication login if the server was configured with both connection methods.
  9. If selecting SQL Server authentication and Connect to SQL Server to obtain default settings for additional configuration options, the Login ID and Password are enabled.
    Enter user ID and password. If you don't know the ID and password, check with your DBA.
  10. Click Client Configuration to open the Add Network Library Configuration window to verify the TCP/IP connection. 
    worddav6ae31bf9a35145d45672aa374ff6f04a.png
  11. Click OK to return to the following page in Create a New Data Source to SQL Server wizard. If the database needs to be connected, it is not the default database. 
    Select Change the default database to: and select the database to which you want to connect from the list. Leave the default ANSI settings as they are. 
    worddav99870d3d15153e72116781ac5545fe7d.png
  12. Click Next. 
    worddav6cf5ca1d2b63fa2d0b7b99cddb2571d1.png
  13. Accept the default settings and click Finish.
  14. In the ODBC Microsoft SQL Server Setup dialog box, click Test Data Source.
    The SQL Server ODBC Data Source Test dialog box is displayed. 
    worddav010fa5e9751fedd9d2d0acf4bca36cfb.png
  15. Click OK until you exit the wizard.
    See also the driver vendor's online help for more information about these dialog boxes.

Note

Your DBA must assist you with the installation and configuration of SQL Server server software. Remember to configure memory and tempdb.

Related topic

Installing


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*