October 18, 2005 at 12:55 am
Hi all,
I am trying to restore reporting services to a new server, I have installed and restore databases and now trying to run rskeymgmt to restore the encryption key but I get the error message "unable to connect to the database (-2147159551) 0x80004005"
I think this is due to permissions problems but I don't know how to fix it. Reporting server uses "rs" as the username to login, there is "rs" login in sql server and also a "rs" user in the ReportServer database. When I try and give the "rs" login permissions to use the ReportServer database I get a "User 'rs' already exists" message.
Any ideas much appreciated.
Kind Regards
Chandra
October 18, 2005 at 5:44 pm
You may need to 'resynch' the user within the DB, especially if you had an existing SQL server with it's own Master and an 'rs' user already on that system. You might want to look at the system stored procedure 'sp_change_users_login' which lets you link a login that exists in a DB with a login that exists in the syslogins.
Alternatively you delete the login from the db/system and re-create, but this is annoying as you then have to re-provide al of the security settings for that login (ie which stored procs they could use etc).
Steve.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply