[2008R2] Création dans credentials

Bonjour,

J'ai ce message d'erreur:

Code:

1
2
Msg 15153, Level 16, State 1, Procedure xp_cmdshell, Line 1
The xp_cmdshell proxy account information cannot be retrieved or is invalid. Verify that the '##xp_cmdshell_proxy_account##' credential exists and contains valid information.

En essayant cette requête:

Code:

1
2
EXEC sp_xp_cmdshell_proxy_account 'domain\moncompte', 'pass';  
GO

Result:

Code:

1
2
Msg 15137, Level 16, State 1, Procedure sp_xp_cmdshell_proxy_account, Line 1
An error occurred during the execution of sp_xp_cmdshell_proxy_account. Possible reasons: the provided account was invalid or the '##xp_cmdshell_proxy_account##' credential could not be created. Error code: '5'.

Est ce que la création de Credentials est reservée uniqument aux users Windows ou c'est valable aussi pour les users SQL ?

J'ai essayé:

Code:

1
2
3
4
5
EXECUTE xp_sqlagent_proxy_account N'SET'
                        , N'DOMAIN'
                        , N'WINDOWS-USER'
                        , N'PASS'
GO

Ne trouve la proc xp_sqlagent_proxy_account !

Code:

1
2
3
4
GRANT exec ON xp_cmdshell TO SQL-USER
GO   
 
Command(s) completed successfully

Merci.

@+

Problème de syntaxe:

Code:

create credential ##xp_cmdshell_proxy_account## with identity = 'USER-WINDOWS', secret = 'PASSE'

Bon weekend à ts.

@+