<div>
Prior to upgrading to MS SQL Server 2008 R2 they did not get the prompt to login. I just switched the report to use Windows Authentication and that will work for now.<br />
<br />
The just browse out to the rpt and double-click.
</div>


Prior to upgrading to MS SQL Server 2008 R2 they did not get the prompt to login. I just switched the report to use Windows Authentication and that will work for now.

The just browse out to the rpt and double-click.

<div>
<div class="content wysiwyg-content">
What is the proper way to set up a connection string for Crystal Reports X to access a SQL Server 2008 R2 database? I need to use SQL authentication and I had type everyhting I thought I needed into the GUI and I saved the report, but when I exit Crystal and go back in when I run the report it asks for the credentials.
</div>
</div>


What is the proper way to set up a connection string for Crystal Reports X to access a SQL Server 2008 R2 database? I need to use SQL authentication and I had type everyhting I thought I needed into the GUI and I saved the report, but when I exit Crystal and go back in when I run the report it asks for the credentials.

Crystal Report X SQL Server 2008 R2

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.