How to Add SQL Server Connection in Crystal Report

Crystal Reports connection String SQL Server

I worked in Crystal Report for quite a while but even I got confused how to add SQL Connection when I installed Crystal Reports on a new sytem. Basically there were no existing connections under any of the options and it was not every intuitive how to add a connection string.

1. Simply double click OLE DB (ADO)

2. This will popup a dialog, go to the very bottom in the list and choose SQL Server Native Client.

That’s it! Check the checkbox for integrated security and select  your server. You should be all set.

2015-04-25 12_14_30-OLE DB (ADO)

 

Advertisements
This entry was posted in Tutorials/Tips and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s