Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Connection to a SQL DB

Good Afternoon,

First time poster so bear with me - I have a, I'm sure basic query, but for love nor money I can not find the solution. Apologies in advance if this has been raised somewhere else:

I have Crystal Reports 13 running as a desktop application and a datasource in the form of a SQL Server DB in a different environment.

My questions are:

  • As I need to request a firewall change, what port number does Crystal use to query a DB? Is this the standard 1433?
  • On the DB I am querying, what privileges do I need? DBO, read & write? Just Read?
  • I have watched several videos with the connections, however some indicate the connection should be through the ODBC Data Source Systems DSN first, whilst others point to the connection wizard in Crystal first.

Any information would be great!

Many Thanks,

James

Former Member
Not what you were looking for? View more on this topic or Ask a question