Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "how to solve the problem that SQL Server prevents sys.xp_cmdshell from accessing". In the operation of actual cases, many people will encounter such a dilemma. Then let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Execute:

Exec master..xp_cmdshell 'net use\\ 192.168.60.175\ bak xxxx@ / user:192.168.60.175\ db'

Error report:

Message 15281, level 16, status 1, procedure xp_cmdshell, line 1

SQL Server blocked access to the process "sys.xp_cmdshell" of the component "xp_cmdshell" because the component has been shut down as part of the security configuration of this server. The system administrator can enable "xp_cmdshell" by using sp_configure. For more information about enabling xp_cmdshell, search for "xp_cmdshell" in SQL Server Books online.

Message 3201, level 16, status 1, line 11

Unable to open backup device'\ 192.168.60.175\ bak\ Offline_20191113.bak'. Operating system error 5 (access denied.) .

Message 3013, level 16, status 1, line 11

BACKUP DATABASE is terminating abnormally.

Open xp_cmdshell:

Sp_configure 'show advanced options',1

Reconfigure

Go

Sp_configure 'xp_cmdshell',1

Reconfigure

Go

Problem solved.

This is the end of the content of "how to solve the problem that SQL Server blocks access to sys.xp_cmdshell". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.