We went to try to install Microsoft SQL Server 2008 R2 onto a clients server (2008 R2 is the version the client has a license for). We discovered that SQL 2008 (not R2) had already been installed. When we went to run SQL Server Manager, we found that the SQL Server directory on the C:\ drive had been deleted. Both SQL Server Manager and SQL Browser will not run because the directory had been deleted. We went to install 2008 R2 - SQL database installed but SQL Server Manager would not install saying that an earlier version had been installed. We went to try to start SQL Browser again, but it did not re-install either and will not run because the file is still missing.
Another problem is that they have SharePoint running on the SQL database that is installed. We thought about re-installing SQL server but how will this affect the instance of SharePoint?
We suggested that they have a separate computer to run SQL Server but "they didn't like the idea."
Any suggestions on how to recover the installation without affecting/destroying their instance of SharePoint?
Thanks very much for any suggestions!