+ 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
    10

    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,009
    Thank Post
    81
    Thanked 184 Times in 153 Posts
    Rep Power
    68
    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,342
    Thank Post
    367
    Thanked 624 Times in 509 Posts
    Rep Power
    156
    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,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    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,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    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
    10
    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
    10,991
    Thank Post
    851
    Thanked 2,653 Times in 2,253 Posts
    Blog Entries
    9
    Rep Power
    764
    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
    2,938
    Thank Post
    361
    Thanked 354 Times in 290 Posts
    Blog Entries
    8
    Rep Power
    172
    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,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    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
    10
    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,786
    Thank Post
    272
    Thanked 1,130 Times in 1,026 Posts
    Rep Power
    348
    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
    434
    Thank Post
    145
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    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
    10
    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
    2,938
    Thank Post
    361
    Thanked 354 Times in 290 Posts
    Blog Entries
    8
    Rep Power
    172
    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,309
    Thank Post
    40
    Thanked 141 Times in 116 Posts
    Rep Power
    53
    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
  •