Bypass OLE DB (SQL) User Name and Password

[Former Member]

I have created several reports using Crystal Report Writer XI and have placed them on a Windows 2003 Server which holds the Report Application Server 9 application.

The users access the reports using Internet Explorer.

The report comes out great but there is one annoyance. Everytime the reports are accessed the user must enter a user name and password for the Microsoft OLE DB Provider for SQL Server. The reports are accessible to all and I do not need the login. Is there a way that the reports can be generated without this and if so, how?

Thank you,

Ron

[former_member260594 · Accepted solution]

Ronald,

Try setting the OLEDB connection to use Integrated Security, this will pass the users Windows Username to the database. If the database is set up to allow Windows users to access the databsae then it will not prompt them to enter their credentials.

FYI, the prompt is coming from the OLEDB connection not Crystal.

[Former Member · Accepted solution]

I am in the SQL Server Enterprise Manager of the server that my database is stored (Windows Server 2003). I went into the SQL Server registration properties and changed it from Use Windows Authentication instead of Use SQL Ser Authentication. I tried to changed the Integrated Security setting under one of my reports from False to True but it would not save. How do I change this?

Edited by: Ronald Kozak on Aug 21, 2008 6:30 PM

[Former Member · Accepted solution]

I have finally figured it out after all of this time.

On the server that the reports are stored I did the following:

Opened the SQL Server Enterprise Manager

Selected MS SQL Server and then the server that my database is stored on

Double clicked the Security folder

Double clicked Logins

Double clicked on the username that I have been using to create the reports

Made the password field blank and selected OK

Confirmed the new password and checked the box for Blank Password and selected OK

I can now access all of my reports via Internet Explorer without the pesky username and passwork prompt