Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 proxy problem

Author  Topic 

tcronin@cmsstl.com
Starting Member

7 Posts

Posted - 2011-09-30 : 11:24:12
I have a sql user (userA) who is mapped to a proxy. The proxy is tied to a credential. The credential is tied to a winsql login which is a sysadmin and has dbo on msdb. THere is a stored proc which is connected to the db server with userA which has a excute as like below

WITH EXECUTE AS 'STLNTDOM\QNXTService'

DOes the name specified after the execute as need to be the proxy name, credential name?

   

- Advertisement -