Cannot find the object "QueryNotificationErrorsQueue" because it does not exist or you do not have permissions
<p>I am using <code>SqlDependecy</code> with <code>signalR</code> to push notifications to client browser  when there is some database changes, I followed <a href="http://techbrij.com/database-change-notifications-asp-net-signalr-sqldependency" rel="nofollow noreferrer">this</a> and <a href="http://venkatbaggu.com/signalr-database-update-notifications-asp-net-mvc-usiing-sql-dependency/" rel="nofollow noreferrer">this</a> post and everything works fine in local <code>SqlExpress</code> version 11.0  with  Local Connection String , but i have some kind of  permissions problem when i connect to remote database hosted in GoDaddy with Production Connection String </p>

<p><strong>Working Local ConnectionString</strong> </p>

<pre><code>&lt;!--&lt;add name="NotifyConnection" providerName="System.Data.SqlClient" connectionString=
"Data Source=.\SQLExpress;Initial Catalog=TestDB;Integrated Security=SSPI;" /&gt;--&gt;
</code></pre>

<p><strong>Production ConnectionString</strong></p>

<pre><code>&lt;add name="NotifyConnection" connectionString="Server=000.00.00.000;Database=TestDB;
User Id=UserName;Password=YourPassword;" providerName="System.Data.SqlClient" /&gt;
</code></pre>

<p><strong>Get Data Method</strong></p>

<pre><code>public IEnumerable&lt;Order&gt; GetData()
{

using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings
["NotifyConnection"].ConnectionString))
{

using (SqlCommand command = connection.CreateCommand())
{

command.CommandType = CommandType.Text;

command.CommandText = "SELECT OrderID,CustomerID FROM dbo.[RestUser]";

command.Notification = null;

SqlDependency dependency = new SqlDependency(command);
dependency.OnChange += new OnChangeEventHandler(dependency_OnChange);

if (connection.State == ConnectionState.Closed)
connection.Open();

using (var reader = command.ExecuteReader())
return reader.Cast&lt;IDataRecord&gt;()   // Here the Error throws
       .Select(x =&gt; new Order()
       {
       OrderID = x.GetInt32(0),
       CustomerID = x.GetInt32(1)                   
       }).ToList();


 }
 }
 }
</code></pre>

<p><strong>What i have tried ?</strong></p>

<p>I followed this <a href="http://www.dreamincode.net/forums/topic/156991-using-sqldependency-to-monitor-sql-database-changes/" rel="nofollow noreferrer">post</a> to Grant permissions in sql server , but not sure is this correct method to follow.</p>

<pre><code>USE YourDatabaseName;

CREATE QUEUE NameChangeQueue;

CREATE SERVICE NameChangeService ON QUEUE NameChangeQueue ([http://schemas.microsoft.com/
SQL/Notifications/PostQueryNotification]);

GRANT SUBSCRIBE QUERY NOTIFICATIONS TO YourUserName; // Here i get this error:

//Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, 
  sys, or yourself.

ALTER DATABASE YourDatabaseName SET ENABLE_BROKER;  // Broker is already enabled
</code></pre>

<p><strong>Screen Shot:</strong></p>

<p><a href="https://i.stack.imgur.com/WVpfo.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WVpfo.jpg" alt="enter image description here"></a></p>

<p>I am new to <code>SqlDependency</code>, how to fix this issue ?</p>

<p>Any help would be great.</p>