Where is Connection String Located as it relates to Availability Group Listeners? I am trying to teach myself about Availability Group Listeners and see that I need to update a "Connection String." I know that I have a connection string in my web.config file on the Web server, but is this where it needs to be updated? Is there somewhere in SQL Server Management Studio where it needs to be updated?

I've updated the connection string there, replacing the server name with the new Availability Group Listener Name that I've created, then updated my database table to replace the server name there with the AG Listener name too. When I update the name in the database table, my records will not open in the GUI where I'm accessing them from a website.

I think this will be a problem because if there is a failover, I'll need to manually update the name of the server for each record of the table to point to the new server location. I figured that if I put in the listener name in place of the server name, this would never need to be updated in the event of a failover.

Any thoughts? I've researched until my brain is mush and really need some help with fully understanding how to get these listeners working. Thanks in advance!
If you've set-up an Always On Availability Group Listener (and you should), then you'll have a new virtual name to use in your connection string. So if your SQL Servers are SQL01 and SQL02, and there's an availability group called SQLAG01 - then you'll specify this. You could continue to specify SQL01 in your connection string, but if the Always On Availability Group has failed over to SQL02, it won't work. But if you specify the listener name, all will be well.

Make sure that you've got the latest SQL Server Native Client drivers installed so that you can use the extra settings like Multisubnetfailover and potentially ReadIntent