Subscription Management Interface Considerations
Subscription management interfaces are external to Microsoft SQLÂ Server Notification Services, but they use the Notification Services API to create and modify subscriber and subscription data. A subscription management interface can be a Web application or a Microsoft Windows application. The only requirement is that the interface must use the subscription management objects that Notification Services provides.
Not all notification applications use subscription management interfaces. For example, some applications contain a relatively stable set of subscribers and subscriptions, making a subscription management unnecessary.
A subscription management interface can be located on the database server or on a separate server. If your subscription management interface is for internal use only, such as an intranet-based application, locating the interface on the database server might be an adequate solution. However, do not put the subscription management interface on the database server if the interface is publicly available.
The subscription management interface must have access to the instance database and application databases in order to read and write subscriber and subscription data. To connect to SQL Server, the interface can use Windows Authentication or SQL Server Authentication. We recommend Windows Authentication because it is more secure and easier to manage.
See Also
Concepts
Deploying a Subscription Management Interface
Planning a Notification Services System
Other Resources
Developing Subscription Management Interfaces