You need to make sure that you use a valid login. This means either you specify a username and password on the connection string or you use a trusted connection and make sure that the account that ASP.Net is running under is included in the permissions for the database (as a Logon with the proper rights).
+++ Rick ---
>Hi,
>
>I am attempting to deploy an asp.net application on a new production server but can't get the app to login to the sql server 2000 development edition northwind database. Can someone give the steps that insures that aspnet has access to the northwinds database. I used vs.net to determeine the connection string by setting up a temp web form and droping an sql connection object on the form. I then made a new connection to the object, made certain that I was connected Northwind and then copied the connection string (minus double quotes) back to web.config. When my app attempts to access Northwind I get the error: SELECT permission denied on object 'Users', database 'Northwind, owner 'dbo'.
>
>I must have been lucy previously because I installed sql server( development version ) on my development server and I don't have this problem. I am using windows authentication.
>
>Thanx,
>Neil