MIS Systems Thread, Local SIMS in Technical; Just copied the SQl database to my machine, copied the whole sims directory (from s drive) to my machine also. ...
16th July 2008, 11:08 AM #1
Just copied the SQl database to my machine, copied the whole sims directory (from s drive) to my machine also. Changed the connect.ini to point to my sql instance.
But when I try and log into it I get the following error.
"Sims connection failed for Login XXXX, reason:0"
Anybody tell me what I've done wrong. I'm doing this because I want a Test environment for staff members to get used to lesson monitor (rolling it out next term).
Any help would be hugely appreciated
16th July 2008, 11:18 AM #2
Advice Fix 1
The machine may be pointing to a incorrect networked Connect.ini file and therefore cannot see any SQL Server or Database. Delete the Connect.ini from e.g. C:\Program files\SIMS\SIMS .net and then run SIMS .net and select the correct Connect.ini from e.g. S:\SIMS or alternatively create a local connect.ini and enter the correct SQL Server and Database name.
Stop and Restart SQL Server - The SQL Server may not be running
The error can also be an indication that the upgrade has been run, but has been unsuccessful.
Please check the version of SIMSSQLApplicationsetup.exe in the setups folder is 1.558.12 (for August 2007 release) or 1.0560 (for September 2007 release) then run this to upgrade to version of DBupgrade which should be 22.214.171.12403
Then run Dbupgrade.exe manually from e.g. D:\Program files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn
The list of upgrade files will be shown or there may be a message about a User already logged in. If Users are detected, a Force All will need to be run to exit the Users out of SIMS to allow the upgrade to commence (requiring the SA logon credentials). This Force All option will appear automatically if Users are detected as being logged in.
If fix 3 does not resolve the issue please run SIMSApplicationsetup.exe from the setups folder
If the error still occurs and you installed SQL 2005, but not via one of our installers then please follow KB71936
This error can also be caused by a corrupt user in the users table. If all other users can login to the system OK please re-create the user that is getting reason 0
Please reboot the server and try logging in to SIMS.net
Fix 8 THIS IS ONLY RELEVANT IF PASSWORDS HAVE BEEN RESET
This problem may be due to the Domain Control settings policy with the School.
The reason for this is because the school's policy does not allow the password to be reset more than a certain number of times within a specific time-frame.
This issue will be resolved in the June 08 release. (only if Reason 0 occurs after resetting passwords)
This problem will need to be resolved on the domain server prior to running the June 08 release
Check there is sufficient space on the partition where SQL is installed. Also check the system partition has sufficient space as temporary files can be created during the backup.
Check the size of the SQL Log file eg SIMS.LDF. If excessively large use SHRINKDBLOG.BAT to shrink the log file.
By CM786 in forum Windows
Last Post: 26th February 2010, 11:00 AM
By tosca925 in forum Scripts
Last Post: 14th June 2008, 01:18 AM
By HodgeHi in forum MIS Systems
Last Post: 10th June 2008, 06:06 PM
By ozzy in forum How do you do....it?
Last Post: 19th January 2008, 08:40 PM
By russdev in forum Windows
Last Post: 18th November 2005, 02:11 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)