The drive is disconnected, and I'm off the network. How do I unmap the drive?
This seems like it should be a simple procedure, but I'm missing something. My Google-fu is weak today...
I can't test this here as I'm not on a network, but I think it's a case of doing this:
I think it's something like that but as I say, I can't test it here.
On the command line, try:
This shows all currently mapped drives. If the one you're looking for is in the list, you can use:
where X: is the drive you're trying to remove. But if the drive has been removed, there may be no such drive letter shown. In that case, just type the Remote identifier for the mapping:
For the disconnected drive, for those who have SQL Server Management Studio in your pc, just run this query.
Exec master.dbo.xp_cmdshell 'net use x: /delete'
** change the 'x' according to the drive name.. ** not sure if it will work with other database.. ** if your xp_cmdshell is not working or inactive, and this error occurs:
" SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online."
****Enable the xp_cmdshell by run this query**
-- 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