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

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.

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

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.

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

If you get MSDN subscriptions through a media, its there.