August 16, 2005 at 12:40 pm
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sSampath/anintroductiontotheservicebrokerpart2.asp
HTH,
Srinivas Sampath
Blog: http://blogs.sqlxml.org/srinivassampath
August 30, 2005 at 4:48 am
Srinivas Sampath
I tried your code . But when I give
SELECT * FROM InventoryPostBox , I am not getting any output.
Any other settings need to be enabled at server / database level
Thanks
M A Srinivas
M A Srinivas
August 30, 2005 at 11:21 am
It could be an issue with Service Broker. Execute the following query: SELECT * FROM sys.transmission_queue and see if there is any error that is logged there. If so, send me the error text and I will tell you what to do.
HTH,
Srinivas Sampath
Blog: http://blogs.sqlxml.org/srinivassampath
August 30, 2005 at 11:58 pm
Srinivas Sampath,
Thank you . Please see the info below
SELECT * FROM sys.transmission_queue
The session keys
for this conversation could not be created or accessed. The database master key is required for this operation.
46B90A7F-3919-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 09:36:10.670 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
46B90A7F-3919-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 09:37:01.823 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
C8E479AD-3919-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 09:37:28.510 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
C8E479AD-3919-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 09:41:14.957 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
3E0C3247-3A19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 09:41:46.410 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
3E0C3247-3A19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 09:50:55.230 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
E4ED3DA9-3B19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 09:51:40.400 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
E4ED3DA9-3B19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-31 05:38:48.020 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
E56F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 10:02:31.577 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
E56F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-31 05:38:48.020 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
E76F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 10:02:32.780 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
E76F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-31 05:38:48.020 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
E96F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 10:02:33.013 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
E96F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-31 05:38:48.020 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
EB6F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 10:02:33.233 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
EB6F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-31 05:38:48.020 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
ED6F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-30 10:02:33.483 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
ED6F5F2D-3D19-DA11-A65F-505054503030 Receiver Sender HelloContract 2005-08-31 05:38:48.020 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
EF08B798-3D19-DA11-A65F-505054503030 BookInventory BookPublisher QueryInventoryContract 2005-08-30 10:05:31.667 0 QueryInventory 0 0 0xFFFE3C005100750065007200790049006E00760065006E0074006F00720079003E003C0042006F006F006B003E0042004B0031003000300031003C002F0042006F006F006B003E003C002F005100750065007200790049006E00760065006E0074006F00720079003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
EF08B798-3D19-DA11-A65F-505054503030 BookInventory BookPublisher QueryInventoryContract 2005-08-30 10:07:23.993 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
17C33DB5-4019-DA11-A65F-505054503030 BookInventory BookPublisher QueryInventoryContract 2005-08-30 10:27:48.017 0 QueryInventory 0 0 0xFFFE3C005100750065007200790049006E00760065006E0074006F00720079003E003C0042006F006F006B003E0042004B0031003000300031003C002F0042006F006F006B003E003C002F005100750065007200790049006E00760065006E0074006F00720079003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
17C33DB5-4019-DA11-A65F-505054503030 BookInventory BookPublisher QueryInventoryContract 2005-08-30 10:34:15.663 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
1B5035AB-4119-DA11-A65F-505054503030 BookInventory BookPublisher QueryInventoryContract 2005-08-30 10:34:40.680 0 QueryInventory 0 0 0xFFFE3C005100750065007200790049006E00760065006E0074006F00720079003E003C0042006F006F006B003E0042004B0031003000300031003C002F0042006F006F006B003E003C002F005100750065007200790049006E00760065006E0074006F00720079003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
1B5035AB-4119-DA11-A65F-505054503030 BookInventory BookPublisher QueryInventoryContract 2005-08-30 10:35:53.587 1 1 0 0xFFFE3C003F0078006D006C002000760065007200730069006F006E003D00220031002E00300022003F003E003C004500720072006F007200200078006D006C006E0073003D00220068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00530051004C002F005300650072007600690063006500420072006F006B00650072002F004500720072006F00720022003E003C0043006F00640065003E002D0038003400370030003C002F0043006F00640065003E003C004400650073006300720069007000740069006F006E003E00520065006D006F007400650020007300650072007600690063006500200068006100730020006200650065006E002000640072006F0070007000650064002E003C002F004400650073006300720069007000740069006F006E003E003C002F004500720072006F0072003E00 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
3EBD7690-E119-DA11-A660-505054503030 Receiver Sender HelloContract 2005-08-31 05:39:15.287 0 HelloMessage 0 0 0x480065006C006C006F002C00200057006F0072006C006400 The session keys for this conversation could not be created or accessed. The database master key is required for this operation.
Thanks
M A Srinivas
M A Srinivas
August 31, 2005 at 12:03 am
Ok. The security was tightened in the June CTP build of SQL Server. Read my blog at: http://blogs.sqlxml.org/srinivassampath/archive/2005/06/19/3457.aspx on how to get over this issue.
HTH,
Srinivas Sampath
Blog: http://blogs.sqlxml.org/srinivassampath
August 31, 2005 at 12:31 am
Srinivas Sampath,
Thank you for quick response . It is working now .
By the way how do I download Visual Studio Beta 2 through msdn subscription . Not able to find the URL
Thanks
M A Srinivas
M A Srinivas
September 1, 2005 at 11:51 pm
If you get MSDN subscriptions through a media, its there.
HTH,
Srinivas Sampath
Blog: http://blogs.sqlxml.org/srinivassampath
February 12, 2008 at 5:41 am
Hi Sampath..can u pls. give an example of service broker sending transactions across different databases with ROUTES. Can it be replacement of replication?
Thanks,
Kingshuk
July 1, 2010 at 4:52 am
hi, Now I encounted same problem, can you tell me how to resolve that . thank you .
BTW, http://blogs.sqlxml.org/srinivassampath/archive/2005/06/19/3457.aspx I can't open it .
thank you very much.
Vincent
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply