Last post Feb 05, 2020 02:30 AM by jiadongm
Member
75 Points
513 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
1320 Points
491 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
75 Points
513 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
1320 Points
491 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