SQL2012 alwayson 只读配置疑难

[lacrimosalyin]

SQL版本2012 alwayson已经搭建好了 并且是3节点,S2,S3,S4
S4为只读...通过SMSS访问并且加上ApplicationIntent=ReadOnly,访问到的还是主副本
只读路由也已经配置过,代码如下:
//配置各节点路由及TCP访问链接
ALTER AVAILABILITY GROUP [uzyalwayson3nodes]
MODIFY REPLICA ON N'S2' WITH
(
SECONDARY_ROLE (ALLOW_CONNECTIONS = READ_ONLY)
);
GO
ALTER AVAILABILITY GROUP [uzyalwayson3nodes]
MODIFY REPLICA ON N'S2' WITH
(
SECONDARY_ROLE (READ_ONLY_ROUTING_URL = N'TCP://S2.uzyalwayson.com:5022')
);
GO
ALTER AVAILABILITY GROUP [uzyalwayson3nodes]
MODIFY REPLICA ON N'S3' WITH
(
SECONDARY_ROLE (ALLOW_CONNECTIONS = READ_ONLY)
);
GO
ALTER AVAILABILITY GROUP [uzyalwayson3nodes]
MODIFY REPLICA ON N'S3' WITH
(
SECONDARY_ROLE (READ_ONLY_ROUTING_URL = N'TCP://S3.uzyalwayson.com:5022')
);
GO
ALTER AVAILABILITY GROUP [uzyalwayson3nodes]
MODIFY REPLICA ON N'S4' WITH
(
SECONDARY_ROLE (READ_ONLY_ROUTING_URL = N'TCP://S4.uzyalwayson.com:5022')
);
GO

//配置只读路由的顺序
ALTER AVAILABILITY GROUP [uzyalwayson3nodes]
MODIFY REPLICA ON N'S2' WITH
(
PRIMARY_ROLE (READ_ONLY_ROUTING_LIST=('S4','S3'))
);
GO
ALTER AVAILABILITY GROUP [uzyalwayson3nodes]
MODIFY REPLICA ON N'S3' WITH
(
PRIMARY_ROLE (READ_ONLY_ROUTING_LIST=('S4','S2'))
);
GO

有大侠知道吗...求教

[lacrimosalyin]

顶一下,来个大神帮忙下啊.谢谢

[LongRui888]

对alwayson 不太了解，帮你顶

[lacrimosalyin]

有没有人帮帮忙啊

[zjcxc]

连接的时候需要指定加入了 always on group 的用户数据库 一台服务器是可以配置多个 group 的，所以你不指定库的话，是不知道应该用那个库对应的 group 的，这样就不能重定向

[吉普赛的歌]

你是 ssms 连接还是程序连接 ？
ssms连接必须要指定默认库， 否则不准确！
http://blog.csdn.net/yenange/article/details/77618330