Results 1 to 5 of 5
  1. #1
    Member etchingsj's Avatar
    Join Date
    Feb 2008
    Location
    Lost Wages NV
    Posts
    243
    Thanks
    1
    Thanked 6 Times in 6 Posts

    Question MSSQL Credentials

    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. #2
    Senior Member
    Join Date
    Dec 2009
    Location
    Brno
    Posts
    119
    Thanks
    1
    Thanked 19 Times in 18 Posts

    Default

    User under which is running scheduler is also used for accessing MSSQL unless stated else in script (parameter /SQLUSer) or in tdpsql.cfg file.

  3. #3
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    2,100
    Thanks
    9
    Thanked 17 Times in 16 Posts

    Default

    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.

  4. #4
    Member etchingsj's Avatar
    Join Date
    Feb 2008
    Location
    Lost Wages NV
    Posts
    243
    Thanks
    1
    Thanked 6 Times in 6 Posts

    Default

    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.

  5. #5
    Senior Member
    Join Date
    Dec 2009
    Location
    Brno
    Posts
    119
    Thanks
    1
    Thanked 19 Times in 18 Posts

    Default

    Schedule backup operation and verify in Windows Event Viewer which account logged into MSSQL, there is an entry for that.

Similar Threads

  1. mssql restore
    By dwcasey in forum TSM Client
    Replies: 4
    Last Post: 07-13-2010, 07:21 PM
  2. MSSQL Backup
    By mmongon in forum Microsoft SQL Server
    Replies: 3
    Last Post: 07-11-2010, 07:39 PM
  3. MSSQL or Filesystem?
    By GregE in forum TDP/Application Layer Backup
    Replies: 5
    Last Post: 12-19-2007, 09:31 AM
  4. TDP FOR MSSQL Help
    By chandupotter in forum TSM Reporting & Monitoring
    Replies: 3
    Last Post: 12-15-2006, 04:23 AM
  5. TDP for MSSQL
    By Murkin in forum TDP/Application Layer Backup
    Replies: 5
    Last Post: 12-09-2003, 10:09 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •