Connecting Crystal Repor2008 to SQL 2005 database

15 pts.
Tags:
Crystal Reports
Crystal Reports 2008
SQL Server 2005
Via Crystal Report2008 I have to produce a number of reports collecting data from a SQL2005 database running on another computer(2). This computer is not in my domain, but in a workgroup. However, the computer has the same IPaddress category. Anybody can help me with the steps to connect to the SQL database? Thanks Edgar
ASKED: May 9, 2008  11:14 PM
UPDATED: May 12, 2008  1:19 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

You will need to create a SQL logon (not a Windows Logon) within the SQL Server which has rights to the data or stored procedures which your report needs access to. Then in the connection string for the report enter the SQL Server name or IP when prompted, as well as the username and password for the logon you created.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Antillas
    I have "administrator" as logon user in the SQL server, however remotely am not succeeding.
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following