Connection to a SQL DB
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!