Thanks for the responses. I do notice the SID is different on the secondary server than on the primary even though the login names are the same etc. So since...

Hi,

The DB is a replicated db due to log-shipping. Isn't it supposed to be in read only standby mode? This is the error I get:

Database 'DB' is in warm standby....

Thanks SSC-Enthusiastic

I ran the script on the secondary server master db and received a bunch of errors:

Terminating this procedure. The User name 'db_accessadmin' is absent or invalid.

Msg 15291, Level 16,...

thanks for the replies. I did as you said but still no dice. I checked the SQL login properties through SSMS and the mapping to the replicated db is still...

Thanks for the replies. Here are the results:

username groupname login name DefDBName DefSchemaName UserID ...

No the login in question can not access this particular DB. It has access to the other replicated dbs on this secondary server.

thanks for the replies.

I tried the orphaned users resolutions and this account did show as orphaned but after running EXEC sp_change_users_login 'Auto_Fix', 'user' the account still does not have...

Thanks for the reply. To be honest I don't have much detail on this. It's a request from a SQL programmer. She does a lot of enterprise reporting for the...