Thursday, December 30, 2010

ASP.NET Error : The SELECT permission was denied on the object ‘table_name’, database ‘table_name’, schema ‘dbo’.

Error caused by the subject not Add Permission can be modified as follows.

1. Open SQL Server Management Studio.
2. Look at the Object Explorer (left).
3. Select the folder>> Security>> Logins.
4. Select the User to use. Right-click on the shortcut menu, select "Properties".
5. When the window see the Select a page (left side).
6. Select the Server Role to Check "sysadmin" Press Ok.

No comments: