Yes that was the problem. I am using xp prof on my development server and windows 2000 server on my production server. It appears that sql server (development version) installs differently in the 2 operating systems. All I had to do was make aspnet a user of the northwind database and the login was done *automatically* for me in the xp prof. install. This is not the case for the 2000 server install. That is why I did not even think of checking the login permissions on the production server. And... I am now experiencing a new problem with the mm.net security tables on the 2000 server deployment that I am not having on the xp development server. Would you be available to help with mm.net security table problems on my production server?
I am having a problem related to FK constraints on the production server that I am not having on the development server. I deployed the asp.net (with the controlID properties programmed for the secure controls) without the security tables. I later installed sql server 2000 on the development box and ran mmSecurity.sql, which built the security tables from scratch. Should I have deployed the security tables that were on my development box, which specifically had secure control controlID data and not built them from scratch?
Neil

>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