We have an application running within a windows server, with the following vb6 code to connect to it's sql 2008 instance:
cnn.Open "Provider=SQLOLEDB; " & _
"Initial Catalog=" & dbname & "; " & _
"Data Source=" & sqlserver & "; " & _
"integrated security=SSPI; persist security info=True;"
(Which makes the sql connection 'Provider=SQLOLEDB; Initial Catalog=DBNAME; Data Source=SQLINSTANCE; integrated security=SSPI; persist security info=True;
If the user is administrator, all works great, if the user is non-admin, doesn't connect and displays "Error number: -214721783".
We went into sql to the problem table and granted permission to select/delete/insert/updat
e and still same error. Note that the non-admin user has access to all other tables with the database, it's only with this table; thus, sql permission of some sort.