NT Authentication

[PavanKumarU]

Hello all,
I have a 'process' related question. First a little bacground on our evironment:
We are using Crystal Report Application Server 9
with SQL Server 2000 and asp coding.
We have developed an application in asp where users can select a report, provide values to the stored procedure parameters, view the report output using the activeX viewer. To log on to the report as well as the database we are using single userid, that we have provided with the system dsn on the web server as well as hard coded in the asp app.
Now we want to do this:
We would like to move away from this hardcoding of userid and password and provide NT authentication login. In other words, user when logged into our corporate enviroment, should be able to access reports and run them WITHOUT asp providing any specific logon, but to use the current users logon. I am not able to get this working. Any ideas?
I have checked Crystal's website and support groups, in vain.
Any help is much appreciated.
Thanks
Pavan

 

[RamaKommineni]

Hi i am instantiating CR Viewer in Cold Fusion & VB Script code and connecting DB dynamically to view report on browser.

though i am not using NT authentication, following is my idea.

1.get NT authentication info either into Client Variables or Server side variable for that session.
2. Use that in following code if same/similar for ActiveX viewver too..

websource0.AddParameter "user0" "NT UserId from Variable"
websource0.AddParameter "user0" "NT pwd from Variable"

it would help you to work out your req i think..
Pls let me know if this idea works for you sothat i can also implement if i need to do same in my app in future..

thanks
Rama Kommineni