I have to move SIMS and have successfully got SIMS installed on new server but cannot get MSSQL Server 2008 x64 to install. I am running Win 2003 R2 64bit on the server.
All posts I can find on here or elsewhere don't seem to help!
I managed to remove most problems by running a repair several times via Control Panel Add/remove Programs but end up with actual SQL Server not starting with this error:
The credentials you provided for the Integration Services service are invalid. To continue, provide a valid account and password for the Integration Services service.
Also get SQL Server Error Code: 17058 - again googling that hasn't provided any solution that helps!
Have tried reinstalling SQL 2008 as I found one post that says to not let it autorun but to right click & run as administrator - made not a jot of difference!
Where the h3ll do you provide an account & password for that???
BTW, I'm no expert in SQL server - just know the very basic fundamentals!! Also, not very familiar with SIMS for that matter - only been in this environment since after Oct half term - was in IBM previously!
I need to fix this VERY URGENTLY as we have to trash our current server in a few days as it's been potentially contaminated with asbestos!! (Long story!)
Oops, sorry posted that last reply without answering about when the error occurred:
Error occurred after but the install reported errors, most of which were fixed by doing the repairs via Add/Remove programs.
OK, I've just removed every vestage of SQL Server and am re-installing. It gets all the way thru without any problems says all installations rules passed but then falls on it's face! I will wait for this install to finish and if it's still not working will try again with your suggestion.