VERIFIED SOLUTION i
X

How to run Sarun with Windows Authentication on SQL Server repository DB in Sagent Data Flow

UPDATED: November 15, 2017


When user name and password for SQL Server are kept blank in Sarun, it runs using windows authentication.
 
For example:
In case you are running SQL Server authentication below is the command.

sarun "planname" "Sagent user:Sagent password:SQL SERVER:server name:repo db name:sql server user:sql server password"
 
To run Sarun with the windows authentication, one will have to replace sql server user & sql server password with blank.
 
sarun "planname" "Sagent user:Sagent password:SQL SERVER:server name:repo db name:: "
 
 
Windows login used for this authentication is the same as the user who launched Sarun. So if I'm logged as the user domain\user1 and launch sarun, it will be authenticated by this user.
 
 

Downloads

  • No Downloads