1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link 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 message will disappear after you have made at least 12 posts. Thank you for your cooperation.

MSSQL Credentials

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

  1. etchingsj

    etchingsj 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 Senior Member

    Joined:
    Dec 10, 2009
    Messages:
    145
    Likes Received:
    19
    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 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 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 Senior Member

    Joined:
    Dec 10, 2009
    Messages:
    145
    Likes Received:
    19
    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