Detecting Windows login info

Detecting Windows login info

Post by CSDun » Wed, 09 Apr 2003 04:25:32

I am in the process of moving the front end of our SQL Server 2000 databases
from MS Access 2000 Projects to ASP.NET.

Access 2000 Projects have allowed me to use the 'SYSTEM_USER' of a
Windows log in to SQL Server 2000 for the purposes of designing Views and
Stored Procedures in such a way that the data presented in Project Forms
and Reports could be customized for the logged in user (SELECT.....
WHERE 'Field name' = (SYSTEM_USER)).

These Access Project applications (ADP's) are used by school teachers with
Windows accounts. The ADP files open a connection to SQL Server, and the
users are Authenticated per their group membership as Windows logins in SQL
Server. On the database side, the main table for the teacher data has a
vchar column that contains a text string in the format of 'domain\username'
for each teacher, and is used to filter for 'SYSTEM_USER' in Views and
Stored Procedures.

Without the use of Windows log in accounts to SQL Server 2000 in an ASP.NET
application, is it possible to achieve the same level of
customization without requiring an additional log in for the user on the
ASP.NET page? If so, how would I approach this? If not, what can I do when
working with ASP.NET applications to get this kind of customization without
requiring the user to initiate a separate log in for the ASP.NET

Thanks for your help!



1. Login Failure : How to detect Login Failure in OleDbConnection

If I give wrong  login parameters( wrong username or wrong password)  fail
when I login using

    OleDbConnection = new OleDbConnection(source);
catch ( Exception e){

It doesnot go to the catch Exception section.

I want to findout if the login parameters are successful before trying a SQL
statement. Right now, I get the error message ( if the login fails ) when I
try to run a query against the database. I want to findout before I query
the database if the login is successful. Is there any paramter in
OleDbConnction which will tell me if the login is successful.

Thanks in advance,

Raja Kanthadai
Allegro Development

2. HELP! I can't backup with my Colorado Jumbo 350!

3. Problem detecting browser/OS info on NT4

4. Lint wanted for 6809

5. Prompt for login info

6. Merry Christmas Everyone!

7. Detect Screen Lock and Login Status with API

8. TV menu bars

9. database login info

10. Dynamically detect and display User Login status!

11. How do I Detect a dialog box which appears randomly from another Windows Program?

12. auto list, auto type info, code comments, auto parameter info

13. Login Page creation in ASP.NET using C# (without using the Login Control)