Skip to Content

BODS 4.2 repository connection issue with SQL Server alias

Feb 26 at 10:33 PM


avatar image
Former Member


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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers