Two connections cannot be opened for an application role user

Asked Jul 04 '16 at 05:39

Active Jul 04 '16 at 05:41

Viewed 44 times

I have set an application role for a database in SQL Server, so that other than my application nothing can access that database. But the problem is when I am trying to open two record-sets in same method, it throws an error that permission is not there for the second statement.

Example code :

Dim rs As ADODB.Recordset

Set rs = New ADODB.Recordset

Dim rs2 As ADODB.Recordset

Set rs2 = New ADODB.Recordset

rs.Open "Select * from Table1", Connection

rs2.Open "Select * from Table2", Connection

rs.Close

rs2.Close

When it is executing the second query, throws an error:

"The SELECT permission was denied on the object 'Table2', database 'Dat1', schema 'dbo'. (Error Number -2147217911)"

edited Jul 04 '16 at 05:41

shA.t

16,580
5
54
111

asked Jul 04 '16 at 05:39

user2819542

Please help me overcome this error. – user2819542 Jul 04 '16 at 05:39
You can [check all permissions over `Table2`](http://stackoverflow.com/q/3049085/4519059) ;). – shA.t Jul 04 '16 at 05:51
In application i find such scenarios in many places. So it is not that feasible to check permissions on all those tables :( – user2819542 Jul 04 '16 at 06:01

Two connections cannot be opened for an application role user

0 Answers0