| title | Designate an Events Forwarding Server (SQL Server Management Studio) | Microsoft Docs | |||
|---|---|---|---|---|
| ms.custom | ||||
| ms.date | 03/06/2017 | |||
| ms.prod | sql-server-2014 | |||
| ms.reviewer | ||||
| ms.technology | ssms | |||
| ms.topic | conceptual | |||
| helpviewer_keywords |
|
|||
| ms.assetid | 81dfcbe4-3000-4e77-99de-bf85fef63a12 | |||
| author | stevestein | |||
| ms.author | sstein | |||
| manager | craigg |
This topic describes how to designate a server to which [!INCLUDEmsCoName] [!INCLUDEssNoVersion] forwards events in [!INCLUDEssCurrent] by using [!INCLUDEssManStudioFull] . Note that event forwarding applies to events forwarded between servers, not to events forwarded between instances of [!INCLUDEssNoVersion] hosted on a single computer. Also note that in order to receive forwarded events, the alerts management server must be a default instance of SQL Server.
In This Topic
-
Before you begin:
-
To designate an events forwarding server, using:
Requires membership in the sysadmin fixed server role.
-
In Object Explorer, click the plus sign to expand the server from which you want to forward events to another server.
-
Right-click SQL Server Agent and select Properties.
-
In the SQL Server Agent Properties -server_name dialog box, under Select a page, select Advanced.
-
Under SQL Server event forwarding, select the Forward events to a different server check box.
-
In the Server list, select a server, and then, under Events, select one of the following:
-
Select Unhandled events to forward only the events that have not been handled by local alerts.
-
Select All events to forward all events regardless of whether they have been handled by local alerts.
-
-
In the If event has severity at or above list, click the severity level at which events are forwarded to the selected server.
-
When finished, click OK.