Home > IT Answers > Development > Connecting Crystal Repor2008 to SQL 2005 data...
Help

Question

  Asked: May 9 2008   11:14 PM GMT
  Asked by: Antillas

Connecting Crystal Repor2008 to SQL 2005 database


Crystal Reports 2008, Crystal Reports, 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

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
Last Answered: May 11 2008  7:50 AM GMT  by Mrdenny




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.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Development, DataManagement and SQL Server.

Looking for relevant Development Whitepapers? Visit the SearchWinDevelopment.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Antillas  |   May 11 2008  10:16PM GMT

I have “administrator” as logon user in the SQL server, however remotely am not succeeding.