1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

MSSQL Credentials

Discussion in 'Microsoft SQL Server' started by etchingsj, Jan 11, 2012.

  1. etchingsj

    etchingsj ADSM.ORG Member

    Joined:
    Feb 5, 2008
    Messages:
    243
    Likes Received:
    7
    Occupation:
    Sustaining Engineer
    Location:
    Lost Wages NV
    Is there a quick way I can instruct our DB team to view which credentials are being used to access the SQL database for backups?
    In the current shop our team (backup/DR) has only access to the TSM servers and the DBA's handle all client side issues. But for an audit they need to know the credentials used for SQL on all servers.
    And there are a few.

    Thanks in advance,
     
  2.  
  3. smajl

    smajl ADSM.ORG Senior Member

    Joined:
    Dec 10, 2009
    Messages:
    169
    Likes Received:
    20
    Location:
    Brno
    User under which is running scheduler is also used for accessing MSSQL unless stated else in script (parameter /SQLUSer) or in tdpsql.cfg file.
     
  4. GregE

    GregE ADSM.ORG Senior Member

    Joined:
    May 12, 2006
    Messages:
    2,100
    Likes Received:
    31
    Local System account is running the TSM Windows services doing the backup. You don't need any additional Windows account for that. You DO need a user with "sysadmin" role in SQL Server in order to access the TDP GUI or command line, and you'll need to login to the Windows server using that account for those things to function. But for the scheduled backup, no special account is necessary to run the Windows service.
     
  5. etchingsj

    etchingsj ADSM.ORG Member

    Joined:
    Feb 5, 2008
    Messages:
    243
    Likes Received:
    7
    Occupation:
    Sustaining Engineer
    Location:
    Lost Wages NV
    Our DBA team has an audit and just need to know the credentials TDP uses to read the MSSQL database.
    I am guessing the client was installed using the SA account. But I need to be able to direct them to a location to verfiy for audit.
    Just not sure where to direct them.

    I had them look at tdpsql.cfg without luck.
     
  6. smajl

    smajl ADSM.ORG Senior Member

    Joined:
    Dec 10, 2009
    Messages:
    169
    Likes Received:
    20
    Location:
    Brno
    Schedule backup operation and verify in Windows Event Viewer which account logged into MSSQL, there is an entry for that.
     

Share This Page