I am a novice Crystal and SQL user, but have a SQL Server Express 2008 database connection established and am trying to reach that connection through my newly installed Crystal Reports. I connect to SQL using Windows Authentication, but Crystal is asking me for a UserName and Password in order to make a connection.  Can someone help me get started here, please?  I would be much obliged!

I already can and do login to SQL through Windows authentication.  I don't know how to login using SQL Server authentication, as I don't know a UserID or Password.  I've tried by OLEDB and ODBC, but in both cases they're looking for a userid and password.

 

MaryFran:

It sounds like you've just about got it. I'm not sure if the following is what you're doing, but I've connected to SQL databases from Crystal several times and this has always worked for me.

In the Database Expert, select Create New Connection and choose OLE DB (ADO). Select the Native SQL Client provider from the list (you have to scroll down to the bottom).

Select your data source from the drop down, and the database. Check-off "Integrated Security", and click Finish, not Next. If you click Next, you will end up getting an error, you must click Finish.

Try that and see how it goes.