sherrerk (3/5/2015)
I add applicationintent=readonly to the connection string and it connects to the secondary with default database master.
When connecting to a readable secondary you need to specify the database name too
sherrerk (3/5/2015)
When I try to change to one of my replicated databases I get a message stating "The database <database name> is not accessible".
Because you're specifying this twice
ALTER AVAILABILITY GROUP [QA_AG] MODIFY REPLICA ON
N'QA-DB-DATA1-1A' WITH (SECONDARY_ROLE (ALLOW_CONNECTIONS = READ_ONLY));
I think your script from above should be more this
ALTER AVAILABILITY GROUP [QA_AG] MODIFY REPLICA ON
N'QA-DB-DATA1-1A' WITH (SECONDARY_ROLE (ALLOW_CONNECTIONS = READ_ONLY));
ALTER AVAILABILITY GROUP [QA_AG] MODIFY REPLICA ON
N'QA-DB-DATA1-1A' WITH (SECONDARY_ROLE (READ_ONLY_ROUTING_URL = N'TCP://qa-db-data1-1a.corp.membersuite.com:1433'));
ALTER AVAILABILITY GROUP [QA_AG] MODIFY REPLICA ON
N'QA-DB-DATA2-1A' WITH (SECONDARY_ROLE (ALLOW_CONNECTIONS = READ_ONLY));
ALTER AVAILABILITY GROUP [QA_AG] MODIFY REPLICA ON
N'QA-DB-DATA2-1A' WITH (SECONDARY_ROLE (READ_ONLY_ROUTING_URL = N'TCP://qa-db-data2-1a.corp.membersuite.com:1433'));
ALTER AVAILABILITY GROUP [QA_AG] MODIFY REPLICA ON
N'QA-DB-DATA1-1A' WITH (PRIMARY_ROLE (READ_ONLY_ROUTING_LIST =
('QA-DB-DATA2-1A')));
ALTER AVAILABILITY GROUP QA_AG ADD LISTENER 'QADB' ( WITH IP (('10.0.9.232','255.255.255.0')), PORT=1433)
sherrerk (3/5/2015)
Thanks for the help so far, that got me further down the path.
You're welcome, please don't forget to credit posts as a marked solution if they were helpful
I'll review the output and get back if there are any anomalies
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉