Problems Installing SQL Server 2008 64Bit

[GreenICT]

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!)

[Domino]

Couple of questions may be relevant here:

 

Is the server performing any other role (IE DC, etc)?

Is it fully patched to the latest service pack?

 

Also the integration service error? did it occur during install or after? Was it a local or domain account you set it to run as in the installer?

Edited July 4, 2012 by Domino

[GreenICT]

It's running on a DC (we've no choice at the moment!)

All MS updates are applied and I've checked the installation requirements and as far as I can see we have all hardware & software requirements.

[GreenICT]

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.

 

Running it as domain administrator account

[Mcshammer_dj]

what format are you using for the account when you enter the details. ie are you filling this in ad domain\administrator and then the password Edited July 4, 2012 by Mcshammer_dj

[GreenICT]

Yes, I have given domain\account and password

[Mcshammer_dj]

try NT AUTHORITY\LOCAL SERVICE with no password

[GreenICT]

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.

 

Many thanks for your time and help!

[GreenICT]

If this means anything - this is the error at the end of the Install:-

 

TITLE: Microsoft SQL Server 2008 Setup

------------------------------

 

The following error has occurred:

 

The specified user group 'SQLServerMSSQLUser$server1$MSSQLSERVER' does not exist.

 

For help, click: Source: ID: ( ) - Events And Errors Message Center: Message Details THIS LINK JUST SAYS THERE'S NO INFORMATION!!

[Domino]

try NT AUTHORITY\LOCAL SERVICE with no password

 

You can't use a local service as the running account when it's installed on a dc see: You may encounter problems when installing SQL Server on a domain controller and Hardware and Software Requirements for Installing SQL Server 2012 (the Installing SQL Server on a Domain Controller section) Probably why it failed before as a DC treats the domainadmin account as it's local admin.

 

Try making a new AD account for it to run as.

[GreenICT]

OK, I have uninstalled (yet again!) and reinstalled after creating a new ID - hey presto -t it works fine!

 

Thanks for all your suggestions. It would be helpful during the install to say you need a different account rather than just giving a warning to say they don't recommend installing on a DC!

Edited July 5, 2012 by GreenICT
additional comment