Last post Feb 05, 2020 02:30 AM by jiadongm
Member
59 Points
377 Posts
Feb 04, 2020 06:10 AM|zhyanadil.it@gmail.com|LINK
tabledependency.sqlclient.exceptions.userwithnopermissionexception user with no permission in that line
this.SqlTableDependency = new SqlTableDependency<FlightAvailability>(ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString, "FlightBookings", mapper);
Participant
1050 Points
394 Posts
Feb 05, 2020 02:30 AM|jiadongm|LINK
Hi zhyanadil,
According to your problem, this maybe related to your SQL database permission settings, I found the similar two threads, hope they can help you:
https://forums.asp.net/t/2134749.aspx?Additional+information+User+without+permissions+
https://dba.stackexchange.com/questions/47567/permissions-using-net-sqldependency
Best Regards,
Jiadong Meng
Member
59 Points
377 Posts
error occured in sqltabledependency
Feb 04, 2020 06:10 AM|zhyanadil.it@gmail.com|LINK
tabledependency.sqlclient.exceptions.userwithnopermissionexception user with no permission in that line
this.SqlTableDependency = new SqlTableDependency<FlightAvailability>(ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString, "FlightBookings", mapper);
Participant
1050 Points
394 Posts
Re: error occured in sqltabledependency
Feb 05, 2020 02:30 AM|jiadongm|LINK
Hi zhyanadil,
According to your problem, this maybe related to your SQL database permission settings, I found the similar two threads, hope they can help you:
https://forums.asp.net/t/2134749.aspx?Additional+information+User+without+permissions+
https://dba.stackexchange.com/questions/47567/permissions-using-net-sqldependency
Best Regards,
Jiadong Meng
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com