connect sql server using window authentication in asp.net

[satya chhikara]

Hi all , I am facing a problem . Please reply me if some one knows about it and mail me at satya_chhikara@centrum.cz .very urgent I made a project for a client. The client has two server one for data base and another for web server(asp.net web site). In data base server regarding their security issues they have window authentication for sql server . Both server are not in same domain and both server have public IP . I have tried the following things 1. Install 2 Windows Server 2003 (With SP1) 2. Install IIS in Webserver and SQL server 2000 with SP4 in DBServer 3. Create a User AlumniASPNET in DB and Web servers (with same password in both servers) 4. Add AlumniASPNET user in IIS_WPG group in Webserver. Configure default application pool to run with AlumniASPNET user identity and configure IIS to run Anonymous user as AlumniASPNET, AlumniASPNET will thereby be a member of the USERS and IIS_WPG groups only 5. Grant access for AlumniASPNET user for the Database, AlumniASPNET will only be a member of the USERS group 6. In web.config, use SSPI authentication and set identity impersonate to true After that I print Error message . It show time out. I guess that It is due to firewall . But they did agree . Now I want to show that I am sending connection request using proper account and password . Can it is possible me to print user name and password when I am sending request to data base server . satya chhikara