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.
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
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.