Cannot Pass Database Login Info when Opening Crystal Reports
Hi,
I just recently installed Crystal Reports Enterprise Server XI R2 on a Windows 2003 SP2 Server using a sql 2005 express database instead of the canned mysql. I am trying to free up my sql 2000 licenses by using the free version but not having luck so far.
Whenever I go to open a crystal report on a sql server, i am prompted with a login prompt. I went into the business view manager and set the data connections to never prompt and took the defaults when publishing the report "to prompt user for database login", but i am still getting the login prompt. The login credentials to the CMS database are the exact same as the credentials used on the sql server. I am at wits end here, not sure what else to try. I would hate to have to go back to the sql 2000. I am just wondering if sql 2005 express does not work with this version of crystal. TIA
I just recently installed Crystal Reports Enterprise Server XI R2 on a Windows 2003 SP2 Server using a sql 2005 express database instead of the canned mysql. I am trying to free up my sql 2000 licenses by using the free version but not having luck so far.
Whenever I go to open a crystal report on a sql server, i am prompted with a login prompt. I went into the business view manager and set the data connections to never prompt and took the defaults when publishing the report "to prompt user for database login", but i am still getting the login prompt. The login credentials to the CMS database are the exact same as the credentials used on the sql server. I am at wits end here, not sure what else to try. I would hate to have to go back to the sql 2000. I am just wondering if sql 2005 express does not work with this version of crystal. TIA
ASKER
I am testing from the crystal management console itself. The reports were most likely created in version 9 and were imported using the import wizard from another crystal test server to this one. The one i am currently working on now is going to be the permanent one, i just have it on another test server so there is no interruption to the users during the migration
I tried all those steps and it still prompts for db login info. I even created connections in the business view manager and set it to not prompt and it still does.
I tried all those steps and it still prompts for db login info. I even created connections in the business view manager and set it to not prompt and it still does.
Wow, interesting.
Which option is checked on the Process, Database tab? "Use original database logon information from the report" or "Use custom database logon information specified here"
And, is there only one Data Source? If there are more than one, you have to set each password separately, but you probably have checked that already.
And, "Prompt the user for database logon when viewing" should be unchecked, correct?
If all of that checks out, and since it sounds like this is a test environment, reset the password at the database, rekey it into Crystal Management Console, and try it again.
To test that the password is working, you could connect to the database using any ODBC connection (Access, SQL Tools), and use the login credentials you'll be resetting in the suggestion above.
Which option is checked on the Process, Database tab? "Use original database logon information from the report" or "Use custom database logon information specified here"
And, is there only one Data Source? If there are more than one, you have to set each password separately, but you probably have checked that already.
And, "Prompt the user for database logon when viewing" should be unchecked, correct?
If all of that checks out, and since it sounds like this is a test environment, reset the password at the database, rekey it into Crystal Management Console, and try it again.
To test that the password is working, you could connect to the database using any ODBC connection (Access, SQL Tools), and use the login credentials you'll be resetting in the suggestion above.
ASKER
"Use original database logon info" -checked
one data source
"prompt the user for database logon"-checked (this option should be checked)
going to try resetting database password and rekeying. i will let you know how it goes
one data source
"prompt the user for database logon"-checked (this option should be checked)
going to try resetting database password and rekeying. i will let you know how it goes
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I had that option checked before and it works just fine. it just grabs the db login info from the report itself and passed it on. i think i might be onto something here though. i had all my machine dsns setup for my odbc connections and just added a fille dsn also for the hell of it. what do you know, one of the reports opened up. i will keep you posted.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Issue was solved by requester
If you're in the Crystal Management Console, try entering the password, clicking Update at the bottom of the page, then back on the Properties tab of the Object, click Update again, then click Preview.
Do you get a request for a password?