To add a Mapped drive in SQL Server, we have enable xp_cmdshell ,which can be configured by using a syntax as below

sp_configure ‘xp_cmdshell’,1

Then run the below script in the SQL Server Management Studio


in the script  z: is the name of the mapped drive , and \192.192.600.299shared is the physical path of the mapped drive.when a mapped drive is you can see the drive as below

Leave a Reply

Your email address will not be published. Required fields are marked *