Author: Craig Floyd
How to access AWS backup location within SQL Server Management Studio
Issue: Unable to access AWS network backup location
.
Resolution:
- Remote into the desired AWS SQL Server
- Launch Microsoft SQL Server Management Studio
- Click -> File -> Connect Object Explorer
- Select the Server Name -> Select “Windows Authentication” for the “Authentication” Field
- In the “Object Explorer”, right-click the Database -> Click “New Query”
- Copy and Paste in the Query Window one step at a time
**Do not copy the --Step sentence, only the commands in between**- --Step 1 To allow advanced options to be changed.
EXECUTE sp_configure 'show advanced options', 1;
GO
--Step 2 To update the currently configured value for advanced options.
RECONFIGURE;
GO
--Step 3 To enable the feature.
EXECUTE sp_configure 'xp_cmdshell', 1;
GO
--Step 4 To update the currently configured value for this feature.
RECONFIGURE;
GO
--Step 5
EXEC XP_CMDSHELL 'net use S: \\172.31.23.242\msp-bold-sedonaoffice "RETRIEVE PW FROM LP" /user:sgw-EE987687\smbguest'
- --Step 1 To allow advanced options to be changed.
- Click “Execute”
