Skip to content

Commit b589000

Browse files
authored
Merge pull request #22374 from MashaMSFT/2022_lsaccessfix
added remote access info
2 parents 3dad7d4 + fffe4c3 commit b589000

2 files changed

Lines changed: 5 additions & 0 deletions

File tree

docs/database-engine/configure-windows/configure-the-remote-access-server-configuration-option.md

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -57,6 +57,8 @@ The default value for the **remote access** option is **1** (enabled). This gran
5757

5858
This setting doesn't take effect until you restart [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)].
5959

60+
Remote access is required for the log shipping status report in SQL Server Management Studio (SSMS) to work and the LSAlert Job to complete appropriately.
61+
6062
## Permissions
6163

6264
Execute permissions on **sp_configure** with no parameters or with only the first parameter are granted to all users by default. To execute **sp_configure** with both parameters to change a configuration option or to run the RECONFIGURE statement, a user must be granted the ALTER SETTINGS server-level permission. The ALTER SETTINGS permission is implicitly held by the **sysadmin** and **serveradmin** fixed server roles.

docs/database-engine/log-shipping/view-the-log-shipping-report-sql-server-management-studio.md

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -41,6 +41,9 @@ ms.author: mikeray
4141
2. Right-click the server instance in Object Explorer, point to **Reports**, and point to **Standard Reports**.
4242

4343
3. Click **Transaction Log Shipping Status**.
44+
45+
> [!NOTE]
46+
> [Remote access](../configure-windows/configure-the-remote-access-server-configuration-option.md) is required for the log shipping status report in SQL Server Management Studio (SSMS) to work.
4447
4548
## See Also
4649
[Monitor Log Shipping (Transact-SQL)](../../database-engine/log-shipping/monitor-log-shipping-transact-sql.md)

0 commit comments

Comments
 (0)