Dat_Nguyen-Tat_9196

SQL agent with 2 authentication mode SQL + Windows at the same time ?

Discussion created by Dat_Nguyen-Tat_9196 on Jun 23, 2017
Hello, 

I am using AE v12 and i have a question related to SQL agent

Is it possible to use a sql server user defined with 'windows authentication' on a regular sql agent (without using the 'windows authenticaton' option on the ini file)? 

I've tried to but received a login failed message.
One of our customers has mixed needs with the same sql server agent: some jobs uses a db user and some must run with a windows user.

Thanks you all!

Outcomes