Voltar
-
Título
What values should be used to run the SQL Server permissions script manually? -
Descrição
In the SQL Server database agent grant permissions script there are two values to the populated @LoginName and @GrantSSISPermissions
Select @LoginName = ?, -- Please type the login name to be used for logging-in to SQL Server by the cartridge.@GrantSSISPermissions = ?; -
Resolução
The @GrantSSISPermissions value anticipates a 0 or 1 to identify that this SSIS permissions should be granted. 0 for false, 1 for true.
The @LoginName value looks for the loginname for the SQL Server account for which privileges will be granted in single quotes
For example
Select @LoginName = 'DOMAIN\USER', -- Please type the login name to be used for logging-in to SQL Server by the cartridge.@GrantSSISPermissions = 0;