This is basically it (Copied from my word doc!)
New Server Install for SIMS.net/FMS
• Install Windows Server 2003 (if you can), and update using windows update, install all updates and service packs. When installing, ensure you split the server HDD (or combined, RAIDed HDDs) into at least 2 partitions, c: for program files, d: for SQL and SIMS.
• Install SQL Server 2005 (or Express), and again update with all service packs. When installing, remember the instance name of the installation, you will need it later. Also, ensure you install to the secondary drive, not the C: drive (If SQL fills up the drive, you will not be able to start the server)
• Copy your SIMS Set-Ups folder to the new server, and put into a shared folder called Capita (or whatever you want to call your shared network drive)
• Run the SIMSINST application (from the SIMS setups folder), and ensure that the server option AND the document management server option are selected. Follow the onscreen instructions from here. You will need the SQL instance name from earlier.
• Once complete, login to test the new server. Use the username/password: 'SYSMAN' & 'password'. Once you can log in ok, you know this server installation is working.
• Now, make a full SQL backup of the original database. Copy this to the new server, and put into a suitable place (usually d:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data, where d is the drive where SQL is installed.
• ON THE NEW SERVER, restore this new database backup to the SQL, over the top of the new SIMS installation.
• Open dbAttach, and detach and reattach the SIMS database to SQL(Remember to drop SQL Logins). This should allow you to login with the normal usernames/passwords from the original database.
• Try logging into SIMS again on the new server. Remember you will need a new/updated connect.ini file wherever you are logging on from to do this (see below)
• Things to remember to do: Change the location of the Document Management Server in SIMS.net (Tools -> Setups -> DMS), import all the reports again (Reports -> Import).
• Now, copy the contents of the following folders to the new server:
SIMS/DocStorage/*Old Server Name Here*/ -> Copy to: SIMS/DocStorage/*New Server Name Here*/
o DocStorage (When copied, change the name of the sub folder to match that of the new server.)
• If your connect.ini files on the local workstations connect direct to the SIMS server, you will need to alter these individually to now point to the new server name/instance name. If you redirect to a central connect.ini, you only need to ensure that this one is correct (this is what I use).
Hope it is useful!