[Top] [All Lists]

Re: SQLServer2000 SP4 & NS 2.0 SP1 & Windows 2000 SP4 & Windows Authenti

Subject: Re: SQLServer2000 SP4 & NS 2.0 SP1 & Windows 2000 SP4 & Windows Authentication problem
From: Joe Webb
Date: Tue, 01 Nov 2005 11:39:00 -0600
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Are you using a hosted event provider or a custom, non-hosted event

Joe Webb
SQL Server MVP

Get up to speed quickly with SQLNS 

I support PASS, the Professional Association for SQL Server.

On 26 Oct 2005 03:45:08 -0700, "Eagle" <[email protected]> wrote:

>Thanks for reply, Joe!
>>>Windows 2000 machine is domain controller. There are installed MSSQL
>>>and NS.
>>Generally not a good idea to install a production SQL Server instance
>>on a Domain Controller. Too much load for one machine.
>It's only test server ... Product server is stand-alone.
>>>'DOMAIN\notification_services' account was added to database logins and
>>>it has all needed grants.
>>What rights has it been granted? Is it a member of the NSRunService
>>database role?
>I used "GrantXpExec.cmd" from \bin NS's directory and
>"GrantPermissions.cmd" from Samples. Accordingly,
>'DOMAIN\notification_services' account is member of the NSRunService
>role in "...InstanceApp" and "...InstanceNSMain" databases.
>>>If i use Windows 2003 Server instead of Windows 2000 then this problem
>>>doesn't exist!
>>Are these two different installations in a test environment? Are you
>>taking the same ICF and ADF and compiling the on the 2 different
>Yes. Yes.

<Prev in Thread] Current Thread [Next in Thread>