pdfcreator permission to use object denied

Response.Redirect(PDF_REPORT_PATH & PDFname)ġ- Run 'Microsoft SQL Server Management Studio Express'Ģ- In the 'object explorer' expand the 'Security' folder, go to logins and check if the user which you want is exist, if not thenģ-Right click on the 'logins' folder and select 'new login.' and in the new window search for the account which you want and add it and give him the needed mappings.Ĥ- NOW go to the database which you are using for your application expand it and go to security folderĥ- under user folder add new user and search for your user which you've just added and give him the appropriate permisions on your database OExO.ExportFormatType = ExportFormatType.PortableDocFormat OExO.ExportDestinationType = ExportDestinationType.DiskFile OExDo.DiskFileName = Server.MapPath(PDF_REPORT_PATH) & PDFname ' THIS IS THE IMPORTANT LINE THE NAME OF THE STORED PROCEDURE ' SQL State: 42000 Native Error: Failed to openĪ rowset. Details: ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: The SELECT permission was denied on the object 'MyTable', database 'MyDatabase', schema 'dbo'.

I have my asp.net application with crystal reports which is using OLE DB connection, when I published the application on my test server every thing was ok and I was able to view,print and exprot my reprot (test server is not a domain controller),īUT when I published the application on the production server which is a domain controller it is giving me this error:įailed to open a rowset.

Pdfcreator permission to use object denied