Add User to Log-Shipped Database

16 Mar 2006 11:39 AM

Toni

I have a SQL 2000 Enterprise Edition sp4 production database that is log
shipping to 2 servers (one for DR purposes and the other for reporting).
On the reporting server, the database is in Read-Only mode. I need to
add another user to the database so they can run reports. How can I do
this with the database in read-only mode? I can't take it out of
read-only because I'll have to set up log shipping all over again, won't
I?
This is a 40 GB database so that would take quite some time to do.

Do you have any suggestions?
Thank you.

Toni

*** Sent via Developersdex http://www.developersdex.com ***

16 Mar 2006 11:48 AM

Tibor Karaszi

You need to add a login for that user on the originating server, add a user for that login on the
originating server and then add the same login on the reporting machine (making sure that the SID
matches).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quoteHide quote

"Toni" <teib***@SQLallina.com> wrote in message news:uv9UQ5OSGHA.256@TK2MSFTNGP14.phx.gbl...
>I have a SQL 2000 Enterprise Edition sp4 production database that is log
> shipping to 2 servers (one for DR purposes and the other for reporting).
> On the reporting server, the database is in Read-Only mode. I need to
> add another user to the database so they can run reports. How can I do
> this with the database in read-only mode? I can't take it out of
> read-only because I'll have to set up log shipping all over again, won't
> I?
> This is a 40 GB database so that would take quite some time to do.
>
> Do you have any suggestions?
> Thank you.
>
> Toni
>
> *** Sent via Developersdex http://www.developersdex.com ***

16 Mar 2006 12:03 PM

Toni

The sid! Of course! I made the sid match and everything is perfect!
I'll make sure to put this in my documentation so I don't forget.

Thank you so much!

Toni

*** Sent via Developersdex http://www.developersdex.com ***