The whole point about log shipping is that the database is kept in step with the source database.
You can probably create a login for the user and give it a sid that already exists for a user in the database which will gve the login those permissions.
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.
Hi Nigel, The login and user exist on the source server and database. On the destinatin server only the login exist. The database does not have the user and I can not add it, apparently because the database is read-only.
Does log shipping sync users as well? Is my problem related to the database being read-only or the log shipping plan itself?
I suspect the login on the destination has a different sid from that on the source server. Try dropping the login and adding it with the same sid as the user in the database.
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.
Creating users on a read-only database
Posted - 10/07/2005 : 04:00:22
