I have loaded Crystal Reports XI and what to connect to my Sql Server instance in the Crystal Reports designer.
Server Name: LAPTOP-BRENDA\SQLSERVER1 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 NEXT
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?
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").
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").
