cannot set application role 'sims' because it does not exist or the p/w is incorrect
I'm trying to upgrade an old SIMS db on a virtual machine. I've upgraded it to db version 3.61.387 and done the SQL2005 migration but now get the following errors:
(I have the correct - I think - versions of SIMS for the timeframe we're talking about, 7.97 for the main app, 2.11 for dbupgrade)
1. cannot set application role 'sims' because it does not exist or the password is incorrect when trying to log into dbupgrade using sysman & default password
I've tried detaching and re-attaching the database as advised in supportnet
2. can log into dbupgrade with sa user & password, but when trying to perform the next lot of upgrades i get:
Setuser failed because of one of the following reasons: the database principal 'sims' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.
The SQL Batch which caused the error was :
----------- End of file -------------------------------------------
--schema version and model
if not exists(select 1 from sysusers where uid = user_id('sims') and isapprole = 1)
3. When trying to log into sims using sysman login, I get reason 0. As it says in http://www.edugeek.net/forums/mis-sy...eason-0-a.html , SIMS can see the database because it brings up 'Invalid username/password' for an incorrect user/pw combination but reason 0 for a correct one. I've tried all the suggestions in the above thread.
Any ideas, anyone?