![]() ![]() ![]() It says “ Specifying MultiSubnetFailover=Yes when connecting to something other than an availability group listener or Failover Cluster Instance may result in a negative performance impact, and is not supported.”Ĭan anyone please let me know How far it is safe to use this parameter in SQL instances with out Always on feature activated? But I found an article warning not to use "MultiSubnetfailover" parameter ON non SQL always on instances (refer below URL for the same). This connection string works well with the SQL instances where Always on is not activated. Provider=SQLNCLI11.1 User Id=sa Password=********* Initial Catalog=TEST1 Data Source=DC01 MultiSubnetFailover=true Below is the connection string i used in. I have tried writing connection string which is working on both type of SQL instances. I have several SQL instances, few with Always on AG activated and few with out Always on AG group. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |