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

Re: Problems getting NS project to run

Subject: Re: Problems getting NS project to run
From: "Gary Rynearson"
Date: Fri, 6 Jan 2006 07:45:59 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
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>