Create credential
I need to create a credential,and a proxy for my Jr. dba to support and troubleshoot production SSIS and SQL jobs.
I want to create a credential/proxy that follows best practice and can be implemented as a standard across environments. Can you give me an example of a credential that has sufficient permissions? Do I request a Domain user with permissions similar to those of the domain user under which our sql server services run?
Software/Hardware used:
Software/Hardware used:
ASKED:
October 25, 2007 7:50 PM
UPDATED:
December 2, 2007 11:19 AM
Answer Wiki:
Credentials must be Windows account either domain or local accounts.
When setting up credentials to match production, seperate accounts should be used to create the credential, however the name of the credential should match production so that scripts can be moved from development to QA to Production without ever having to change the code.
Here is a <a href="http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1266464,00.html">code portbility tip</a> on SearchSQLServer.com.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
