0

I'm working with a vendor about this, but a supplied script that they have to run to upgrade their software, after running, ruins access to SQLCMD.

Before running the script I can open a Command Prompt window > SQLCMD > Drops me in.

After running their scripts, when attempting to do the same thing, get the error: Access is Denied

I've tried dropping a copy of SQLCMD.exe from a known good working server into same location where the affected server was, but even trying to manually invoke it from the location, receive a: "Windows cannot access the specified device, path, or file. You may not have the appropriate permissions to access the item".

Going to permissions > Security, it has all the same permissions as the known good working file, as is the entire directory path. So obviously osmething deeper, but I cannot / do not know where to start to diagnose.

Improve this question
8
  • What kind of script?...T-SQL? If so, then that would be where to start but it would be unlikely any pure T-SQL script is affecting Windows permissions for SQLCMD. Commented Oct 22, 2023 at 2:53
  • Honestly, I don't know. All I know is that the script calls for SQLCMD to connect to the database after providing all the connection details. Commented Oct 23, 2023 at 12:16
  • The vendor provided you a script and you don't know what kind of script (or even the file type of it) is? Commented Oct 23, 2023 at 12:22
  • It's a .bat file that calls other .bat files which call other .bat files which all run SQLCMDs. I know enough of the basics to know some of what they're doing but SQL isn't my bread and butter. Commented Oct 23, 2023 at 12:37
  • 1
    Yeah. The ONLY fix I've found so far, has been as OS Upgrade... Commented Oct 24, 2023 at 18:08

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.