CREATE SERVICE giving Msg 15345

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Service Broker (2005)

CREATE SERVICE giving Msg 15345

Author

Topic

mrwhipple
Starting Member

2 Posts

Posted - 2011-03-23 : 11:48:00

I've been doing Service Broker for two years now, so i've never had a problem with creating a simple QUEUE until today.

I can create the MESSAGE, CONTRACT, and QUEUE, but when I try to create the SERVICE I get the following error:

Msg 15345, Level 16, State 2, Line 1
An entity of type service cannot be owned by a role, a group, or by principals mapped to certificates or asymmetric keys.

I searched the web and have not found anything dealing with this.

Thanks

script is below

CREATE MESSAGE TYPE [//dgi/ValidationReqMsg] VALIDATION = WELL_FORMED_XML;

CREATE CONTRACT [//dgi/ValidationContract]
(
[//dgi/ValidationReqMsg] SENT BY INITIATOR
);

CREATE QUEUE [DGI].[ValidationQueue]
WITH ACTIVATION
( STATUS = ON,
MAX_QUEUE_READERS = 3,
PROCEDURE_NAME = [DGI].[sb_ProcessValidationQueue],
EXECUTE AS 'GalcApplication'
);

CREATE SERVICE [//dgi/ValidationService]
ON QUEUE [DGI].[ValidationQueue]
([//dgi/ValidationContract]);

mrwhipple
Starting Member

2 Posts

Posted - 2011-03-23 : 15:36:35

I finally figured this issue out. I had to use "AUTHORIZATION [dbo]" when creating the CREATE SERVICE

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources