SQL Reporting Services and SQL Anywhere Database Connection
I am very new at this so am groping around to figure out what is happening. In Visual Studio I can connect to my SQL Anywhere Database. In the SQL Reporting Services Report Server webpage I can not make the connection. When I look for drivers under ODBC outside of Visual Studio I do not see a SQL driver. When I try to deploy a report from Visual Studio I get permission errors. I ultimately want to some of the table information in a Sharepoint list which is another can of worms when I try to figure out Business Connectivity Services. Thanks. David
July 19th, 2012 2:50pm

Hello David, Thank you to post out your question on TechNet forum. From your description, I am confused what issue you encountered. I need your help to provide the following things when you encounter this issue. Please provide the screenshot of the error you encounters, and detail reproducing steps.Please clarify that which mode you are using for the reporting service, SharePoint Integrated mode or Native mode. They have different behavior and settings on deployment or management.Please post out the SQL server version. It is useful when we provide you the solution. If you have any other idea about this issue, please tell us freely. Regards, EdwardEdward Zhu TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
July 20th, 2012 6:16am

Thanks for the response. In SQL Services Reporting Configuration Manager it states: Product Version 10.5.2500.0 Report Server Mode : Native Report Service Status: Started. Screen capture for some reason is not installed on that server. I will need to go through the steps to get the error messages and post. Unfortunately, this is not my main job so it will take me a few days. Thanks. David
July 23rd, 2012 8:51am

Hello David, Thanks for your response. Please try to open the rsreportserver.config file under c:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ by default. In the file, please search <Data> node. The children nodes of <Data> are the supported SQL server providers. Please check whether SQL Anywhere has the extension, and which has been registered here. If you can find the connection in Visual Studio, but you cannot find it in ODBC driver, I consider that you does not find the correct ODBC driver dialog. Please open the application located c:\Windows\SysWOW64\odbcad32.exe, since Visual studio is using 32-bit ODBC driver. If you have any question about this issue, please let me know. Regards, EdwardEdward Zhu TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
July 24th, 2012 4:12am

Hi, Thanks for your continued help. You are correct on both points above. SQL Anywhere is not in the Data portion of the config file and it is present in the ODBC32 under the sysWOW64. David
July 24th, 2012 8:38am

Hi, This is a followup to the original question you asked about permissions. This is when I try to deploy a test report in Visual Studio. ------ Build started: Project: Report Project1, Configuration: Debug ------ Skipping 'Report1.rdl'. Item is up to date. Build complete -- 0 errors, 0 warnings ------ Deploy started: Project: Report Project1, Configuration: Debug ------ Deploying to http://localhost/reportserver Error rsAccessDenied : The permissions granted to user 'xxxxxx\davidkerr' are insufficient for performing this operation. Deploy complete -- 1 errors, 0 warnings ========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ========== ========== Deploy: 0 succeeded, 1 failed, 0 skipped ========== I also noticed I have multiple directories with same name though it says they are different type folders. Is that correct? They all say: C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER but with different properties: 1. OLAP 2. Reporting Services 3. MSSQL SQL Reporting Services Report Server Mode: Native Version: 10.50.2500.0 Thanks. David
Free Windows Admin Tool Kit Click here and download it now
July 24th, 2012 9:04am

I have figured out the permission issue so that is solved. It seems like it is ODBC issue and I may be stuck from what I have read. It is interesting because the report query in ReportBuilder will query the database but the report will not run.
July 25th, 2012 3:45pm

Hello David, Thanks for your response. I think that the permission issue is gone, and the remaining part is relative to the report cannot run on the server side. Please show us the connection string in Report Builder, which you can query the database. In addition, we need confirm that the drivers on report server are same as the servers on your develop machine. If you have further questions, please tell us freely. Regards, EdwardEdward Zhu TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
July 26th, 2012 3:50am

An update. I am also trying to integrate Report Services with Sharepoint. I think I have done this but now I can't access the webpage for Reporting Services except through Sharepoint. Once I get that sorted out I will send connection link. I did check and there is no ODBC driver 64 bit for SQL Anywhere though there is one for the 32 bit. I am thinking that the query uses the 32 bit but the report uses 64 bit. David
July 26th, 2012 8:33am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics