dblight Posted January 13, 2012 Posted January 13, 2012 Hi all, I am going to create a VM with Server 2008R2 and SQL 2008R2 with the aim of taking a backup of our existing SIMS database (currently using SQL2008 R2) and then attaching it as a new database on the new "Training" server. I have seen some disussion on DBAttach? We currently use Trusted Authentication and would like to continue to do so on the "Training Server" is the DBAttach process still relevant? Any help would be great Thanks
matt40k Posted January 13, 2012 Posted January 13, 2012 Yes, dbattach will work, question, will the training server be on the same domain?
dblight Posted January 13, 2012 Author Posted January 13, 2012 Thanks for your advice. Yes, just creating a Virtual machine on another server. My plan is to patch it, install SQL 2008 R2, Patch that. Copy all the files from SIMS directory on current "live server", make a backup of current SIMS sql database, restore it to new "Training" server. Change the connect.ini to point to training server on a new SIMS shortcut. Then somehow change the doc server storage location on the training server? Well thats my plan in my head anyway! Have i missed something?
matt40k Posted January 13, 2012 Posted January 13, 2012 SQL 2008 R2 - make sure you enable TCPIP Then somehow change the doc server storage location on the training server? Copy the docstorage folder - then within the folder, edit the subfolder with the new server name. Then logon to SIMS .net, tools > setups > document management server and change the server name. Should be ok from the top of my head. 1
dblight Posted January 13, 2012 Author Posted January 13, 2012 SQL 2008 R2 - make sure you enable TCPIP Sorry not quite sure what you mean here, TCP/IP where? In the SQL setup? The VM has a shared network connection with the host. Or are you referring to something different?
matt40k Posted January 13, 2012 Posted January 13, 2012 SQL - How to: Enable or Disable a Server Network Protocol (SQL Server Configuration Manager)
dblight Posted January 16, 2012 Author Posted January 16, 2012 I seem to be going around in circles with this one! I have installed OS and SQL 2008 R2 and created a SIMS instance, i copied all the shared files over from exisiting server as well as the doc storage. When i run SIMSinst.exe and select to install the server option it prompts to select a Database Instance and doesnt show the one i created, only create a new 32bit instance, if i select that it launches the SQl 2008 R2 installer with the free option (MSSQL) selected and greyout out! Anyone any ideas? I have tried instlling without the server option, restoring SIMS database to new server from backup of existing server and changing the connect.ini but still no joy! :-( Looked at getting a new clean SIMS ISO from supprtnet but cannot find it anywhere so just run from our existing share.
apeo Posted January 16, 2012 Posted January 16, 2012 The Autumn release is here: http://support.capitaes.co.uk/user/detail.asp?params=%91%D5%CB%DD%E5%F3%9D%D7%E3%DE%D9%EF%99%C4%E6%E5%A0%C8%DD%E5%A9%B5%C7%E3%E1%CE%D6%D2%EE%AB%CA Not sure if you can do a clean install from it though. 2
matt40k Posted January 16, 2012 Posted January 16, 2012 @dblight - Could be your SIMSINST is out-of-date, never tested it against SQL2008 R2, but it should work. I would install SIMS Document Server, then manually run simssqlapplicationsetup.exe.
dblight Posted January 16, 2012 Author Posted January 16, 2012 The Autumn release is here: http://support.capitaes.co.uk/user/detail.asp?params=%91%D5%CB%DD%E5%F3%9D%D7%E3%DE%D9%EF%99%C4%E6%E5%A0%C8%DD%E5%A9%B5%C7%E3%E1%CE%D6%D2%EE%AB%CA Not sure if you can do a clean install from it though. Thank You! out of interest how did you locate this on SupportNet? I cant seem to find it if i do a search?
dblight Posted January 16, 2012 Author Posted January 16, 2012 @dblight - Could be your SIMSINST is out-of-date, never tested it against SQL2008 R2, but it should work. I would install SIMS Document Server, then manually run simssqlapplicationsetup.exe. Brilliant, Thanks, i'll ty this shortly and let you know!
apeo Posted January 16, 2012 Posted January 16, 2012 I did a search for ISO The search on supportnet a is daft, the number of times I've searched from something i know exist but it doesnt find it with the proper search text.
vikpaw Posted January 16, 2012 Posted January 16, 2012 (edited) Take the clean install iso from SupportNet KB #110102 then you can run whichever update you want on top of that. http://support.capitaes.co.uk/websupport/RenderXSL.aspx?KB=KB110102.xmlFalse You'll need to create rules in the built-in firewall to allow through the SQL ports too. The linked article is i think a news item, so not in the normal search area. To find the solution (i.e. KB article) for the autumn release and also the one i mention above go to web support | solution search , change software to .net and type in iso as the search criteria. Sometimes depending on where you work, you may find access levels differ. EDIT: sorry, must be jet-lagged after BETT, i just did a refresh, and that last post telling you the search term wasn't there! Edited January 16, 2012 by vikpaw addition 2
vikpaw Posted January 16, 2012 Posted January 16, 2012 Here's a quick run-down i wrote before. http://www.edugeek.net/forums/mis-systems/86523-sims-server-install-guide.html#post762047 I tend to restore a backup, but if you want the logins to go over, you could detach the live one, copy it, then reattach both to live / test respectively. Hopefully that way the logins will be available. I did this ages ago for a test, and got lots of errors just by doing a restore of the .bak file backup created in SQL Studio, but it was mostly because the test server was not on the domain at the time. 1
dblight Posted January 16, 2012 Author Posted January 16, 2012 Thanks you all for you input. Will take all of your advice and guidence on board and have crack this afternoon again!
dblight Posted January 17, 2012 Author Posted January 17, 2012 Boom! Nailed it now, all setup! Thank you all for your guidance! How would one go about importing a timetable from nova just onto my new "training" server. Our timetabler has finished on Nova but I only want to be able to import it to the "training" server from his laptop (hes setup to use the live SIMS currently) any configs in Nova I should look at?? Sorry I've never touched Nova before!!
matt40k Posted January 17, 2012 Posted January 17, 2012 Look in your current SIMS server at the sims folder - normally s:\sims you'll find either a snova.dir file which can be open in notepad to reveal a path to the SNOVA folder or a SNOVA folder - which all the lovely Nova-T stuff. Then just copy it across.
vikpaw Posted January 17, 2012 Posted January 17, 2012 In the SNOVA folder as above, you should have an NT6 folder with yearly folders to store the nova .spl files. Failing that, just get the timetabler to open up his current working plan, and do a saveas to a memory stick. You can then load this into your test server.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now