This question was posted previously at
http://p2p.wrox.com/archive/aspx_beg...2002-12/16.asp

Thread: SELECT permission denied on object 'Shippers', database 'Northwind', owner 'dbo'.

Question: I installed the samples for ASP.NET 1.0 Professional and I am getting this error from my netSDK SQL Server using Windows
Authentication...searched web and here but could find answer. Thanks in advance!

Best solution:

First read this
http://web.lemoyne.edu/courseinforma...SDE_ReadMe.doc

and do this step by step

1. CONFIGURING THE PATH VARIABLE for
C:\Program Files\Microsoft SQL Server\80\Tools\Binn

2. CONFIGURING THE ASPNET USER ACCOUNT - at the command prompt do this

osql -E -S (local)\NetSDK -Q "sp_grantlogin 'MACHINENAME\ASPNET'"

3. CONFIGURING INDIVIDUAL DATABASES - at the command prompt do this

osql -E -S (local)\NetSDK -d Northwind -Q "sp_grantdbaccess 'MACHINENAME\ASPNET'"

osql -E -S (local)\NetSDK -d Northwind -Q "sp_addrolemember 'db_owner', 'MACHINENAME\ASPNET'"

Note: Replace the 'MACHINENAME' with the name of your server.

Enjoy
Regards

Thx for the solution. It work for sql server 2005 express and .Net Framework 2.0.

Great job.