MIS Systems Thread, SQL migration "Login failed: Reason 0" in Technical; I am using SQL 2005 not express.
Is the error to do with AWE memory management? If so there are ...
19th May 2009, 11:32 AM #46
I am using SQL 2005 not express.
Is the error to do with AWE memory management? If so there are options within the management studio to enable and control memory allocation.
I am going to rebuild the server (again) and request the latest guide from Capita to see if the August 2008 is missing something out.
For example, is the install folder S:\SIMS or S:\SIMSROOT\SIMS or does it matter as long as I share S:\ as SIMSROOT? Or does it not matter where I install SIMS as long as SIMS.ini and Connect.ini can see it?
Also, What roles need to be enabled on the server to ensure SIMS will run? Are there compatibility issues with .net framework 3.5 or SQL 2005 sp3?
You can see why it does not seem to be straightforward.
IDG Tech News
19th May 2009, 12:32 PM #47
Possibly unrelated, but I've had the Reason 0 error when a) the server has been low on disk space, b) the SQL services were being hammered by RM's RMC3IEngine throwing its toys out the pram, and c) when S: wasn't mapped correctly.
19th May 2009, 01:38 PM #48
Spoke to a very helpful Guy at Capita (They have a few real shining stars....and then the rest ). He talked me through the mapping which I have implemented, no luck.
The server has around 600gb free, Xeon quad with 8gb. The problem is definately with SIMS.
I now have around 15 fixes to work through before I ring Capita again. I'll let you know what happens.
14th July 2009, 09:39 PM #49
- Rep Power
Connection failed for login ITAdmin , reason: 0
[QUOTE=broyles;295238]I am having the same problem, any advise on how to get round/sort it is appricated. here is what I have done to date
(This is on a new sims server on a brand-new domain)
SIMS Connection failed for login ITAdmin , reason: 0
>>>> the problem is probably that the nice new sims server may be running Server 2003 64-bit version
if so you need to edit the connect.ini file on the SIMS server so it ONLY referes to the Internal IP address of the SIMS server NOT the server name to get it to work
20th September 2009, 09:23 PM #50
Originally Posted by ravens
how far did you get with this? as its happening here on a 2008 server 32bit sql 2005 full running out of ideas
20th March 2010, 12:45 PM #51
- Rep Power
SIMS connection failed for login XXXXX, reason 0
I've had the same problem for some time
only applies though when loging in down a VPN link
rebooting the SIMS server seems to solve the problem for a short while - then error comes back again
20th March 2010, 01:03 PM #52
I did fix this. I got a patch from captia. It was to do with making changes in system manager. I'll digout the info.
16th January 2011, 04:15 PM #53
- Rep Power
Just finished the 2005->2008 migration myself, had the same error logging in users failing with reason 0.
We migrated the database to a different system so had to move the SQL login accounts as well as the SIMS user accounts (contained in the SIMS database). There is a guide from Microsoft on how to do that here: How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008
Secondly our install of SQL Express wasn't accepting remote connections because for some reason it had set the SQL Server Browser service to disabled, once we enabled that clients (SQL Management Studio is useful for testing) were able to connect without issue.
Last edited by james_yale; 16th January 2011 at 04:30 PM.
Thanks to james_yale from:
gotenks1321 (9th February 2012)
By tech_guy in forum MIS Systems
Last Post: 20th May 2013, 10:15 AM
By leonard.powers in forum MIS Systems
Last Post: 1st October 2009, 01:58 PM
By googlemad in forum Windows
Last Post: 28th April 2009, 12:53 PM
By mortstar in forum MIS Systems
Last Post: 5th June 2008, 01:48 PM
By amvc in forum MIS Systems
Last Post: 25th October 2007, 09:37 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)