Last post Aug 04, 2011 11:41 PM by Damon Liu - MSFT
Jul 30, 2011 08:02 AM|jitendra2cool|LINK
i have created a website using visual studio 2008.
Now i want to create a crystal report.
I selected crystal report through Add new item wizard & trid to connect to Microsoft OLEDB Provider for SQL Server using OLEDB(ADO) wizard.
But i was not getting server name in connection drop down list in data expert.
So please guide me in this matter.
Jul 30, 2011 09:53 AM|Gayomard Mehta|LINK
Well are you able to connect to your server in the SQL Server Management Studio/Query Analyser. If so then just type in the name of the server and credentials and do a test connection. It should work.
Aug 01, 2011 03:29 AM|jitendra2cool|LINK
Thanks for reply.
I am able to connect my server in the SQL Server Management Studio/Query Analyser with Windows Authentication.Also in my web site, server explorer window showing connection to my databese.mdf file.
When tried to connect my database using Crystal Report Viewer wizard, i got name of my server in OLEDB(ADO) connection information wizard.
But i could not get the name of my database in drop down list. when i tried to finish with my OLEDB connection, i got the following error.
Logon failed.Details: ADO Error Code:0xSource : Microsoft OLE DB Provider for SQL ServerDescription :Invalid authorization specificationSQL State: 28000
so pls guide me in this matter.
Aug 04, 2011 11:41 PM|Damon Liu - MSFT|LINK
Please check your server name, you need to connnect the propery server when you create your report using wizard.
more about create crystal report using wizard you can refer to the link:http://www.codeproject.com/KB/aspnet/Crstalreportusingvs2010.aspx