Change from User,Password to Win Authentication

[StormbringerX]

Hi all,

Recently my company changed from using User Password info to log into SQLServer to using Windows Authentication. I'm currently having a problem with making Crystal Reports understand that I need to logon using the Win Authentication. I've tried changing the Database Location information but with no luck. The code that was being used is as follows:

'Log it on
For intLoop = 1 To intNoTables
crReport.Database.Tables(intLoop).SetLogOnInfo strServerName, strDatabaseName, strUserName, strPassword
Next

Admittedly I'm not some sort of Crystal Reports Super User. Can anyone point me in the right direction?

Thanks
Dave

 

[IdoMillet]

This is a knows technical issue. Crystal is trying to use the User ID stored with the table even though the authentication should be using the User ID logged in to the PC.

Change the code to strip away the user info:
----------------------------------------------------
crReport.Database.Tables(intLoop).SetLogOnInfo strServerName, strDatabaseName, "", ""
----------------------------------------------------

Cheers,
- Ido



CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[StormbringerX]

Thanks for the information, IdoMillet.

I made the changes and am still receiving the dreaded 'Server not opened' message. Do I still need to change the database location or some other modifications? I hate to sound like a bonehead, but it seems there is still so much I need to learn about how CR integrates with database structures and while I know the information is out there, I guess I need to learn more to know HOW to ask the question correctly....

Thanks again
Dave