Hmmm, actually, failing it over back and forth a few times, and it seems to be okay now.. I am not really sure why. OR perhaps its one particular replica...

Hi Perry,

This is what my configuration looks like now after some tweaking based on your reply:

GLSQCOL3010|TCP://GLSQCOL3010.blah.local:5022|SYNCHRONOUS_COMMIT|AUTOMATIC|ALL|READ_ONLY|TCP://GLSQCOL1010.blah.local:1433

GLSQCOL1010|TCP://GLSQCOL1010.blah.local:5022|SYNCHRONOUS_COMMIT|AUTOMATIC|ALL|READ_ONLY|TCP://GLSQCOL3010.blah.local:1433

GLSQCOL3010|TCP://GLSQCOL3010.blah.local:5022|SYNCHRONOUS_COMMIT|AUTOMATIC|ALL|READ_ONLY|TCP://GLSQCOL3010.blah.local:1433

GLSQCOL1010|TCP://GLSQCOL1010.blah.local:5022|SYNCHRONOUS_COMMIT|AUTOMATIC|ALL|READ_ONLY|TCP://GLSQCOL3010.blah.local:1433

So,

As a primary then any replica will accept all connections.

As a secondary they take...

Hi Perry,

Right, well i did the following:

ALTER AVAILABILITY GROUP [ingeus2]

MODIFY REPLICA ON N'GLSQCOL1010'

WITH (SECONDARY_ROLE (READ_ONLY_ROUTING_URL = 'TCP://GLSQCOL1010.blah.local:1433'));

ALTER AVAILABILITY GROUP [ingeus2]

MODIFY REPLICA ON N'GLSQCOL3010'

WITH (SECONDARY_ROLE (READ_ONLY_ROUTING_URL = 'TCP://GLSQCOL3010.blah.local:1433'));

Followed by:

ALTER...

Cheers Perry! You reply highlighted something I was missing - more so in my head than elsewhere! I am now having a problem with Read only routing but ill put...

I am on 2014 Enterprise.

Thanks

Alex

Cheers! Most helpful... Had not even heard of RML until now.

Thanks all for your help! I've now got plenty of random test data and test dates!

Cheers

Alex

Marvellous! Thanks a lot Gail.

Cheers Gail.

So DENY CONNECT permission wont be sent accross because they are server level and not DB level?

Alex

Hiya!

Just to let you that between the 8.3 format file paths and the package configs I have solved problem.

Thanks guys, appreciated.

Alex

I've managed to find it with the help of this link:

http://dataqueen.unlimitedviz.com/2012/01/ssis-2012-package-configurations-menu-option-missing/

I'm using SSDT for Visual Studio 2013 on top of SQL Server 2014

I'm now trying to create a...

I wondered about package configurations, but I don't have the option on the menu where everyone else on the internet seems to!

John thanks so much! That got me a little bit futher!

However, now when I use the 8.3 filenames from sqagent it doesnt find any files (succeeds, but does nothing, I...

Ah John, I didn't realise I could do that! So WITHOUT renaming the directories, I can still reference them with 8.3 notation?

Hi All,

Thanks for your help with this, your examples made me realise I am going about this all wrong anyway! Which in itself is not a bad lesson.

I'll start another...