I've just made a .bak file of my SQL 2005 Express, created a new user and set that user to the database, but when I run my page, I get this error:

 

The SELECT permission was denied on the object 't_music', database 'notesnhac', schema 'dbo'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The SELECT permission was denied on the object 't_music', database 'notesnhac', schema 'dbo'.

 

 Any idea?

Thank you very much,

Kenny.
 

Might sound silly, but did you also give that user "Read" and "Write" permissions on the database when you made the user (I think, I can't find a screen in the DNP to change it but I know I saw it, might be only when you make the user).

I would just make a new user and give it all the permissions possible and see if it works.  Not having Select Permission on the dbo schema is truely odd.

I am guessing you then restored the DB online with the SQL Express DB .bak file.  If you want I will post the steps I've used in the past to do that.

---

-Wilson Gearld Mead III
www.rangoric.com (Rather Blah)
blog.rangoric.name (Closer to Not Blah)

When I create a new user for the database, there are only options for username/password, and the select what database... there are no other options so how can I set/change the permission, etc... I've looked at the MyLittleAdmin page too and there isn't any place to change user permission either, or it's hidden somewhere that I don't know off.

 Any help from the tech. here?

Thank you,

Kenny.
 

1. When you restored it the first time, did you get any error messages in DNP or did the page timeout?

2.  When you run a query on that table in MyLittleSQLAdmin, do you get the same error?

3.  When you run a query on that table in SQL Server Management Express Studio, do you get the same error?

I would say restore your database again and see if that helps.  If not, submit a ticket to support@ultimahosts.net

---

William Eaton, MCSE
iTech Computer Solutions, LLC
www.itechcs.com