MS SQL required for application. Installed but application complains- how to check MS SQL?
Posted on 2011-09-30
I am trying to install a new application on a Windows Server 2008 R2 server that uses MS SQL but am having problems. I'm not that knowledgeable about MSSQL and the particular application is quite unique with poor documentation.
The issue is during installation of the application we get this error:
The APPLICATION database has been selected to be installed but a SQL Server has not been detected on this machine.
(where application is the name of the application not mentioned at this point because of its uniqueness )
On the Windows server we have MS SQL 2008 Standard edition installed although we did not ourselves install this. This was installed because SAGE is being installed on the server and needed Standard edition and the Sage people installed it.
SAGE is not yet live however so I'm not 100% SQL is fully prepped although I am able to start SQL Server Management Studio.
My question: What can I check on the SQL server to make sure it is all ready and therefore address the error that is being reported.
The documentation for the "APPLICATION" is very dated and it assumes you will be using SQL Express and goes through the installation guide for this before you install "APPLICATION", however in this case I have a situation where MS SQL Standard should already be installed.
Any suggestions on what I can check? Much appreciated any help.
Would it be wise and is it possible to have a separate installation on MSSQL Express on the same server ? (but seems silly to have to do so)