Log Shipping and SQL Reporting Services -

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 ?

randyj June 04, 2007 00:48

Comments

1 comment

Has anyone had experience using sp_change_users_login
(http://msdn2.microsoft.com/en-us/librar ... 633(SQL.80).aspx) to do something like what I need to do ?

randyj June 04, 2007 13:25

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Log Shipping and SQL Reporting Services -

Comments

Add comment