| Groups | Blog | Home |
sql server notification services : NS does not work on named instance of the SQL Server.
Hi guys,
I have added one more named instance to my SQL Server and tried to use NS on it. I can not start the service. The "net use start ...." command shows the following message: Could not start the NS$ELSInstance service on Local Computer. The service did not return an error. This could be an internal windows error or an internal service error. If it problem persists, contact your system administrator. However, the nscontrol command creates the instance, registers and enables the service just fine. The created databases are available. Everything seems to be fine, I just can not start the service. The same appADF works just fine on the default instance of the SQL server on the same PC. %-) Who has the ideas? PS. Win 2000 SP4, SQL 2000 PPS.This thread is follow-up to the "Problem porting NS Application from SQL 2000 to SQL 2005" thread.
Tanks Joe, but...
[quoted text, click to view] > Does the account used by the service have appropriate database permissions to login to SQL Server? SQL User = "sa" No doubts about it's rights. Service User has administrative rights on the PC. [quoted text, click to view] >Does it have access to the master, instance, and application databases? "sa"? Yes.
Hi Tarpan -
When the NS$<InstanceName> service fails to start, the first thing I check is permissions. Does the account used by the service have appropriate database permissions to login to SQL Server? Does it have access to the master, instance, and application databases? Here's a thread that may help... http://groups-beta.google.com/group/microsoft.public.sqlserver.notificationsvcs/browse_thread/thread/bf64b8b0345f8743/0e50fb3e4600aae2?q=permissions&rnum=4&hl=en#0e50fb3e4600aae2 HTH... -- Joe Webb SQL Server MVP ~~~ 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, 24 May 2005 11:17:02 -0700, tarpan [quoted text, click to view] <tarpan@discussions.microsoft.com> wrote:
>Hi guys, > >I have added one more named instance to my SQL Server and tried to use NS on >it. I can not start the service. The "net use start ...." command shows the >following message: > >Could not start the NS$ELSInstance service on Local Computer. >The service did not return an error. This could be an internal windows error >or an internal service error. >If it problem persists, contact your system administrator. > >However, the nscontrol command creates the instance, registers and enables >the service just fine. The created databases are available. Everything seems >to be fine, I just can not start the service. > >The same appADF works just fine on the default instance of the SQL server on >the same PC. %-) > >Who has the ideas? > >PS. Win 2000 SP4, SQL 2000 >PPS.This thread is follow-up to the "Problem porting NS Application from SQL >2000 to SQL 2005" thread. > >Thanks
I have found something new. NS suppose to add one stored procedure to the
master db named "xp_NSPermissions_2_0_3008_0". It does not create it on the named instance for whatever reason. It causes the problem. PS. Once again, as a SQL user I use "sa". [quoted text, click to view] "Joe Webb" wrote:
> Hi Tarpan - > > When the NS$<InstanceName> service fails to start, the first thing I > check is permissions. Does the account used by the service have > appropriate database permissions to login to SQL Server? Does it have > access to the master, instance, and application databases? > > Here's a thread that may help... > http://groups-beta.google.com/group/microsoft.public.sqlserver.notificationsvcs/browse_thread/thread/bf64b8b0345f8743/0e50fb3e4600aae2?q=permissions&rnum=4&hl=en#0e50fb3e4600aae2 > > > > HTH... > > -- > Joe Webb > SQL Server MVP > > > ~~~ > 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, 24 May 2005 11:17:02 -0700, tarpan > <tarpan@discussions.microsoft.com> wrote: > > >Hi guys, > > > >I have added one more named instance to my SQL Server and tried to use NS on > >it. I can not start the service. The "net use start ...." command shows the > >following message: > > > >Could not start the NS$ELSInstance service on Local Computer. > >The service did not return an error. This could be an internal windows error > >or an internal service error. > >If it problem persists, contact your system administrator. > > > >However, the nscontrol command creates the instance, registers and enables > >the service just fine. The created databases are available. Everything seems > >to be fine, I just can not start the service. > > > >The same appADF works just fine on the default instance of the SQL server on > >the same PC. %-) > > > >Who has the ideas? > > > >PS. Win 2000 SP4, SQL 2000 > >PPS.This thread is follow-up to the "Problem porting NS Application from SQL > >2000 to SQL 2005" thread. > > > >Thanks >
Tarpan --
You must use the InstallXps script (in the NS "Bin" directory) to register NS extended stored procedures on the the server instance. Just to make sure we aren't looking in the wrong places, can you forward any event log errors you are receiving when launching the NS service against the named SQL instance? - 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. [quoted text, click to view] "tarpan" <tarpan@discussions.microsoft.com> wrote in message news:D872946A-7865-4D19-BBB5-B50D25E2E870@microsoft.com... >I have found something new. NS suppose to add one stored procedure to the > master db named "xp_NSPermissions_2_0_3008_0". It does not create it on > the > named instance for whatever reason. It causes the problem. > > PS. Once again, as a SQL user I use "sa". > > "Joe Webb" wrote: > >> Hi Tarpan - >> >> When the NS$<InstanceName> service fails to start, the first thing I >> check is permissions. Does the account used by the service have >> appropriate database permissions to login to SQL Server? Does it have >> access to the master, instance, and application databases? >> >> Here's a thread that may help... >> http://groups-beta.google.com/group/microsoft.public.sqlserver.notificationsvcs/browse_thread/thread/bf64b8b0345f8743/0e50fb3e4600aae2?q=permissions&rnum=4&hl=en#0e50fb3e4600aae2 >> >> >> >> HTH... >> >> -- >> Joe Webb >> SQL Server MVP >> >> >> ~~~ >> 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, 24 May 2005 11:17:02 -0700, tarpan >> <tarpan@discussions.microsoft.com> wrote: >> >> >Hi guys, >> > >> >I have added one more named instance to my SQL Server and tried to use >> >NS on >> >it. I can not start the service. The "net use start ...." command shows >> >the >> >following message: >> > >> >Could not start the NS$ELSInstance service on Local Computer. >> >The service did not return an error. This could be an internal windows >> >error >> >or an internal service error. >> >If it problem persists, contact your system administrator. >> > >> >However, the nscontrol command creates the instance, registers and >> >enables >> >the service just fine. The created databases are available. Everything >> >seems >> >to be fine, I just can not start the service. >> > >> >The same appADF works just fine on the default instance of the SQL >> >server on >> >the same PC. %-) >> > >> >Who has the ideas? >> > >> >PS. Win 2000 SP4, SQL 2000 >> >PPS.This thread is follow-up to the "Problem porting NS Application from >> >SQL >> >2000 to SQL 2005" thread. >> > >> >Thanks >> >>
Colin is correct. I should also point out that it's dangerous to use the sa
account to connect to the database server. You are granting the service way more permission that it needs, which is bad from a security standpoint. You should instead use a lower-privileged account and grant it database access to the NS databases and membership in the appropriate NS application roles. -shyam -- Learn more about SQL-NS: http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/ --------------------------------------------- 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. --------------------------------------------- [quoted text, click to view] "Colin Meek" <cmeek@alias.microsoft.com> wrote in message news:OO76$EUYFHA.2076@TK2MSFTNGP15.phx.gbl... > Tarpan -- > > You must use the InstallXps script (in the NS "Bin" directory) to register > NS extended stored procedures on the the server instance. > > Just to make sure we aren't looking in the wrong places, can you forward any > event log errors you are receiving when launching the NS service against the > named SQL instance? > > - 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. > > "tarpan" <tarpan@discussions.microsoft.com> wrote in message > news:D872946A-7865-4D19-BBB5-B50D25E2E870@microsoft.com... > >I have found something new. NS suppose to add one stored procedure to the > > master db named "xp_NSPermissions_2_0_3008_0". It does not create it on > > the > > named instance for whatever reason. It causes the problem. > > > > PS. Once again, as a SQL user I use "sa". > > > > "Joe Webb" wrote: > > > >> Hi Tarpan - > >> > >> When the NS$<InstanceName> service fails to start, the first thing I > >> check is permissions. Does the account used by the service have > >> appropriate database permissions to login to SQL Server? Does it have > >> access to the master, instance, and application databases? > >> > >> Here's a thread that may help... > >> http://groups-beta.google.com/group/microsoft.public.sqlserver.notificationsvcs/browse_thread/thread/bf64b8b0345f8743/0e50fb3e4600aae2?q=permissions&rnum=4&hl=en#0e50fb3e4600aae2 > >> > >> > >> > >> HTH... > >> > >> -- > >> Joe Webb > >> SQL Server MVP > >> > >> > >> ~~~ > >> 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, 24 May 2005 11:17:02 -0700, tarpan > >> <tarpan@discussions.microsoft.com> wrote: > >> > >> >Hi guys, > >> > > >> >I have added one more named instance to my SQL Server and tried to use > >> >NS on > >> >it. I can not start the service. The "net use start ...." command shows > >> >the > >> >following message: > >> > > >> >Could not start the NS$ELSInstance service on Local Computer. > >> >The service did not return an error. This could be an internal windows > >> >error > >> >or an internal service error. > >> >If it problem persists, contact your system administrator. > >> > > >> >However, the nscontrol command creates the instance, registers and > >> >enables > >> >the service just fine. The created databases are available. Everything > >> >seems > >> >to be fine, I just can not start the service. > >> > > >> >The same appADF works just fine on the default instance of the SQL > >> >server on > >> >the same PC. %-) > >> > > >> >Who has the ideas? > >> > > >> >PS. Win 2000 SP4, SQL 2000 > >> >PPS.This thread is follow-up to the "Problem porting NS Application from > >> >SQL > >> >2000 to SQL 2005" thread. > >> > > >> >Thanks > >> > >> > >
Yeaaaaa!
You are my Hero! Thanks. [quoted text, click to view] "Colin Meek" wrote:
> Tarpan -- > > You must use the InstallXps script (in the NS "Bin" directory) to register > NS extended stored procedures on the the server instance. > > Just to make sure we aren't looking in the wrong places, can you forward any > event log errors you are receiving when launching the NS service against the > named SQL instance? > > - 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. > > "tarpan" <tarpan@discussions.microsoft.com> wrote in message > news:D872946A-7865-4D19-BBB5-B50D25E2E870@microsoft.com... > >I have found something new. NS suppose to add one stored procedure to the > > master db named "xp_NSPermissions_2_0_3008_0". It does not create it on > > the > > named instance for whatever reason. It causes the problem. > > > > PS. Once again, as a SQL user I use "sa". > > > > "Joe Webb" wrote: > > > >> Hi Tarpan - > >> > >> When the NS$<InstanceName> service fails to start, the first thing I > >> check is permissions. Does the account used by the service have > >> appropriate database permissions to login to SQL Server? Does it have > >> access to the master, instance, and application databases? > >> > >> Here's a thread that may help... > >> http://groups-beta.google.com/group/microsoft.public.sqlserver.notificationsvcs/browse_thread/thread/bf64b8b0345f8743/0e50fb3e4600aae2?q=permissions&rnum=4&hl=en#0e50fb3e4600aae2 > >> > >> > >> > >> HTH... > >> > >> -- > >> Joe Webb > >> SQL Server MVP > >> > >> > >> ~~~ > >> 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, 24 May 2005 11:17:02 -0700, tarpan > >> <tarpan@discussions.microsoft.com> wrote: > >> > >> >Hi guys, > >> > > >> >I have added one more named instance to my SQL Server and tried to use > >> >NS on > >> >it. I can not start the service. The "net use start ...." command shows > >> >the > >> >following message: > >> > > >> >Could not start the NS$ELSInstance service on Local Computer. > >> >The service did not return an error. This could be an internal windows > >> >error > >> >or an internal service error. > >> >If it problem persists, contact your system administrator. > >> > > >> >However, the nscontrol command creates the instance, registers and > >> >enables > >> >the service just fine. The created databases are available. Everything > >> >seems > >> >to be fine, I just can not start the service. > >> > > >> >The same appADF works just fine on the default instance of the SQL > >> >server on > >> >the same PC. %-) > >> > > >> >Who has the ideas? > >> > > >> >PS. Win 2000 SP4, SQL 2000 > >> >PPS.This thread is follow-up to the "Problem porting NS Application from > >> >SQL > >> >2000 to SQL 2005" thread. > >> > > >> >Thanks > >> > >> > >
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 |