June 6, 2012 at 8:35 am
I have three external users that are using SQL Server Authentication.
They want to be able to create and run jobs.
I added them as a member of the SQLAgentUserRole.
I know that a Proxy Account needs to be created but the part that I'm unsure about is the Credentials Account?
What type of Account should I use?
I goggled this and the hits that were returned specified to create the account but the explanations that I found were not that detailed. One Microsoft Account used a mary5 User Account.:w00t:
Could someone please tell me what type of account(s) that can be used?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 6, 2012 at 9:42 am
I followed the following steps to create a Credential, Proxy Account,etc.
I thought that it was a pretty good article.
I found the section "Specify Proxy to Use for Job Step" to be confusing.
I tested it using an SQL Server Test Account as well as a test SSIS Package that I created.
Everything worked fine.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply