+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 17
MIS Systems Thread, SIMS Installer couldn't detect a valid SQL instance [Solved] in Technical; Hi, our school's just bought a new admin server and my plan was to run SIMSInst.exe to set it up ...
  1. #1

    Join Date
    Sep 2009
    Location
    South West
    Posts
    24
    Thank Post
    13
    Thanked 2 Times in 2 Posts
    Rep Power
    11

    Thumbs down SIMS Installer couldn't detect a valid SQL instance [Solved]

    Hi, our school's just bought a new admin server and my plan was to run SIMSInst.exe to set it up as a new server, then copy the database across from the old server - (most posts in this forum support this). However, when setting up SIMS on the new server I get the following message after it runs SQL Express 2008 Setup: SIMS Installer couldn't detect a valid SQL Instance. Please re-run SIMSInst.exe to set up your SIMS SQL server.

    I've tried running SIMSInst again and now have 3 SQL instances set up but still get this message!! Any ideas? I'm using Server 2008 R2, which Capita (supposedly) supports.

  2. #2

    Join Date
    Apr 2010
    Posts
    2,104
    Thank Post
    95
    Thanked 189 Times in 156 Posts
    Rep Power
    84
    Are you filling in the config page, link found on first page during install?

  3. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,450
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Have you enabled TCP\IP in Sql Server Configuration Manager > SQL Server Network Configuration > Protocols

    Quote Originally Posted by harryeds View Post
    I'm using Server 2008 R2,
    Do they now?

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,788
    Thank Post
    716
    Thanked 1,441 Times in 1,194 Posts
    Rep Power
    360
    Don't you create the instance you want to install on first yourself? It has to be a named instance, not a default / unnamed one.

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,788
    Thank Post
    716
    Thanked 1,441 Times in 1,194 Posts
    Rep Power
    360
    Quote Originally Posted by matt40k View Post
    Have you enabled TCP\IP in Sql Server Configuration Manager > SQL Server Network Configuration > Protocols



    Do they now?
    Autumn 2010 wasn't it? Or did i read it wrong and it's Spring, along with all the other cool and funky stuff.

    EDIT: Yep, Autumn 2010 sees the commencement of support for windows 7 64 bit and windows server 2008 R2 64 bit (from roadmap 2010 #16472)

    EDIT2: We are talking about Windows server not SQL server aren't we??
    Last edited by vikpaw; 28th January 2011 at 11:19 AM. Reason: addition

  6. #6

    Join Date
    Sep 2009
    Location
    South West
    Posts
    24
    Thank Post
    13
    Thanked 2 Times in 2 Posts
    Rep Power
    11
    Thanks for your replies - Edutech I definately haven't seen a link to a config page but have filled in all pages during installation. Matt, TCP/IP is already enabled and Vikpaw, yes I was talking about Windows Server. Any other ideas?

  7. #7

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,241
    Thank Post
    882
    Thanked 2,743 Times in 2,317 Posts
    Blog Entries
    11
    Rep Power
    784
    Is the firewall open for port 1433 (SQL) sometimes windows can get in its own way.

  8. #8

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,116
    Thank Post
    381
    Thanked 389 Times in 314 Posts
    Blog Entries
    8
    Rep Power
    180
    2 Options: You need to ensure you have the most up-to-date SIMSinst.exe which will see SQL installations (there have been problems in the past)

    You could opt to install as workstation and Doc Server. The manually run SIMSSeverApplicationSetup.exe to install necessary tools. Finally, using SQL SMS you can attached the database. Ensure sims.ini and connect.ini files are point to the correct database name. The part in the SIMSinst install for the server only does all mentioned above automatically for you.

    Good luck

  9. Thanks to GREED from:

    harryeds (3rd February 2011)

  10. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,788
    Thank Post
    716
    Thanked 1,441 Times in 1,194 Posts
    Rep Power
    360
    Is the system all up to date and patched, including all pre-requisites. I remember having to jump some hoops before getting the full SQL 2008 to install.
    Perhaps you could restart and try installing your own SQL, Express or Full, and then trying SIMSinst after.

  11. #10

    Join Date
    Sep 2009
    Location
    South West
    Posts
    24
    Thank Post
    13
    Thanked 2 Times in 2 Posts
    Rep Power
    11
    Thanks, I'll try all of that and let you guys know!!

  12. #11

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,821
    Thank Post
    272
    Thanked 1,140 Times in 1,036 Posts
    Rep Power
    350
    I know for the full version you need sql 2008 sp1 for it to work correctly on 2k8 r2 - possibly this could be needed for express? just a thought

  13. Thanks to glennda from:

    superfletch (30th January 2011)

  14. #12
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    444
    Thank Post
    153
    Thanked 77 Times in 61 Posts
    Rep Power
    32
    I've installed/moved SIMS a lot recently. I'm pretty sure Matt40k's answer is right. Can you check that the SIMS related instance of SQL has TCP/IP enabled?

    If not then I apologise.

  15. #13

    Join Date
    Sep 2009
    Location
    South West
    Posts
    24
    Thank Post
    13
    Thanked 2 Times in 2 Posts
    Rep Power
    11
    No, TCP/IP is definitely enabled; I didn't need to enable it either, it had been done for me, presumably by the installer. Thanks to GREED for his response, which solved the problem and clarified things for me and thanks to all the rest of you too.

  16. #14

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,116
    Thank Post
    381
    Thanked 389 Times in 314 Posts
    Blog Entries
    8
    Rep Power
    180
    Quote Originally Posted by harryeds View Post
    No, TCP/IP is definitely enabled; I didn't need to enable it either, it had been done for me, presumably by the installer. Thanks to GREED for his response, which solved the problem and clarified things for me and thanks to all the rest of you too.
    No problems at all, do come back if we can help out any more!

  17. #15
    Quackers's Avatar
    Join Date
    Jan 2006
    Posts
    1,408
    Thank Post
    43
    Thanked 153 Times in 128 Posts
    Rep Power
    55
    Having the same issue, trying to install a new Server 2012/SQL 2012 install but the "Use this SQL Instance for SIMS" drop down box on SIMSInst is empty, where do i get this newer version if SIMSInst?

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. [SIMS] SQL Backup with dbAttach [Solved]
    By Rawns in forum MIS Systems
    Replies: 5
    Last Post: 6th January 2011, 10:17 AM
  2. SQL Server Express 2005 Memory Limit per instance?
    By localzuk in forum Windows Server 2000/2003
    Replies: 1
    Last Post: 30th April 2010, 01:27 PM
  3. Replies: 1
    Last Post: 10th November 2009, 10:37 AM
  4. Replies: 9
    Last Post: 24th May 2009, 02:38 PM
  5. No Instance for WSUS in SQL service manager
    By petectid in forum Windows
    Replies: 1
    Last Post: 6th February 2007, 12:05 PM

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
  •