SELECT permission denied on object
Posted on 2006-06-16
Hi, i have an ASP application that i am using against an SQL Server 2000 box. This application worked fine on access but when upsized to SQL2000 i now have the following error...
Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'tblAnalytics', database 'live_xxxx', owner 'dbo'.
/process.asp, line 54
Line 52: Set RS = Server.CreateObject("ADODB.Recordset")
Line 53: SQL = "SELECT * FROM tblAnalytics WHERE ID = 0"
Line 54: RS.Open SQL,Connection,3,3
I have gone into SQL server and put permissions on everything i can find in that DB for the account that i have set up.....
Still not working,