Can I use four-part name using AG Listener name?

• ggoble

  Hall of Fame

  Points: 3337

  More actions

  January 15, 2016 at 9:59 pm

  #399581

  Can I or should I be able to use AG Listener Name in a four-part name? Select * from [AGListener].[DBName].schema.object

  I get an error when using the listener name but not when using the node name.

  "Could not find server 'AGListener Name' in sys.servers...."

  The application is trying to pass the listener name when running some stored procedures.

  Thank you

• happycat59

  One Orange Chip

  Points: 29389

  More actions

  January 17, 2016 at 7:59 pm

  #1852441

  You should be able to use the AG listener name in your queries. You will need to add it as a linked server