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: Tue, 10 Jan 2006 05:45:51 -0600
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Great! Thanks for posting the solution!

-- 
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 Mon, 9 Jan 2006 10:15:59 -0500, "Gary Rynearson"
<[email protected]> wrote:

>Thanks Joe
>
>I appreciate you providing clairification on the ASPNet worker process.
>
>I found an additional problem - one with my installation process.  I did not 
>install SQLXML prior to installing notificaion services.  So, I uninstalled 
>NS, installed SQLXML, and reinstalled NS.  I am now able to successfully 
>compile the application in Visual Studio, and get the web site up and 
>running http://localhost/nssamples/<myTestSite>/Default.aspx.
>
>Gary
>
>"Joe Webb" <[email protected]> wrote in message 
>news:[email protected]
>> Hi Gary -
>>
>> Since you're running XP, there's a machine account called ASPNET that
>> is what is used to run the ASP.NET worker process (aspnet_wp.exe).
>> When the message indicates that it successfully added ASPNET to a
>> database role, that's what it's referring to.
>>
>> SQLNS has predefined database roles (NSSubscriberAdmin, etc) that
>> configure the permissions required for certain SQLNS related
>> activities.
>>
>> The last part of your posting indicates that the script is attempting
>> to add your login id to a SQLNS roles, however your login id wasn't
>> found as such in SQL Server.
>>
>> HTH...
>>
>> -- 
>> 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 Fri, 6 Jan 2006 07:45:59 -0500, "Gary Rynearson"
>> <[email protected]> wrote:
>>
>>>I am running Windows XP Pro.
>>>
>>>
>>>"Joe Webb" <[email protected]> wrote in message
>>>news:[email protected]
>>>> 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>