Learn more about SQL Server tools



solving sql server problems for millions of dbas and developers since 2006 join MSSQLTips for free SQL Server tips













































   Got a SQL tip?
            We want to know!

Windows cannot access the specified device, path or file error

MSSQLTips author Jeremy Kadlec By:   |   Read Comments (2)   |   Related Tips: More > Security

Problem
Every time I try to execute an executable (*.exe) file that I copied from a Windows 2003 File Server to my SQL Server running Windows 2003, I am unable to access the file.  It works without a problem on the original Windows 2003 File Server and I am able to validate that nothing has changed.  I just keep getting this error message - Windows cannot access the specified device, path or file.  How can I resolve this issue?  What am I doing wrong?  I am just copying a file to my SQL Server.

Solution
In Windows 2003 when you copy an executable (*.exe) file, the file now has a blocked property.  This is a security feature that can easily be resolved by reviewing the file properties and clicking the 'Unblock' button to disable the security feature.  In the first image below the 'Unblock' button is present with the text of - 'This file came from another computer and might be blocked to help protect this computer'.  Once you click the 'Unblock' button you can now access and run the executable (*.exe) file.  In addition, the 'Unblock' button and text disappear as shown in the second image.

Original File Properties Window

 

Updated File Properties Window

 

Next Steps

  • Just be aware of this feature in Windows 2003 and be sure to unblock the executable (*.exe) files when needed.
  • If you are copying files as a portion of an automated SQL Server process be sure to test the process thoroughly to ensure the file has not been blocked due to security restrictions.
  • For additional security related tips, check out the MSSQLTips.com security category.


Last Update: 6/11/2007


About the author
MSSQLTips author Jeremy Kadlec
Jeremy Kadlec is the CTO @ Edgewood Solutions, co-founder of MSSQLTips.com, Baltimore SSUG co-leader and SQL Server MVP since 2009.

View all my tips
Related Resources


print tip Print  
Become a paid author





join MSSQLTips for free SQL Server tips     



Learn more about SQL Server tools
Comments and Feedback:
Sunday, May 11, 2008 - 10:31:54 PM - belong Read The Tip

Thank you for such an explicit answer. I have carried out the above procedure and the text and "unblock" have disappeared from the properties /general menu. I am  running Windows XP and am Administrator user trying to run exe. file for AVG 75 free download to install it. I still get the "Windows cannot access" notice. Tried restart but no joy and properties still has "unblocked" and text removed.


Saturday, August 09, 2008 - 9:04:22 AM - Sultan Read The Tip

 1. It all started after installing AVG 7.00 Free in my BASIS PC@saturn on the 6h August 2008

2. The symptoms were:
    a) No EXE runs except explorer, notepad, windows management files, command window
    b) Does not boot in safe mode, rather restarts
    c) When clicks on an EXE it gives the message "Windows cannot access the specified device, path or file. You May not     

    have the appropriate permission"
    d) Network card is dis-connected
    e) Windows firewall is on and never goes off
    f) Some viruses are active
Solution:
    a) I first started to delete the virus files
    b) Visited forum after forums but could not find match for my problem
    c) I Fixed the firewall by restoring default from advanced tab. Try this         

"http://answers.yahoo.com/question/index?qid=20080619095356AAUnB3m"
    d) The biggest point is to delete all the avg .exe files. One .dll was not removing. I had to go to registry and     

    remove all its references and problem was solved. All the EXE files are running now normally.

    I am now in search of the reason that AVG blocks an EXE.



Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name   *Email Notify for updates



Comments
Get free SQL tips:

*Enter Code refresh code


 
Sponsor Information







Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | free t-shirt | user groups | community | events | first timer?
Some names and products listed are the registered trademarks of their respective owners.