Originally Posted by SEP
it did ask for permissions when connecting to the db and when i reverted back it was asking for sql instance permissions
Also when you backup the main db i would assume you also have to do the same for the mds db if you have setup mds services?
I don't use MDS sorry but there is separate stuff you have to do for the MDS dbs IIRC and I think you might have missed that stuff. Double check the docs and go back over your steps as MDS and/or db perms sound like the issue.