SIMS Installer couldn't detect a valid SQL instance.
I am trying to migrate SIMS from a 2003 server to a 2008 server.
I have copied all the files to the new server. I am now trying to install SQL so I can re-attach the database.
When I run simsinst.exe, everything seems to go ok. The SQL part completes with no errors. However, I then get the error "SIMS Installer couldn't detect a valid SQL instance. Please re-run SIMSInst.exe to setup your SIMS SQL Server."
There does appear to be a "SQL Server (SIMS2008)" service, which suggests that the SQL install worked ok.