I have Inherited) a W2003 Server which has Great Plains (accounting) software installed.
It as well has SQL Server 2005 installed locally, however the databases (including Master) were installed on a no longer accessible SAN.
I have backup (.BAK) files of Master and the databases I need to restore, however since none are installed on the actual SQL Server it will not allow me to even open SQL to perform the restores.
Temporarily to get access to the data I'm going to build a new SQL Server however we need to access the data through Great Plains.
Any suggestions as to how to get the instance of SQL back on the original server?