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)  Permission issue on database_principal

Author  Topic  infoniit Starting Member 1 Post Posted - 2009-11-03 : 23:30:14 Can any body Help me in this - I am trying to use SQL Notification I am using SQL SERVER 2005 Login details are as follow - Server Type - Database Engine Server Name - NIIT\NIIT Authentication - Window Authentication User Name - NIIT\Vishal Password - on my own database "test" I followed these steps - 1. ALTER DATABASE test SET ENABLE_BROKER; 2. CREATE QUEUE testq; 3. CREATE SERVICE testser ON QUEUE testq ([http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification]); 4. USE test Problem starts from here - GRANT SUBSCRIBE QUERY NOTIFICATIONS TO database_principal after executing this query I am geeting this error "Msg 15151, Level 16, State 1, Line 1 Cannot find the user 'database_principal', because it does not exist or you do not have permission." Thanx every one who is trying to solve my problem