Groups | Blog | Home
all groups > sql server notification services > february 2005 >

sql server notification services : How to get notification instance from another machine


P
2/14/2005 2:39:05 AM
Hi
I want to run my webapplication at machine1, which should access the
notification instance created at machine2. I dont see any server
configuration in notificationservices properties. How this can be done?

P
2/14/2005 5:15:04 AM
Hi Joe.
I have created NS Instance in machine1 and i want to add subscriber and
subscription in that instance of machine1 through the webapplication. This
webapplication runs on machine2.
But when i try to use webapplication on machine2, it looks for the NS
instance of machine2. In short, i want to add subscriber in the NS instance
of machine1 through the webapplication of machine2. but it returns the
registry key not found error.
I hope this time my question is clear.

Thanks

[quoted text, click to view]
Joe Webb
2/14/2005 7:27:06 AM
Hi P -

I'm assuming that webapplication is a subscription management
application that allows subscribers to sign up to receive notifications,
manage their subscriptions, etc. If so, then machine1 should already
have IIS, etc, on it. Now you'll need to install the NS Client
Components on machine1 so that it'll have the NS API. Next register the
NS instance using NSControl so that the webapplication will know about
the particular instance, including the server name and instance name.
And finally, develop your .net webapplication to allow subscribers to
sign up.

For more information, look up "subscription management applications,
deploying" in BOL.

If I've misunderstood your question, let me know.

HTH...
Joe Webb
SQL Server MVP

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



[quoted text, click to view]
Colin Meek [MSFT]
2/14/2005 7:56:21 AM
Joe's instructions are correct given your description of the roles of
machines 1 and 2 in your first message. For clarity, let's describe the two
machines as your NS service machine (NS) and your subscription management
web application machine (subscription).

On the NS machine, you will need to 'create' the instance, and 'register' it
as a service.

On the subscription machine, you only need to 'register' the instance, so
that the NS API knows where to find the instance database you created on the
NS machine. Otherwise, you will see the "registry key not found" error

- Colin Meek [MSFT]

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

Please do not send e-mail directly to this alias. This alias is for
newsgroup purposes only.
--

[quoted text, click to view]

Joe Webb
2/14/2005 10:28:17 AM
Hey P -

Have you run "NSControl register ..." on the web server? Here's an
excerpt from BOL that may be helpful.

From BOL on NSControl register...

-server database_server_name
Is the name of the server that hosts the instance database. If you use a
named instance of SQL Server to host the instance database, you must
specify both the server name and instance name, using the format
servername\instancename.

-service
Creates the NS$instance_name service for the instance, registers the
service, and creates performance counters for the instance.
When running NSControl Register on a server that does not run the event
provider, generator, or distributor, do not specify the -service
argument. For example, on a Web server that requires access to the
subscriber API you need to register the instance, but you do not need to
install the service.




Also, in your instance configuration node, what do you have for the
<SqlServerSystem> element?

I usually put something like this:
<SqlServerSystem>%_SqlServer_%</SqlServerSystem>

And have a parameter default like so:
<ParameterDefaults>
<Parameter>
<Name>_BaseDirectoryPath_</Name>
<Value>C:\Data\SQLNS\PASSDemo\ABCMotorworks\PressRelease\PressRelease</Value>
</Parameter>
<Parameter>
<Name>_SqlServer_</Name>
<Value>MyCPU</Value>
</Parameter>
<Parameter>
<Name>_NSHost_</Name>
<Value>MyCPU</Value>
</Parameter>
</ParameterDefaults>


HTH...
Joe Webb
SQL Server MVP

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



[quoted text, click to view]
P
2/16/2005 11:35:01 PM
AddThis Social Bookmark Button