Log Shipping and SQL Reporting Services -
randyj
Posts: 48
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 ?
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
(http://msdn2.microsoft.com/en-us/librar ... 633(SQL.80).aspx) to do something like what I need to do ?