Share via

SQL server Troubleshooting: cannot open Backup device - Error 1326 (DMA)

  • Article

Database Migration Assistance

While Getting the Following  error  :  Operating system error 1326

Step 1:  To enable xp_cmdshell  using the following to execute on SSMS    (ref: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/xp-cmdshell-server-configuration-option?view=sql-server-2017)

                -- To allow advanced options to be changed. 

EXEC sp_configure 'show advanced options', 1; 
 
GO 
 
-- To update the currently configured value for advanced options. 
 
RECONFIGURE; 
 
GO 
 
-- To enable the feature. 
 
EXEC sp_configure 'xp_cmdshell', 1; 
 
GO 
 
-- To update the currently configured value for this feature. 
 
RECONFIGURE; 
 
GO

Step 2:  Map the drive using the following

EXEC XP_CMDSHELL 'net use X: <\\networkpath> password /User:domain\username'
 
Step 3: Check  the Map drive connected on SQL
 
EXEC XP_CMDSHELL 'dir X:\'