December 2, 2016 at 9:29 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.
December 2, 2016 at 10:11 am
Did you mean to post this is a different forum? SQL 2008 does not support Always on.
As for jobs, yes, you will need to create them in both places.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
December 2, 2016 at 10:14 am
Do you have any supporting articles to refresh the skill on it? I will post this to SQL 2012 forum - thanks for the advise.
Thanks.
December 2, 2016 at 10:39 am
Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1839767-3411-1.aspx
_______________________________________________________________
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/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply