Issue with SQL Server mirroring endpoint creation using SQL Authentication
-
I am trying to create EndPoint in SQL Server 2019 using transact SQL
CREATE ENDPOINT endpoint_mirroring
STATE = STARTED AS TCP ( LISTENER_PORT = 5022 )
FOR DATABASE_MIRRORING
( AUTHENTICATION = WINDOWS NEGOTIATE,
ENCRYPTION = SUPPORTED,
ROLE=ALL);
GO
I want to use SQL Authentication for creation of mirroring endpoints. I can use SQL Management studio to do that, but could not find any examples on SQL Authentication method for transact SQL
Thanks
-
Best you can do is to script out the endpoint you've created using SSMS and SQL authentication and see what it used.
We always user the sql server service accounts ( or computer account ) because it provides better communication security options.
(WINDOWS KERBEROS + ENCRYPTION = REQUIRED )
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Thanks Johan, After setting up SQL Authentication endpoint
when I run the Script Action, it shows a message "There is no action to be scripted"
I will try to do the windows Authentication, it has to be separate Windows accounts for Principal and Secondary servers and cross account permissions.
-
during the setup process, the used accounts are being granted connect to the endpoint, so that is covered.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply