I'm newbie in ASP.NET. I Have successful install E-Commerce Starter Kit, and I can modify database with SQL Query Analyzer.

Now I use Webmatrix Hosting to make my Starter kit Online. But I can't modify the table.
If I use SQL Query Alayzer with command:

UPDATE [ekosutjipto_commerce_vb_sdk_1].[CMRC_Categories] SET CategoryName = 'Internet' WHERE CategoryID = 14

I should have the Error like this:
Server: Msg 229, Level 14, State 5, Line 1
SELECT permission denied on object 'CMRC_Categories', database 'H_ekosutjipto', owner 'ekosutjipto_commerce_vb_sdk_1'.

Can someone help me ?

Please.....

Eko Sutjipto

Hi,

I believe the problem is that your login owner 'ekosutjipto_commerce_vb_sdk_1' does not have the permission to update the table.

You need to GRANT permission to the user, or update the permission for the user.

Any DBA's care to help here?