Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Query notification not getting through (… Error: 15517, State: 1. Cannot execute as the database principal …)
- This topic has 0 replies, 1 voice, and was last updated 9 years, 10 months ago by
community-content.
-
AuthorPosts
-
-
October 8, 2009 at 3:17 AM #23426
I am rather new to BizTalk and the task I have been given is to:
Use the wonderful new WCF SQL adapter with query notification to be informed when data has changed, suck this data in (while updating the status field to prevent multiple processing), then copy a subset of the data to another table in another database.
Well, I am running BizTalk 2009 with SQL Server 2008 on Windows Server 2008 inside a Virtual Machine hosted on Windows 7 Ultimate.
I got this app working under that environment and then needed to reach out to a dedicated SQL Server 2008 box on our company network. This is where the fun started.
I made sure that server was configured the same, with Service Broker enabled, CLR and DTC for good measure.
All I did was change the connection string and user/password in the Receive Locations and Send Ports, restart the Host Instance and try again, inserted some records, turned tracking on all over the place and waited…nothing 🙁
After looking around for a while, I right-clicked on “Service Broker > Queues > Show Transmission Queue” and found that the notification message was stuck there, trying to get out. The transmission_status was set to:
“An exception occurred while enqueueing a message in the target queue. Error: 15517, State: 1. Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission.”
So I started scouring the net, and found several posts, including posts in this forum explaining that I should check database ownership. And indeed it was a Windows login, and had probably been copied from elsewhere.
I tried the sp_changedbowner fix and alter authorization fix (does the same thing, I think) and I even created a new database, backed up the old one and restored to it, tried creating new users and everything else I could find, but still the message will not get through…grrrr!
Hopefully my explanation is complete and my frustration clear.
Would appreciate any help on this topic.
Thanks in advance.
Gregg.
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.