Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to change database from Win Auth to SQL Auth
Message
 
 
To
All
General information
Forum:
ASP.NET
Category:
Reporting
Title:
How to change database from Win Auth to SQL Auth
Miscellaneous
Thread ID:
01110074
Message ID:
01110074
Views:
71
I have created a crystal report with Crystal Reports.NET .

When I added the tables from the database to the report, I used Integrated Security (Windows Authentication). I have found that trying to SetDatabaseLogon has been prompting me for logon information at run time. I suspected it might be the authentication setting, and recreated the report, adding the tables using SQL authentication and the prompting stopped.

The problem is I have several intricate reports that I would rather not recreate: I'd like to just find some screen where I can set/change the existing authentication.

Does anyone know how to do this, or do I need to recreate the reports?

Thanks,
Rick Hodder
MCP Visual Foxpro
C#, VB.NET Developer
Independent Consultant
www.RickHodder.com
MyBlog
Next
Reply
Map
View

Click here to load this message in the networking platform