How to access NS remotly?

tarpan

unread,

Jan 17, 2006, 4:56:04 PM1/17/06

to

Hi,

It suppose to be real simple, but I can not find out how to do it. I have a
SQL server and Web server on 2 separate PCs. When I create NSInstance object

NS_Instance = New
Microsoft.SqlServer.NotificationServices.NSInstance(NS_InstanceName)

.Net tries to access NS right on the Web server.

How to point it to the another PC?

Thanks

Oleksiy

Joe Webb

unread,

Jan 17, 2006, 5:58:29 PM1/17/06

to

On the server that will host your subscription management application,
you need to register the instance using something like:

nscontrol register -name instanceName -server databaseServer

where instanceName is the name of the instance and databaseServer is
the name of the server that hosts the instance database.

If you omit the -server parameter, NSControl defaults to the local
server name.

How did you register your instance on the IIS box?

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)

tarpan

unread,

Jan 18, 2006, 2:48:43 PM1/18/06

to

nscontrol Crashes if I start it from remote location.

"Notification Services Command Prompt" shows
CMD.EXE was started with '\\jadm\c\Program Files\Microsoft SQL
Server\90\Notific
ationServices' as the current directory path. UNC paths
are not supported. Defaulting to Windows directory.
'C:\Program' is not recognized as an internal or external command,
operable program or batch file.

tarpan

unread,

Jan 18, 2006, 3:17:26 PM1/18/06

to

"Joe Webb" wrote:
> How did you register your instance on the IIS box?

I did not.
Do I have to?

How I can register it if nscontrol.exe does not exist on the IIS box?
Do I have to install the SQL 2005 just to run nscontrol.exe once? %-)
I have found that nscontrol does not work from remote location. :-(

Joe Webb

unread,

Jan 19, 2006, 6:18:19 AM1/19/06

to

From BOL:

"The nscontrol register command must be run locally. You cannot
register Notification Services on a remote server."

You need to install the NS client components on the IIS box and then
use NSControl to register the instance.

HTH...

Joe

--
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)

Joe Webb

unread,

Jan 19, 2006, 6:22:05 AM1/19/06

to

>Do I have to?
Yes. Otherwise the IIS box will not know of your instance.

>How I can register it if nscontrol.exe does not exist on the IIS box?

Install the NS Client components on the IIS box.

>Do I have to install the SQL 2005 just to run nscontrol.exe once? %-)

No, just the client components.

>I have found that nscontrol does not work from remote location. :-(

Right. It must be run locally.

Check out "Deploying a Subscription Management Interface" in 2005 BOL.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlntsv9/html/7854de6a-ade3-490d-bc85-5ef0e1c6c18c.htm

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)

tarpan

unread,

Jan 19, 2006, 2:13:03 PM1/19/06

to

Thank you very much.
Your answers are very helpful.