+ Post New Thread
Results 1 to 11 of 11
Windows Server 2000/2003 Thread, Problems Installing SQL Server 2008 64Bit in Technical; I have to move SIMS and have successfully got SIMS installed on new server but cannot get MSSQL Server 2008 ...
  1. #1

    Join Date
    Jul 2007
    Posts
    16
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Angry Problems Installing SQL Server 2008 64Bit

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

  2. #2

    Domino's Avatar
    Join Date
    Oct 2006
    Location
    Bromley
    Posts
    4,124
    Thank Post
    217
    Thanked 1,353 Times in 826 Posts
    Blog Entries
    4
    Rep Power
    528
    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?
    Last edited by Domino; 4th July 2012 at 11:59 AM.

  3. #3

    Join Date
    Jul 2007
    Posts
    16
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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.

  4. #4

    Join Date
    Jul 2007
    Posts
    16
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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

  5. #5
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    990
    Thank Post
    38
    Thanked 180 Times in 145 Posts
    Rep Power
    97
    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
    Last edited by Mcshammer_dj; 4th July 2012 at 01:11 PM.

  6. #6

    Join Date
    Jul 2007
    Posts
    16
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Yes, I have given domain\account and password

  7. #7
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    990
    Thank Post
    38
    Thanked 180 Times in 145 Posts
    Rep Power
    97
    try NT AUTHORITY\LOCAL SERVICE with no password

  8. Thanks to Mcshammer_dj from:

    GreenICT (4th July 2012)

  9. #8

    Join Date
    Jul 2007
    Posts
    16
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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!

  10. #9

    Join Date
    Jul 2007
    Posts
    16
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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!!

  11. #10

    Domino's Avatar
    Join Date
    Oct 2006
    Location
    Bromley
    Posts
    4,124
    Thank Post
    217
    Thanked 1,353 Times in 826 Posts
    Blog Entries
    4
    Rep Power
    528
    Quote Originally Posted by Mcshammer_dj View Post
    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.

  12. Thanks to Domino from:

    GreenICT (5th July 2012)

  13. #11

    Join Date
    Jul 2007
    Posts
    16
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Thumbs up Thanks everyone!

    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!
    Last edited by GreenICT; 5th July 2012 at 02:18 PM. Reason: additional comment



SHARE:
+ Post New Thread

Similar Threads

  1. Moodle / Server 2008 / IIS7 / MS SQL Server 2008 Express
    By Kamran7860 in forum Virtual Learning Platforms
    Replies: 3
    Last Post: 23rd November 2010, 07:03 AM
  2. Server 2008 - 64bit or not?
    By witch in forum Windows Server 2000/2003
    Replies: 16
    Last Post: 25th June 2009, 01:30 AM
  3. Installing SIMS.net on Windows Server 2008 64bit
    By mattstevenson2005 in forum MIS Systems
    Replies: 10
    Last Post: 7th March 2009, 09:08 PM
  4. SQL Server 2008 Maintenance course
    By googlemad in forum Courses and Training
    Replies: 0
    Last Post: 25th January 2009, 11:12 PM
  5. Problems installing SQL 2005 for SIMS
    By timbo343 in forum Windows
    Replies: 6
    Last Post: 7th November 2007, 11:27 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •