You work in an international company which is named TXTWIN. And you’re in charge of the company network and use Microsoft BizTalk Server 2006 R2.
You import a binding file. The configuration information for a SQL receive port is contained in this file. The SQL adapter fails to connect to the database because of an incorrect password after the import. The SQL adapter can successfully connect after the password to the correct value in the SQL port is changed by hand. You must make sure that the password will be set automatically to the correct value on future imports of the binding file. So what should you do?
A.
The SQL Command property of the SQL receive location should be set by using BizTalk Explorer, let it include the password.
And then export the binding file.
B.
You should set the Persist Security Info property of the SQL receive locations connection string to True by using the BizTalk administration console.
Identify that the Allow saving password property of the SQL receive location is enabled.
Export the binding file.
C.
After you identify that the Allow saving password property of the SQL receive location is enabled and export the binding file.
You should set the Persist Security Info property of the SQL receive locations connection string to False by using the BizTalk administration console.
D.
You should identify that the Allow saving password property of the SQL receive location is enabled by using the BizTalk administration console.
And then export the binding file and open the binding file in a text editor.
At last change the password to the correct value, and save the changes.
Explanation:
BURGOS: mnemo: “SQL adapter fail” = “Allow saving password … open the binding file … password to the correct value”