Re: SSNS Security using installation user acct not service acct
On Wed, 06 Jun 2007 21:31:58 +0000, paulneth wrote:
> 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
> 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?
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.
SQL Server MVP