I am trying to do a biztalk server sample for Loan application using SQL adapter. Here I have added SQL adapter port with proper connection to SQL server database but for binding i have use ‘Specify later’ as per suggested in MSDN.
I have created a send port of type ‘Solicit-Response’ and use ‘default’ pipeline for send port.
At the time of ‘ok’ click it gives me error as
[b:fac69d46ae]’Could not store transport type data for Primary Transport of send port ‘MyLoan_Acceptance_SPROC_Port’ tp config store. Access is denied'[/b:fac69d46ae]
My development environment and Biztalk server are present on different machine.
So can you suggest me how to overcome this error.
Thanks in advance