sql server notification services: SSNS Security using installation user acct not service acct -- sql server notification services

SSNS Security using installation user acct not service acct

paulneth NO[at]SPAM gmail.com
6/6/2007 9:31:58 PM

sql server notification services:

We have SSNS app that updates a different database from changes in
another. After installing it always inserts data as my user acct but
NOT the svc defined in ICF. we have custom SQL server del protocol and
channels. I have added a runas to top of the Ourcreate.cmd but no
difference.

Is there any way to force the custom delivery protocol user to the svc
acct not user?

We will try logging in as that user next?

Thanks

Re: SSNS Security using installation user acct not service acct

Joe Webb
6/8/2007 5:50:03 AM

[quoted text, click to view]

How did you register the instance? SSNS components run in the
NS$InstanceName service and will have the security context of that windows
service. The user account is defined when you register the instance.

I've got a short video about this on AskaSqlGuru.com.
http://www.askasqlguru.com/2007/06/07/how-do-i-define-the-security-context-for-a-ssns-component/

HTH...

--
Joe Webb
SQL Server MVP