December 2, 2016 at 10:22 am
Hello Experts,
Was wondering for alwayson, we need to create login accounts in all the nodes of the Alwayson Group. Typically what happens for SQL Jobs? Do we also need to create them in all the nodes?
Secondly, does application are recommended to connect to Alwayson either by listener or by the Cluster Virtual name or by the stand alone nodes?
Please suggest.
Thanks.
Thanks.
December 2, 2016 at 10:38 am
You should look at the stairways on this very topic. It covers this and so much more. http://www.sqlservercentral.com/stairway/112556/[/url]
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
December 2, 2016 at 10:50 am
I had a quick view on the posts. Very nice. But those are not inline to setup the SQL Jobs. Do you have any other useful articles to get more information on this? Please suggest.
Thanks.
December 2, 2016 at 2:31 pm
Michael John answered the question about jobs in your third topic on the same subject. http://www.sqlservercentral.com/Forums/Topic1839741-391-1.aspx
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply