Skip to Content
avatar image
Former Member

BODS 4.2 repository connection issue with SQL Server alias


I'm having an issue with Data Services intermittently disconnecting from it's repository and not being able to connect again.

The issue is due to the database being on SQL Server 2016 and the server has an alias due to the DR configuration. When I use the actual server name it has no issue but I need to use the alias. It's semi related to the DSN connection property MultiSubnetFailover but for BODS, it doesn't use DSNs.

Has anyone worked with the same setup? What do I need to on the BODS setup to have it work with a database alias and be stable?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers