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)
 Cannot find the user 'database_principal'

Author  Topic 

nirakar_mal
Starting Member

1 Post

Posted - 2009-04-22 : 01:28:20
hi,

i m working in SQL notification.

i ve executed some statements to peroform sql notifications like...


--alter database login set enable_broker;

--create queue ContactChangeMessages;

--create service ContactChangeNotification on Queue ContactChangeMessages ([http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification]);

--grant subscribe query notifications to database_principal

1st 3 statements are executing successfully, but while executing last statement error is showing "Cannot find the user 'database_principal', because it does not exist or you do not have permission.".

pls help me how to solve this problem.


Nirakar.
   

- Advertisement -