"Cannot Connect to Database...Login Failed for user 'TRACKIT70'" When Launching Technician Client and the Track-It! 7 Database Runs on SQL 2005

Version 2
    Share:|

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


    PRODUCT:

    Track-It!


    APPLIES TO:

    BMC Track-It!



    PROBLEM:

    If Track-It! 7 was installed and setup to run the database from a SQL 2005 server, the following error may occur when attempting to launch the Technician Client application: Cannot connect to database Click "tell me more" shows: Failed to open connection. Login failed for user 'TRACKIT70'


    SOLUTION:

    Typically this will appear if the TRACKIT70 SQL user is created manually on the SQL 2005 sever or if the user's password is changed through the SQL 2005 Management Studio. To resolve the issue, please take the following steps:

       
    1. On the SQL 2005 server, open the SQL Management Studio.
    2.  
    3. Expand the Security folder and then expand Logins.
    4.  
    5. Right-click the TRACKIT70 user and select Properties.
    6.  
    7. Re-enter the password as BLUEOCEAN (All uppercase) and confirm it.
    8.  
    9. Click Ok to save the changes.
    10.  
    11. Close the Management Studio.
    12.  
    13. Open the ..\Track-It! 7.0\Track-It! Server directory on the Track-It! server and open the trackit.cfg file with Notepad.
    14.  
    15. Locate the TRACKIT_PASSWORD= entry and make sure it looks like the following (Copy and paste the line below if needed): TRACKIT_PASSWORD=nOIQ|iAbZ
    Track-It! should now launch successfully. If you would like to change the password of the TRACKIT70 database user, be sure to do it from within Track-It! by clicking   Tools -> Security -> Change Database Password. This will ensure that both the database and the entry in Trackit.cfg are synchronized correctly. 

      

     


    Article Number:

    000008872


    Article Type:

    Solutions to a Product Problem



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