I can login to the website, but then when I click on Enter Store Admin at the top I get errors everywhere.

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 'DSC_Parse_Ids', database 'AKDB', schema 'dbo'.

http://support.dotshoppingcart.com/forums/Home/tabid/36/forumid/3/threadid/257/scope/posts/Default.aspx

<font color="#0000ff" size="2"> How do I run these commands?

GRANT SELECT ON

[dbo].[DSC_Parse_Ids] <font color="#0000ff" size="2"><font color="#0000ff" size="2">TO [DSC_Public]

Open SQL management studio and connect to the DB and run the following SQL script

ADD SIGNATURE <font color="#0000ff" size="2"><font color="#0000ff" size="2">TO [dbo].[DSC_Order_GetByDateRangeAndStatusList] <font color="#0000ff" size="2"><font color="#0000ff" size="2">BY CERTIFICATE dynamicCert <font color="#0000ff" size="2"><font color="#0000ff" size="2">WITH PASSWORD = <font color="#a31515" size="2"><font color="#a31515" size="2">'dsc dyn@mic2007'

I ran that along with the GRANT SELECT ON to [DSC_Parse_Ids] and [DSC_Orders] and it works great.

Thanks!

You don't need to grant Select to DSC_Order because they loosen the table DSC_Order  permission. Here is the complete fix.