As a developer, I had our systems team setup a VM of a server to practice an upgrade of an old third party application. This server has its own instance of SQL Server 2000 that's used exclusively for this application.
When I started up SQL Server Enterprise Manager, I was unable to connect to the local server. The error read:
An error 3 - (The system cannot find the path specified) occurred while performing this service operation on the MSSQLServer service.
At first, I thought the new name and IP address of the server required to put the VM on the network might be contributing. However, I looked at the service, and it had not started. Trying to start it manually gives the same error.
I tried putting the executable path of the service into the address bar of Windows Explorer
but got the error:
Cannot find 'file:///C:/PROGRA~1/MI6841~1/MSSQL/binn/'. Make sure the path or Internet address is correct.
When I do the same thing on the physical server (paste the path into Windows Explorer) it opens the folder just fine.
For some reason, the VM seems to be having problems recognizing the DOS compatible paths.
Any ideas on how to resolve this?
EDIT: The file and path do exist and the full path is:
C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe
SQL Server is not running, because this is the service that is trying to start. You get the same error if you manually try to start the service.