So I have set up my AO cluster and have to set up some data sources for reporting services.
Data Source=LISTENERNAME, PORT;Initial Catalog=DATABASENAME;Extended Properties=multisubnetfailover=true;Provider=SQLOLEDB;
What am i missing? Its just timing out all the time. My guess is that this means it not reading the listener properly and multisubnetfailover isnt taking effect.
Any help would be appreciated