Home Dashboard Directory Help

SSMS - SQL Server Management Studio 2012 missing connection properties for availability groups by DanMcClain



Sign in
to vote
Type: Suggestion
ID: 786323
Opened: 5/3/2013 1:41:33 PM
Access Restriction: Public


SQL server 2012 SSMS connection properties for Always on in a multi subnet failover is NOT retained by SSMS. Nore are they availalbe to set during a SQL server registration. Is extremely time consuming to manually enter parameters every time.

Example: MultiSubnetFailover=True;ApplicationIntent=ReadOnly
Sign in to post a comment.
Posted by Mobious1 on 4/15/2014 at 12:08 AM
Are there any workarounds or patches likely as this is such an annoying oversight and I cannot believe that it still exists in 2014 after being raised over a year ago? Please fix this as it's driving me crazy!
Posted by Roadkill on 4/1/2014 at 3:19 PM
Still an issue in SQL 2014 SSMS.
Posted by johnaau on 2/27/2014 at 4:08 PM
This is also an issue in SQL Management Studio 2013 and is very annoying.
Posted by Microsoft on 5/8/2013 at 7:10 AM
Hello Dan. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Sign in to post a workaround.