- Product Version:
- Problem Description:
- Cause:
- Open a command prompt
- Enter the command:
Example:
>path
PATH=C:\Program Files\Windows Resource Kits\Tools\;C:\WINDOWS\system32;C:\WINDOW S;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft Visual Studio 8\Common7\ID E\PrivateAssemblies\ ... - Resolution:
- On the affected machine, right-click on My Computer
- Select Properties
- Select the Advanced tab
Example:
- Select Environment Variables
- Under System variables section, scroll down to Path
- Click on Edit
- Specify the directory path which points to the OSQL.exe file:
Example:
C:\Program Files\Microsoft SQL Server\90\Tools\Binn
- Restart the affected machine
- Create the MS SQL database backup set afterward
ServosityPro: All
OS: Windows
OS: Windows
When creating a MS SQL database backup set on a MS SQL database server, the following error message is received in the ServosityPro console:
Microsoft SQL Server cannot be found on this computer!
Example:
Upon further investigation, when the osql command is entered in the command prompt, the following error message is recieved:
Example:
>osql -L
'osql' is not recognized as an internal or external command,
operable program or batch file.
Microsoft SQL Server cannot be found on this computer!
Example:
Upon further investigation, when the osql command is entered in the command prompt, the following error message is recieved:
Example:
>osql -L
'osql' is not recognized as an internal or external command,
operable program or batch file.
The message suggests that the environment variable path for osql is missing.
Notes:
You can verify if the environment variable path for osql has been entered by following the instructions below:
Notes:
You can verify if the environment variable path for osql has been entered by following the instructions below:
To resolve the issue, please specify the full directory path to the Binn directory (within the MS SQL installation folder), where OSQL.exe file reside: