[sims] "Cannot set application role 'simsuser' because it does not exist or the password is

[JPatch]

Hi all,

 

Wonder if any of you can help with a problem that I'm having trying to install Discover.

 

The transfer never works giving me the error message "Cannot set application role 'simsuser' because it does not exist or the password is incorrect."

 

I understand this is a permissions issue which I'm sure I need to fix by sorting the permissions in management studio but I don't know what I need to do!

 

I'll add that this is a training environment with capita training data and I've completely rebuilt multiple times trying to get this to work with no joy so any help you can give would be extremely gratefully accepted!

 

Thanks,

John

[JPatch]

For anyone who runs across this in future.

 

We managed to fix it by running, of all things, the re-index patch, and then the Discover transfer just worked!