What are the challenges you face when working across database platforms? Take the survey
Options

Log Shipping and SQL Reporting Services -

randyjrandyj Posts: 48
edited June 4, 2007 1:25PM in SQL Backup Previous Versions
I have just set up Log Shipping via SQL Backup v 4.6. It went easily, and setup quickly.

I use SQL Reporting Services for reports - I'd like to use the LogShipped DB for my Reporting Data Source.

However, I now need to change the User that Reporting uses. It is correct in the source DB, and of course, it is copied over to the copy db, but the user is invalid in the copy db.

Can anyone suggest a way to change the user in the copy db ?

Comments

Sign In or Register to comment.