SQL7.0 proxy account ??
-
Due to some problems, we've come to the conclusion to open cmd-shell for non-sa on certain sql7-servers.
So I've pushed the "reset proxy" button on the sqlagent-properties and "reset proxy password".
This did not help to open it
DECLARE @cmd sysname, @var sysname
SET @var = 'Hello world'
SET @cmd = 'echo ' + @var + ' > var_out.txt'
EXEC master..xp_cmdshell @cmd
fails with
Msg 50001, Level 1, State 50001
xpsql.c: Error 1385 from LogonUser on line 486
Any ideas ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
I don't have a SQL Server 7.0 handy at the moment but I believe that this works. You can use xp_sqlagent_proxy_account N'get' to determine what user the proxy account is running as. You can then assign privileges to that user if you need to. If you need to change the user you can use xp_sqlagent_proxy_account N'set', N'agent_domain_name', N'agent_username', N'agent_password' to set the account.
-
helas, with sql7 there is no xp_sqlagent_proxy_account
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply