locked
SQL Reporting Services and SQL Anywhere Database Connection RRS feed

  • Question

  • 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

    Thursday, July 19, 2012 6:47 PM

All replies

  • 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,

    Edward


    Edward Zhu

    TechNet Community Support

    Friday, July 20, 2012 10:16 AM
  • 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

    Monday, July 23, 2012 12:36 PM
  • 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,

    Edward


    Edward Zhu

    TechNet Community Support

    Tuesday, July 24, 2012 7:54 AM
  • 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

    Tuesday, July 24, 2012 12:20 PM
  • 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


    • Edited by davidkerr Tuesday, July 24, 2012 12:53 PM
    Tuesday, July 24, 2012 12:47 PM
  • 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.


    • Edited by davidkerr Wednesday, July 25, 2012 7:50 PM
    Wednesday, July 25, 2012 7:29 PM
  • 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,

    Edward


    Edward Zhu

    TechNet Community Support

    Thursday, July 26, 2012 7:50 AM
  • 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

    Thursday, July 26, 2012 12:33 PM