Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Crystal 6 and windows authentication Post Reply Post New Topic
Author Message
JustForFun
Newbie
Newbie
Avatar

Joined: 15 Jul 2008
Online Status: Offline
Posts: 2
Quote JustForFun Replybullet Topic: Crystal 6 and windows authentication
    Posted: 15 Jul 2008 at 3:29am

Our database will be upgraded from SQL2000 to SQL2005 and we are required to switch to windows authentication for all our VB6 applications. The apps use Crystal 6. Any suggestions/advise how to link our reports to sql with windows authentication?

IP IP Logged
dqueijo
Newbie
Newbie
Avatar

Joined: 23 Jul 2008
Location: Uruguay
Online Status: Offline
Posts: 3
Quote dqueijo Replybullet Posted: 23 Jul 2008 at 5:29am

Hi!

I am having a similar problem.
 
Have you figuered this out?
 
Thanks
IP IP Logged
JustForFun
Newbie
Newbie
Avatar

Joined: 15 Jul 2008
Online Status: Offline
Posts: 2
Quote JustForFun Replybullet Posted: 23 Jul 2008 at 5:38am
Yes,Big%20smile
 
create an odbc that uses windows authentication to connect to your database.
 
change the Connect property of your report to be Connect = "DSN=Name of ODBC"
 
Then do the next set of instructions (courtesy of the help in crystal):
 
How to change the ODBC data source accessed by a report
1 Choose the Set Location command from the Database menu. The Set Location dialog box appears with a list of table aliases for the tables in the report displayed. Table location and log on information for the table you highlight will also be displayed below the list of tables. Select the first table in the list and click the Set Location button.
2 Highlight the first table in this list.
3 Click the Set Location button.
4 Log on to the original ODBC data source if you are not logged on already. You must first log on to the old data source before you can change a report to use a new data source. Since you must be logged on to the old data source, the old data source must be available on the local machine.
n If the machine is no longer connected to the old server, you can install an ODBC data source with the name of the old data source and have it point to the new database server. Log on to this data source as the “old” data source.
n If you are using the same data source name to connect to a new server, you must configure that data source under ODBC Admin or the ODBC Control Panel, and make it point to the new server.
 After logging on to the old data source, you will see the Choose SQL Table dialog box with a list of tables in the SQL Tables list box and the old data source in the SQL Databases list box.
5 Click the Log On Server button to log on to the new data source. You should now be logged on to both the old and the new data sources.
n The new data source should now appear in the SQL Databases list box of the Choose SQL Table dialog box.
6 Click the new data source to display its tables, then select the appropriate table from this list. The table you choose should correspond to the first table you selected in the Set Location dialog box.
7 Click OK and you are prompted to change the location of all tables in the report to the location you specified for the first table.
8 Click Yes to set the location of all tables in the report to the same database.
9 Close the Set Location dialog box, and choose the Verify Database command from the Database menu to refresh the table definitions in the report.
10 Log off the old data source.
11 Save the report.
IP IP Logged
dqueijo
Newbie
Newbie
Avatar

Joined: 23 Jul 2008
Location: Uruguay
Online Status: Offline
Posts: 3
Quote dqueijo Replybullet Posted: 23 Jul 2008 at 7:06am
Great!
 
Thank you Smile
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.035 seconds.