Hi Leland,

To tell the truth, I don't understand all this stuff. However, I added one more user for my database, and this fixed the problem, I was having. So, at least I can now show records from my table.

Now I have bunch of other newbie questions, but before I understand them, I can not go further.

1) How can I identify user of my WEB application? More precisely, how would I know, that this user has not created a shopping cart yet, so I have to generate an ID? What's the scope of variables in the WEB environment?


>Hi Nadya,
>
>Can you log in a the System Administrator, (e.g. sa). If you can, then you should be able to change the username/password pair assigned to Northwind Table through the MSSQL database administration GUI.
>
>Since your building an app for the web, passwords and logins will probably not be an issue. When you access the MSSQL via the web, it is being accessed locally as localhost rather than remotely; because, it is really being called by the web server via an asp script. You might consider setting up Trusted Authentication during application development. When the app is ready, you can enter the host as localhost and the username/password pair need to access the apps tables. Later you could delve more deeply into MSSQL authentication/security.
>
>LelandJ