|
|
You're in the
sql server notification services
group:How to access NS remotly?
sql server notification services:
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
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) On Tue, 17 Jan 2006 13:56:04 -0800, tarpan [quoted text, click to view] <tarpan@discussions.microsoft.com> wrote:
>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
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. [quoted text, click to view] "Joe Webb" wrote:
> 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) > > > > > On Tue, 17 Jan 2006 13:56:04 -0800, tarpan > <tarpan@discussions.microsoft.com> wrote: > > >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 > >
[quoted text, click to view]
"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? %-)
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) On Wed, 18 Jan 2006 11:48:43 -0800, tarpan [quoted text, click to view] <tarpan@discussions.microsoft.com> wrote:
>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. > > > >"Joe Webb" wrote: > >> 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) >> >> >> >> >> On Tue, 17 Jan 2006 13:56:04 -0800, tarpan >> <tarpan@discussions.microsoft.com> wrote: >> >> >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 >> >
[quoted text, click to view]
>Do I have to? Yes. Otherwise the IIS box will not know of your instance.[quoted text, click to view] >How I can register it if nscontrol.exe does not exist on the IIS box? Install the NS Client components on the IIS box. [quoted text, click to view] >Do I have to install the SQL 2005 just to run nscontrol.exe once? %-) No, just the client components.[quoted text, click to view] >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) On Wed, 18 Jan 2006 12:17:26 -0800, tarpan [quoted text, click to view] <tarpan@discussions.microsoft.com> wrote:
>"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? %-)
Thank you very much.
Your answers are very helpful. [quoted text, click to view] "Joe Webb" wrote:
> >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) > > > > > > On Wed, 18 Jan 2006 12:17:26 -0800, tarpan > <tarpan@discussions.microsoft.com> wrote: > > >"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. :-(
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |