+ Post New Thread
Results 1 to 2 of 2
MIS Systems Thread, Installing SIMS as a server on windows 7 for testing in Technical; I have been asked to create a test SIMS Server for testing purposes so that our data manager can test ...
  1. #1
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    2,945
    Thank Post
    278
    Thanked 261 Times in 188 Posts
    Rep Power
    114

    Installing SIMS as a server on windows 7 for testing

    I have been asked to create a test SIMS Server for testing purposes so that our data manager can test a few bits and pieces before doing it on our live system.

    I have got a Windows 7 installation (32 bit) with SQL2008 R2 installed along with my databases from last weeks backup.

    Can someone please give me guidance on what to do next or even better, if someone has got an instruction guide? I have seen it been done a few times but i never took any notes.

    Thanks

  2. #2

    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
    If you search the forums, there are a number of threads with instructions, links and some guides too. It should all be relevant for a 2008 installation in theory so long as the live server is on 2008 as well. I don't think there are any extra caveats. Although SQL 2008 R2 support doesn't start until mid-march.

    Basically, copy your S: (sims) drive folders to a share on the test 'server'. share it locally as X: or something different for safety. Restrict permissions and all that.
    Run simsinst and choose the option to set it up as a server. Let it go through and do all of it's fancy stuff.

    Use dbattach to attach your backups to the SQL. You may find afterwards that you cannot log in, if you didn't use dbattach to detach them from the live server. There are some sql commands you can try to fix this. Stored procedure available, see this recent thread New Sims Install User Names missing in Master DB

    Install the client using simsinst onto the Win7 box too, and point to the new sims shared drive, so it's a little closed system.

    Once you're in, you need to do some housekeeping. Go to the setups and remove the connection to the docstorage. if you want a test doc storage, copy it locally, and change the folder names to match the new server setup, then tell test server where it is. Sometimes you need to do this manually with the dmconfig tool at command prompt as well.

    I would also, go and delete / disable all extraneous accounts in system manager too, just in case someone manages to come across it.

    I think that's about it. shout back if something goes awry.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Installing sims on windows 7
    By zag in forum MIS Systems
    Replies: 22
    Last Post: 4th April 2012, 08:17 PM
  2. Installing SIMS.net on Windows 7 64-Bit
    By MNHughes in forum Windows 7
    Replies: 4
    Last Post: 17th November 2010, 12:02 PM
  3. Installing SIMS.net on Windows Server 2008 64bit
    By mattstevenson2005 in forum MIS Systems
    Replies: 10
    Last Post: 7th March 2009, 08:08 PM
  4. Installing a SIMS server
    By nicholab in forum MIS Systems
    Replies: 6
    Last Post: 21st August 2007, 11:58 PM
  5. Installing a new sims server
    By wesleyw in forum MIS Systems
    Replies: 4
    Last Post: 22nd January 2007, 09:34 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
  •