December 15, 2015 at 3:55 am
I have a SQL HAG cluster which has a read only secondary that I can connect reporting services to - this works fine and reports connect to the read only copy and get data with no problems, it uses a SQL logon.
I have an issue when I use that logon when trying to query using SSMS. I can connect using ApplicationIntent=ReadOnly but with or without the extra parameter any attempt to query the database results in a crash of SSMS.
the SQL account has read/write access and executeSP privileges
if I connect with windows authentication it connects to the primary but doesn't crash ignoring the READONLY setting
Using sql2012 11.0.5623 and connecting from a machine using sql 2012 SSMS or 2014
December 16, 2015 at 9:13 am
what is the exact version of your client tools
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 17, 2015 at 2:37 am
windows 7 (32 bit) laptop with SQL 2014
Microsoft SQL Server Management Studio12.0.2269.0
Microsoft Analysis Services Client Tools12.0.2000.8
Microsoft Data Access Components (MDAC)6.1.7601.17514
Microsoft MSXML3.0 4.0 5.0 6.0
Microsoft Internet Explorer9.11.9600.18124
Microsoft .NET Framework4.0.30319.34209
Operating System6.1.7601
also from windows 7 (64bit) desktop
Microsoft SQL Server Management Studio11.0.6020.0
Microsoft Analysis Services Client Tools11.0.6020.0
Microsoft Data Access Components (MDAC)6.1.7601.17514
Microsoft MSXML3.0 4.0 5.0 6.0
Microsoft Internet Explorer9.10.9200.17566
Microsoft .NET Framework4.0.30319.18063
Operating System6.1.7601
get same behaviour on both pc's
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply