MIS Systems Thread, SIMS.net Invalid/user name password? in Technical; Ok I've built a new windows 2008 vm for SIMS.net and installed SQL 2008 express (from SiMS setups) and intalled ...
4th December 2010, 12:47 AM #1
SIMS.net Invalid/user name password?
Ok I've built a new windows 2008 vm for SIMS.net and installed SQL 2008 express (from SiMS setups) and intalled SIMS.net etc.
i've detached the DB from the old server and attached to new server, i've also tried backing up the old server and restoring it. Both via dbattach.
no sims users can login they get invalid username and password.
i've run sims.db_p_reset_sysman_password and reset the sysman password, then reset my password and logged in and I can get in, obviously I can't reset everyones password that would be a bit mad, this server is vlan'd away from the real sims server so I've got time to work on it.
any ideas on getting the logins to work?
the reason for this is the old server is 2003 and my new policy is server should be 2008.
IDG Tech News
4th December 2010, 12:51 AM #2
may well have fixed it.
7th December 2010, 10:46 AM #3
Sorry to post on here but I can't reply to your PM as I haven't posted 5 times! If you send me your email address I can reply that way.
21st December 2010, 08:26 PM #4
Having the same problem. Any help on this one please. Sorry to jump on this thread.
21st December 2010, 08:28 PM #5
can you login to sims on the server?
was it a fresh install of sql?
21st December 2010, 08:49 PM #6
run the sql in my post above fixed it.
21st December 2010, 08:59 PM #7
For future ref; i have had this problem with FMS and KB78058 fixed it.
By neilmc in forum General Chat
Last Post: 21st October 2009, 11:17 AM
By timbo343 in forum MIS Systems
Last Post: 5th December 2008, 01:26 PM
By pcplod in forum MIS Systems
Last Post: 15th October 2008, 10:20 AM
By duncane in forum MIS Systems
Last Post: 21st September 2008, 09:07 AM
By edie209 in forum MIS Systems
Last Post: 15th June 2006, 01:17 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)