[RESOLVED] Crystal Reports VB.net connection error

[cengineer]

ERROR:
logon failed
Details: ADO Error code:0x
Source: Microsoft OLE DB Provider for SQL Server
Description: Invalid authorization specification

or

Description: Login failed for user cengineer
SQL State: 4200
NAtive error

I am trying to generate crystal reports from visual studio..net 2008 and my database is created using SQL server management studio express 2005. I am getting login errors when using the OLE DB for SQL Server source. In studio express I use SQL server and windows authentication and I have tried leaving the user ID and password blank and putting in my login details but still getting the error. I have enabled multiple connections to the database.

Any ideas appreciated.

[cengineer]

Nevermind; had to check the integrated security checkbox.