hi guys,

I am new to Biztalk server 2004. I followed this article
http://msdn.microsoft.com/library/d...768ff245df1.asp
and use sql adapter to call a sql store procedure. but I got this error
message:

The adapter failed to transmit message going to send port
"http://SQLAdapterExplore.IssueSelect". It will be retransmitted after the
retry interval specified for this Send Port. Details:"The underlying
connection was closed: The remote name could not be resolved.".

I am the administrator to the database and the computer.

would you please help me out?

thanks

sharon

[ Post a follow-up to this message ]

When you configured the SQL port, did you click the "Test Connection"
button?

--
McGeeky
http://mcgeeky.blogspot.com


"Sharon" <Sharon@discussions.microsoft.com> wrote in message
news:0D754ADA-BDDB-4443-BE10-7079E3DD727F@microsoft.com...
> hi guys,
>
> I am new to Biztalk server 2004. I followed this article
>
http://msdn.microsoft.com/library/d...-us/BTS_2004WP/
html/74cfc9d0-0974-4f4a-81f5-6768ff245df1.asp
> and use sql adapter to call a sql store procedure. but I got this error
> message:
>
> The adapter failed to transmit message going to send port
> "http://SQLAdapterExplore.IssueSelect". It will be retransmitted after the
> retry interval specified for this Send Port. Details:"The underlying
> connection was closed: The remote name could not be resolved.".
>
> I am the administrator to the database and the computer.
>
> would you please help me out?
>
> thanks
>
> sharon
>

[ Post a follow-up to this message ]

thanks McGeeky.

yes, I did. It said: test connection succeeded.

"McGeeky" wrote:

> When you configured the SQL port, did you click the "Test Connection"
> button?
>
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
>
> "Sharon" <Sharon@discussions.microsoft.com> wrote in message
> news:0D754ADA-BDDB-4443-BE10-7079E3DD727F@microsoft.com... 
> [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/BTS_2004WP/[/ur
l]
> html/74cfc9d0-0974-4f4a-81f5-6768ff245df1.asp 
>
>
>

[ Post a follow-up to this message ]