Microsoft SQL Server cannot be found on this computer (cannot create MS SQL database backup set)

ServosityPro: All
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.

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:

1. Open a command prompt
   
   
2. 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\ ...

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:

1. On the affected machine, right-click on My Computer
   
   
2. Select Properties
   
   
3. Select the Advanced tab
   
   Example:
   
   
   
4. Select Environment Variables
   
   
5. Under System variables section, scroll down to Path
   
   
6. Click on Edit
   
   
7. Specify the directory path which points to the OSQL.exe file:
   
   Example:
   C:\Program Files\Microsoft SQL Server\90\Tools\Binn
   
   
   
   
8. Restart the affected machine
   
   
9. Create the MS SQL database backup set afterward