Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Enterprise - Logging on to SQL Server Named Instance

Status
Not open for further replies.

mahonm2

IS-IT--Management
Aug 11, 2003
3
US
Anyone know how to access a SQL Server Named Instance for a report published in Crystal Enterprise v10?

I am trying to run a report in Crystal Enterprise that uses a SQL Server Named Instance as its data source. I have the ODBC setup on the Crystal Enterprise Server which works fine. When I try to run the report, it keeps telling me my logon information is incorrect.

If I change the ODBC connection to use the database listening on the standard port (1433), the report runs fine.

The report also runs fine if I view it using Crystal Reports.


Thank you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top