Re: SQL Server Question

Hey Scott,
Are you saying you have to run sp_change_user_login each time a failover occurs to sync all the db users with the server logins? I just want to ensure I understand the exact challenge you’re facing…

Thanks
Kellyn

On Wed, Sep 13, 2023 at 09:55 Scott Canaan <srcdco_at_rit.edu> wrote:

> I know this is not normal, but I don’t have any other place to ask:
>
>
>
> We have a SQL Server AlwaysOn cluster. Whenever a failover occurs, the
> database accounts become orphaned. I can fix it manually once it fails
> over. Everytime it fails over, the login becomes orphaned again.
>
>
>
> Does anyone know how to fix this?
>
>
>
> *Scott Canaan ‘88*
>
> *Sr Database Administrator *Information & Technology Services
> Finance & Administration
>
>
> *Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
>
> *srcdco_at_rit.edu <srcdco_at_rit.edu>* | c: (585) 339-8659
>
> *CONFIDENTIALITY NOTE*: The information transmitted, including
> attachments, is intended only for the person(s) or entity to which it is
> addressed and may contain confidential and/or privileged material. Any
> review, retransmission, dissemination or other use of, or taking of any
> action in reliance upon this information by persons or entities other than
> the intended recipient is prohibited. If you received this in error, please
> contact the sender and destroy any copies of this information.
>
>
>

--
http://www.freelists.org/webpage/oracle-l