An Introduction to the Service Broker Part 2

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

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

    HTH,
    Srinivas Sampath
    Blog: http://blogs.sqlxml.org/srinivassampath

  • 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

  • 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