itboss Posted March 20, 2010 Posted March 20, 2010 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 ? ?
ful56_uk Posted March 20, 2010 Posted March 20, 2010 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.
james_yale Posted January 16, 2011 Posted January 16, 2011 (edited) 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. Edited January 16, 2011 by james_yale 1
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