Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 8th, 2005, 10:04 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default 2005 Notification Services Not Disabling

Hello,

I'm following the tutorial for setting up notification services, available here: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqltut9/html/44aa0556-b9c2-48f5-8775-134bbe0b90aa.htm. Where it says:

Update the Instance of Notification Services
After you modify the ADF, you update the instance of Notification Services to add event class objects to the application database:

In Object Explorer, expand Notification Services.
Right-click Tutorial, point to Tasks, and then select Update.
In the Update Instance dialog, click Browse, browse to the TutorialICF.xml file, and then click Open.
In the Parameters grid, enter values for the _ServerName_, _DBEngineInstance_, and _InstancePath_ parameters. Use the same values you used to create the instance.
Click OK.
Review the Notification Services - Update Summary dialog box, and then click Update.
When the update actions complete, click Close.


I'm getting the error: The instance must be disabled before it can be updated or upgraded. I figured how to disable it, but whenever I disable all the services, it keeps enabling the application portion, which then doesn't allow me to upgrade! Why is that? How do I disable the application?

Thanks.

Brian
__________________
Brian
 
Old August 8th, 2005, 10:08 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Nevermind, the instructions show to go to properties > Applications, then disable there, but the master disable in the context menu for the notification service works.

Brian





Similar Threads
Thread Thread Starter Forum Replies Last Post
Embedded code in Reporting Services 2005 gunjan.sh C# 2005 1 February 19th, 2008 09:04 AM
SQL 2005 reporting services on vista praveenb Reporting Services 0 April 9th, 2007 04:45 PM
Multivalue parameter Reporting Services 2005 aldwinenriquez Reporting Services 2 January 11th, 2007 03:41 PM
sql server 2005 analysis services venkatesh kumar SQL Server 2005 2 January 5th, 2007 02:43 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.