Registering the Mapped Network Path on SQL Server Management Studio

You, you need to register the mapped network path on the SQL Server Management Studio in order to be able to access the mapped drive from SQL Server Management Studio File Explorer. To do so, open SQL Server Management Studio and execute the query below.

EXEC sp_configure ‘show advanced options’, 1
GO
RECONFIGURE
GO
EXEC sp_configure ‘xp_cmdshell’, 1
GO
RECONFIGURE
GO

EXEC XP_CMDSHELL ‘net use N: /delete’
EXEC XP_CMDSHELL ‘net use N: \\ServerName\DB-Backup-ShareName’
EXEC XP_CMDSHELL ‘Dir N:’

Advertisements