vnovik
April 7, 2019, 10:01am
2
Hello ani1214,
This answer from Steve might help you:
How BESAdmin and other services connect to the db is based on your ODBC definition. Check in ODBC Admin (odbcad32.exe) how the bes_bfenterprise System DSN is configured. If you want to use NT Authentication to connect as the user running the services/BESAdmin, then configure the DSN as such. Right now it is configured to use SQL authentication, so BESAdmin will prompt you to login as ‘sa’ and the other BES services will expect SQL credentials to be stored in the registry.
Please note the following KB article for changing a default username from sa to a custom name:http://www-01.ibm.com/support/docview.wss?uid=swg21666274
Also it might be helpful to install SQL Management Studio on a BES Server box, configure it to connect to the remote DB using the same settings as BES Server and try to connect to that DB.
Regards,
2 Likes