Last post Apr 12, 2018 10:40 PM by kayalbertus
Jan 12, 2018 04:21 PM|progy85|LINK
private StockTicker(IHubConnectionContext<dynamic> clients)
Clients = clients;
var mapper = new ModelToTableMapper<Posts>();
mapper.AddMapping(s => s.ID, "ID");
_tableDependency = new SqlTableDependency<Posts>(
_tableDependency.OnChanged += SqlTableDependency_Changed;
_tableDependency.OnError += SqlTableDependency_OnError;
Why I got this error? Additional information: User without permissions.
Jan 12, 2018 04:53 PM|march11|LINK
Its good chance that you have a permission issue on your SQL database. check the permissions settings.
It would help if you posted the full error on here as well.
Jan 12, 2018 07:58 PM|progy85|LINK
An exception of type 'TableDependency.SqlClient.Exceptions.UserWithNoPermissionException' occurred in mscorlib.dll but was not handled in user code
Additional information: User without permissions.
Jan 15, 2018 06:23 AM|X.Daisy|LINK
According to the error message, SqlTableDependency doesn't have permission with SQL Sever. I checked the official document, please make sure to GRANT the following permissions:
If you can't get enough permissions, you can chooes to skip the permissions test done by SqlTableDependency, otherwise an SQL server exception will be thrown. —— Set the executeUserPermissionCheck constructor parameter to false.
Besides, if you still have problems, you can also refer to the
github link, it's the official tutorial.
Apr 12, 2018 10:40 PM|kayalbertus|LINK
ALTER DATABASE ACME SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE;
and then check your connection
connectionString="Server=xxxL; Initial Catalog=ACME;Integrated Security=false;User ID=sa;Password=yourPassword;