[sims] Moving Sims for reference

[nicholab]

I need to move an old instance of Sims I don't know the system manager or the SA password any suggestions? Also what parts of data share would I need to copy to run the installer.

[kevin_lane]

If your not sure I would get capita go do the move for you

[rpettit]

Have you tried resetting the SA password using sqlcmd

 

How to reset the SA password in SQL Server | Database Professional

[nicholab]

It's an old system last supported by our LEA 7 years ago. We are now moving back to SIMS supported by LA.

[DWakely]

I would try using SQL management studio on the server logged in as administrator. When trying to connect to the SQL instance change the authentication to Windows Authentication. This should let you in.

 

If you were to move it (which is a PITA btw) you would need to move the MDF and LDF files for the SQL database along with the sims drive (usually s drive), you would also need to change your local connect.ini to point to the new server.

 

You must also know that if you don't detach the database using DBAttach you will more than likely loose all of the sims users' passwords. I would get around it by stopping the SQL service and copy the MDF and LDF to a new server then attach the db files to the new server.

 

Its worth noting that any DB moves should be really done by capita, but this ins't always viable. Although if you decide to 'go it alone' then you wont get any help from them! The key is don't turn off the old one until you are 100000% it worked out on the new server.

Edited July 29, 2015 by DWakely

[Atomic_Zombie]

We use a Batch file that adds the current logged in user to the SQL administrators, you can then log in to Management studio and change the SA password. THIS is the script. @DWakely if you use the Capita SQL migration tool to create the .BAKs to migrate the data, i've found it always copies over the usernames and passwords. Another thing that works too is to detatch the DB via DBAttach, reattach and create a BAK from it.