microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Problems getting NS project to run

Subject: Re: Problems getting NS project to run
From: Joe Webb
Date: Thu, 05 Jan 2006 16:18:38 -0600
Newsgroups: microsoft.public.sqlserver.notificationsvcs
What OS are you running? 



-- 
Joe Webb
SQL Server MVP
http://www.sqlns.com


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)


On Thu, 5 Jan 2006 16:31:38 -0500, "Gary Rynearson"
<[email protected]> wrote:

>Here is what I did to get an instance up and running (successful).  Notice I 
>have  two groups of errors identified, both are in Step 3 and are preceded 
>by lines I added in the format of "***** HERE IS THE <number> PROBLEM 
>*******".  (I included steps 1 and 2 just so you could see how I set things 
>up.)
>
>
>
>Can you tell me how to fix the problem?
>
>
>
>I am running SQL Server 2000, .Net 1.1
>
>SQL server is using my NT authentication which is an administrator on the 
>SQL Server.
>
>I do NOT have <PCName>\ASPNET instance running on SQL Server.
>
>
>
>Step 1: Create a new instance (page 45 of Webb) as follows:
>
>
>
>C:\Program Files\Microsoft SQL Server Notification 
>Services\v2.0.3008.0\Samples>
>
>copysample stock mysample
>
>
>
>Copying files from stock to mysample
>
>stock\RemoveSampleDB.cmd
>
>stock\RunSample.cmd
>
>.
>
>. <removed several lines of output>
>
>.
>
>stock\Subscribe\HttpLogger.aspx.cs
>
>stock\Test\RunTest.cmd
>
>38 File(s) copied
>
>
>
>Replacing old sample name with new one in the copied files.
>
>
>
>Warning: If the source sample name is a common phrase (such as
>
>"notification" or "application") then there may be instances of it that
>
>are replaced incorrectly.  Also, if you've added files to the source
>
>sample they will not be included in the search and replace.
>
>
>
>Always double check the contents of the resulting sample files before
>
>trying to use those files.
>
>
>
>mysample.sln: 0 replacement(s) made.
>
>SetProjectVars.cmd: 1 replacement(s) made.
>
>EventsSchema.xsd: 3 replacement(s) made.
>
>appConfig.xml: 4 replacement(s) made.
>
>appADF.xml: 52 replacement(s) made.
>
>Default.aspx.cs: 17 replacement(s) made.
>
>Default.aspx: 19 replacement(s) made.
>
>Subscribe.csproj: 0 replacement(s) made.
>
>Subscribe.csproj.user: 2 replacement(s) made.
>
>EventSubmission.aspx.cs: 10 replacement(s) made.
>
>EventSubmission.aspx: 8 replacement(s) made.
>
>
>
>IMPORTANT: mysample\SetupSample.cmd must be run before
>
>the newly created sample can be built and run.
>
>Sample stock copied to mysample
>
>
>
>
>
>
>
>Step 2: Issue the SetupSample command as directed by output from Step 1 
>process.
>
>
>
>C:\Program Files\Microsoft SQL Server Notification 
>Services\v2.0.3008.0\Samples\
>
>mysample>setupsample "corporate\<myUserID>" "<MyPassword>"
>
>
>
>Registering the instance and installing the service
>
>Microsoft Notification Services Control Utility (Standard) (SP1) 2.0.3008.0
>
>Copyright (C) Microsoft Corporation 2003. All rights reserved.
>
>
>
>Notification Services registry entries are being updated.
>
>The Notification Services Windows service is being installed.
>
>The Notification Services performance counters are being installed.
>
>Registration successful.
>
>
>
>Creating an IIS application directories for 'mysample'
>
>Creating vdir ...
>
>Creating vdir ...
>
>
>
>Step 3: Open the mySample solution in Visual Studio (2003) and compile it. 
>Here is the output and the error:
>
>
>
>------ Rebuild All started: Project: AppDefinition, Configuration: Debug 
>Win32 ------
>
>
>
>Performing Makefile project actions
>
>**** Delete the instance databases
>
>Microsoft Notification Services Control Utility (Standard) (SP1) 2.0.3008.0
>
>Copyright (C) Microsoft Corporation 2003. All rights reserved.
>
>The following instance will be deleted
>
>InstanceName: mysampleInstance
>
>The following applications and their associated databases will be deleted
>
>ApplicationName: mysample
>
>DatabaseName: mysampleInstancemysample
>
>Deleting application
>
>Application name: mysample
>
>Delete successful.
>
>
>
>***** HERE IS THE FIRST PROBLEM *******
>
>Could Not Find C:\Program Files\Microsoft SQL Server Notification 
>Services\v2.0.3008.0\Samples\mysample\Test\Notifications\FileNotifications*
>
>
>
>**** Create the application databases
>
>Microsoft Notification Services Control Utility (Standard) (SP1) 2.0.3008.0
>
>Copyright (C) Microsoft Corporation 2003. All rights reserved.
>
>Creating instance
>
>mysampleInstance
>
>Creating application
>
>Application name: mysample
>
>Create successful.
>
>**** Enable the instance
>
>Microsoft Notification Services Control Utility (Standard) (SP1) 2.0.3008.0
>
>Copyright (C) Microsoft Corporation 2003. All rights reserved.
>
>Status of instance "mysampleInstance":
>
>Subscribers: Enabled
>
>Application: mysample
>
>    Hosted event providers
>
>        mysampleEP (<myPCName>): Enable pending
>
>
>
>    Non-hosted event providers
>
>        WebEventCreator : Enabled
>
>
>
>    Generator
>
>        mysampleGen1 (<MYPCNAME>): Enable pending
>
>
>
>    Distributors
>
>        mysampleDist1 (<MYPCNAME>): Enable pending
>
>
>
>    Subscriptions: Enabled
>
>Windows services
>
>    NS$mysampleInstance (<MYPCNAME>): The service is not running
>
>**** Grant permissions on instance databases to the web and service accounts
>
>Adding the subscription application account (<MYPCNAME>\ASPNET) to the 
>appropriate database roles
>
>Adding the service account ("<myPCName>\<myLoginId>") to the appropriate 
>roles
>
>Running OSQL with the following flags: -S<myPCName> -E
>
>1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 
>22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 
>41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> Granted 
>login access to '<MYPCNAME>\ASPNET'.
>
>Granted database access to '<MYPCNAME>\ASPNET'.
>
>'<MYPCNAME>\ASPNET' added to role 'NSSubscriberAdmin'.
>
>Granted database access to '<MYPCNAME>\ASPNET'.
>
>'<MYPCNAME>\ASPNET' added to role 'NSSubscriberAdmin'.
>
>'<MYPCNAME>\ASPNET' added to role 'NSEventProvider'.
>
>
>
>***** HERE IS THE SECOND PROBLEM *******
>
>Msg 15401, Level 11, State 1, Server <MYPCNAME>, Procedure sp_grantdbaccess, 
>Line 100
>
>Windows NT user or group '<myPCName>\<myLoginId>' not found. Check the name 
>again.
>
>Msg 15410, Level 11, State 1, Server <MYPCNAME>, Procedure sp_addrolemember, 
>Line 66
>
>User or role '<myPCName>\<myLoginId>' does not exist in this database.
>

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