cancel
Showing results for 
Search instead for 
Did you mean: 

Login Information

Former Member
0 Kudos

We recently moved our crystal enterprise to a new server. In doing so, we now have a couple of reports that include excel spreadsheets that no longer automatically connect. We have the option checked "use same as database login", however the user is prompted to enter this information for the spreadsheet. It's almost like a "looping login" issue. Any idea how we can get this fixed? Any help will be greatly appreciated.

Accepted Solutions (1)

Accepted Solutions (1)

roland_hoeller2
Active Contributor
0 Kudos

Hi

This seems to be a problem with the access to the Excel file. Is it on a network share?

Then the Job Server (SIA) needs to be started with a user account that has access to that share. The share needs to be specidfied as a UNC path
servername\directory

If the Excel file is on the same server as your Job Server please make sure the accout the Job Server is started with has access to the file.

Kind Regards

Roland

Former Member
0 Kudos

That was it! When we migrated we migrated from Windows Server 2000 to 2003. Now that I pointed it to the spreadsheet, using UNC path, it worked like a charm.

Thanks for the help. It is greatly appreciated.

Answers (0)