Crystal Reports Designer - Data Source for SQL Server RRS feed

  • Question

  • I have loaded Crystal Reports XI and what to connect to my Sql Server instance in the Crystal Reports designer.
    Authentication: Windows Authentication
    (In Gray) User Name: LAPTOP-BRENDA\OWNER
    Password is blank

    Crystal Reports
    OLE DB (ADO)
    Provider Microsoft OLE DB PRovider for SQL Server

    Server: assume it should be LAPTOP-BRENDA\SQLSERVER1
    User ID: assume it should be LAPTOP-BRENDA\OWNER
    Password: assume blank
    Database: adventurework2008
    Integrated Security unchecked

    SQL Server does not exist or access is denied. SQL State: 08001.

    How do I use SQL Server as my Crystal Reports Data Source?
    Tuesday, March 3, 2009 2:16 AM


  • Hi Brenda,

    You need to check integrated security to use Windows Authentication.  Otherwise, supply a sql login and password (for instance, not that I'm advocating it, "sa").

    Let me know if this works out for you.
    Aaron Alton | thehobt.blogspot.com
    • Marked as answer by TheBrenda Tuesday, March 3, 2009 3:02 AM
    Tuesday, March 3, 2009 2:41 AM

All replies