Results 1 to 5 of 5
Thread: MSSQL Credentials
-
01-11-2012, 12:22 PM #1
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,
-
01-11-2012, 02:07 PM #2Member
- Join Date
- Dec 2009
- Location
- Brno
- Posts
- 91
- Thanks
- 1
- Thanked 18 Times in 17 Posts
User under which is running scheduler is also used for accessing MSSQL unless stated else in script (parameter /SQLUSer) or in tdpsql.cfg file.
-
01-11-2012, 04:54 PM #3
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.
-
01-11-2012, 05:05 PM #4
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.
-
01-11-2012, 05:27 PM #5Member
- Join Date
- Dec 2009
- Location
- Brno
- Posts
- 91
- Thanks
- 1
- Thanked 18 Times in 17 Posts
Schedule backup operation and verify in Windows Event Viewer which account logged into MSSQL, there is an entry for that.
Similar Threads
-
mssql restore
By dwcasey in forum TSM ClientReplies: 4Last Post: 07-13-2010, 07:21 PM -
MSSQL Backup
By mmongon in forum Microsoft SQL ServerReplies: 3Last Post: 07-11-2010, 07:39 PM -
MSSQL or Filesystem?
By GregE in forum TDP/Application Layer BackupReplies: 5Last Post: 12-19-2007, 09:31 AM -
TDP FOR MSSQL Help
By chandupotter in forum TSM Reporting & MonitoringReplies: 3Last Post: 12-15-2006, 04:23 AM -
TDP for MSSQL
By Murkin in forum TDP/Application Layer BackupReplies: 5Last Post: 12-09-2003, 10:09 AM


Reply With Quote