I'm trying to use Crystal Reports in Visual Studio 2008 to make a 3D chart. However, I'm having a problem making a connection to the MS SQL database. I get an error saying Logon failed, SQL State 42000.
I tried using several different connections from the Database Expert wizard, including the OLE DB (ADO) provider for SQL Server, SQL Native Client, and SQL Server Native Client. I used the same connection information as I found in SQL Server Management Studio, trying both with and without the Integrated Security checkbox, and trying the username both with and without the server name preceding it.
What is the correct way to make a connection?