MS SQL Server - Log Shipping

Author

Log Shipping

Kevin Antel

2006-03-09, 11:23 am

I have setup 2 SQL Servers, 1 is the primary production server and the other
is for reporting services. I have the primary server doing log shipping to
the reporting server and leaving it in standby mode. Everything seems to be
working great, however, I need to add a user to the standy server, but
can't, because it's read-only.

Does anyone know the typical procedure for adding users once log shipping is
setup? Or is it just not conceivable to do such a thing? Log shipping is
perfect for Reporting Services.

thanks.

Evergray

2006-03-10, 7:23 am

The only way here is to add user to the database on a primary server. If
primary and reporting instance of database must have different access
restrictions, consider using replication or DTS to populate reporting DB.

--
WBR, Evergray
--
Words mean nothing...

"Kevin Antel" <kevina@cqlcorp.com> wrote in message
news:OODX2Z5QGHA.5552@TK2MSFTNGP10.phx.gbl...
>I have setup 2 SQL Servers, 1 is the primary production server and the
>other is for reporting services. I have the primary server doing log
>shipping to the reporting server and leaving it in standby mode.
>Everything seems to be working great, however, I need to add a user to the
>standy server, but can't, because it's read-only.
>
> Does anyone know the typical procedure for adding users once log shipping
> is setup? Or is it just not conceivable to do such a thing? Log shipping
> is perfect for Reporting Services.
>
> thanks.
>

Sponsored Links