|
Home > Archive > BizTalk Server General > August 2005 > SQL Adapter Receiver but not Send
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Adapter Receiver but not Send
|
|
|
| I have been able to use the SQL Adapter to Receive, but not to Send
data. What is the difference with regard to access rights,
priviledges, etc.? Any hints on what to do?
| |
| Jeff Lynch 2005-07-27, 7:50 am |
| Nils,
The connection string should use an account with at least db_datawriter and
db_datareader privileges on the database you are trying to "send" to. What
error messages are you getting?
--
Jeff Lynch
"A BizTalk Enthusiast"
http://codebetter.com/blogs/jeff.lynch
"Nils" <nith@tss.teleca.se> wrote in message
news:1122462721.583167.249400@g47g2000cwa.googlegroups.com...
>I have been able to use the SQL Adapter to Receive, but not to Send
> data. What is the difference with regard to access rights,
> priviledges, etc.? Any hints on what to do?
>
| |
| N Thorell 2005-07-27, 5:52 pm |
| In addition to earlier problems, I probably got more problems when the system
guy changed my priviledges. Now, I can't even deploy. I just have a receive
FILE port and an SQL send port with a filter. I have a local database for
BizTalk and a remote database for the application. Has some ports been
disabled by sys admin?
From the Output window:
Deploying...
: Deploy server= .............(normal stuff)
error: Unspecified exception: Access is denied.
error: Access is denied.
"Jeff Lynch" wrote:
> Nils,
>
> The connection string should use an account with at least db_datawriter and
> db_datareader privileges on the database you are trying to "send" to. What
> error messages are you getting?
>
> --
> Jeff Lynch
> "A BizTalk Enthusiast"
> http://codebetter.com/blogs/jeff.lynch
>
>
> "Nils" <nith@tss.teleca.se> wrote in message
> news:1122462721.583167.249400@g47g2000cwa.googlegroups.com...
>
>
>
| |
| N Thorell 2005-07-27, 5:52 pm |
| Besides, in HAT I get Message Status
"Delivered, not consumed"
for the SendPort_SQL
"Jeff Lynch" wrote:
> Nils,
>
> The connection string should use an account with at least db_datawriter and
> db_datareader privileges on the database you are trying to "send" to. What
> error messages are you getting?
>
> --
> Jeff Lynch
> "A BizTalk Enthusiast"
> http://codebetter.com/blogs/jeff.lynch
>
>
> "Nils" <nith@tss.teleca.se> wrote in message
> news:1122462721.583167.249400@g47g2000cwa.googlegroups.com...
>
>
>
| |
| Jeff Lynch 2005-07-27, 5:52 pm |
| You won't be able to use the SQL Send Adapter without permissions to access
the database.
--
Jeff Lynch
"A BizTalk Enthusiast"
http://codebetter.com/blogs/jeff.lynch
"N Thorell" <NThorell@discussions.microsoft.com> wrote in message
news:305C47FD-BC86-4FC0-A9E6-45D7BEA2525F@microsoft.com...[vbcol=seagreen]
> Besides, in HAT I get Message Status
> "Delivered, not consumed"
> for the SendPort_SQL
>
> "Jeff Lynch" wrote:
>
| |
| N Thorell 2005-08-01, 8:09 am |
| But the SQL Receive adapter works, and I can update the database with regular
..NET applications, developed with Visual Studio. What is so particular with
BizTalk SQL Send Adapters? I have been a successful programer for many
years, why is it suddenly so hard to get anything to work? It still think
that all the step-by-step guides on the web are insufficient. There must be
some hidden assumptions that I can only guess. My suggestion is that all
authors of guidelines should test their articles on other people before
publishing them. They should not assume that other people can read their
minds. And test the step-by-step guides on ANOTHER computer! That would
reveal most of problems.
"Jeff Lynch" wrote:
> You won't be able to use the SQL Send Adapter without permissions to access
> the database.
>
> --
> Jeff Lynch
> "A BizTalk Enthusiast"
> http://codebetter.com/blogs/jeff.lynch
>
>
> "N Thorell" <NThorell@discussions.microsoft.com> wrote in message
> news:305C47FD-BC86-4FC0-A9E6-45D7BEA2525F@microsoft.com...
>
>
>
|
|
|
|
|