none
Reporting service 2005 An error has occurred during report processing. Cannot create a connection to data source RRS feed

  • 问题

    • An error has occurred during report processing.
      • Cannot create a connection to data source 'test'.
        • An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
        •    
        • remark:data source'test' is SQL2k database.  How can I do? Thanks in advance!
    2010年9月12日 13:57

答案

  • Buildin\administrator is local account on RS machine, it doesn't have permission to access remote sql.
    2010年9月13日 14:30
  •  

    你的问题是报表连不到数据源.

     

    而数据源的设置有两种,一种是用的共享数据源连接,一种是rdl内置数据源连接,关键是你用的是哪一种.

     

    现在共享数据源试过了不行.

    那你试着改一下内置数据源连接,

     

    步骤如下:

    打开http://localhost/reports

    导航到你的报表

    打开该报表的属性(Properties)Tab->再打开数据源(Data Source)子Tab

    查看你的连接字串是否正确

    注意:连接字串中不能有登录账号相关的信息

    登录账号要在下方设置

    根据你的情况设置后点"应用(Apply)"就行了.

     

    2010年9月14日 1:40
  • 1) Open SSRS log, it will tell you more details about the error.

    2) The error most likely is the Authentication issue, check the data source connecting string and connect account in the Reporting Services Manager if you are using the Shared data source.

    3) Probably not the case, but just try it: in the Reporting Service Configuration Manager, you have to check the Report Server Service Account, in your case - I am assuming your two machines (sql2k and sql2005) are in the same domain, try to use the domain user account instead of the built-in account, and ensure the domain user account has the enough permission on the w2k sql instance.

    2010年9月14日 2:03
    版主
  • where can I find the SSRS log?


    Take a look at this article:  http://www.bridata.ca/blog/?p=172

     

    2010年9月14日 13:18
    版主

全部回复

  • How did you set data source? How to logon to sql2k in that data source?
    2010年9月12日 16:45
  • I am not very clear your meaning.  But I set the data source as normal. And I can see the report in visio studio, but I can not see it in http://localhost/reports and I got the information like before I put.
    2010年9月13日 1:39
  • Are RS and sql2k running on same machine? Can you connect to sql2k from RS machine? 
    2010年9月13日 2:54
  • 打开http://localhost/reports

    进入 Data Sources目录, 点击你的共享数据源进入编辑状态.

    查看你的连接字串是否正确

    注意:连接字串中不能有登录账号相关的信息

    登录账号要在下方设置

    根据你的情况设置后点"应用(Apply)"就行了.

    2010年9月13日 3:45
  • Are RS and sql2k running on same machine? Can you connect to sql2k from RS machine? 


    no, on different machine.  Yes, I can connect from RS to sql2k in VS2005 when I make the report, and I can see the report result in preview in VS2005.

     

    2010年9月13日 12:22
  • 打开http://localhost/reports

    进入 Data Sources目录, 点击你的共享数据源进入编辑状态.

    查看你的连接字串是否正确

    注意:连接字串中不能有登录账号相关的信息

    登录账号要在下方设置

    根据你的情况设置后点"应用(Apply)"就行了.

     试过了,还是不行
    2010年9月13日 13:53
  • Did you check data source for the report? How to logon sql in data source? What's RS service account? Does it have permission to access sql2k?
    2010年9月13日 14:19
  • Did you check data source for the report? How to logon sql in data source? What's RS service account? Does it have permission to access sql2k?


    I checked everything. I use sa login in data source, RS service account is Buildin\administrator.

    Does it have permission to access sqk2k?  sa or administrator?

    2010年9月13日 14:28
  • Buildin\administrator is local account on RS machine, it doesn't have permission to access remote sql.
    2010年9月13日 14:30
  •  

    你的问题是报表连不到数据源.

     

    而数据源的设置有两种,一种是用的共享数据源连接,一种是rdl内置数据源连接,关键是你用的是哪一种.

     

    现在共享数据源试过了不行.

    那你试着改一下内置数据源连接,

     

    步骤如下:

    打开http://localhost/reports

    导航到你的报表

    打开该报表的属性(Properties)Tab->再打开数据源(Data Source)子Tab

    查看你的连接字串是否正确

    注意:连接字串中不能有登录账号相关的信息

    登录账号要在下方设置

    根据你的情况设置后点"应用(Apply)"就行了.

     

    2010年9月14日 1:40
  • 1) Open SSRS log, it will tell you more details about the error.

    2) The error most likely is the Authentication issue, check the data source connecting string and connect account in the Reporting Services Manager if you are using the Shared data source.

    3) Probably not the case, but just try it: in the Reporting Service Configuration Manager, you have to check the Report Server Service Account, in your case - I am assuming your two machines (sql2k and sql2005) are in the same domain, try to use the domain user account instead of the built-in account, and ensure the domain user account has the enough permission on the w2k sql instance.

    2010年9月14日 2:03
    版主
  • Buildin\administrator is local account on RS machine, it doesn't have permission to access remote sql.

    So how does Buildin\administrator access remote sql?
    2010年9月14日 2:50
  • Buildin\administrator is local account on RS machine, it doesn't have permission to access remote sql.

    So how does Buildin\administrator access remote sql?
    No way.
    2010年9月14日 3:01
  • where can I find the SSRS log?
    2010年9月14日 3:44
  • try this!
    2010年9月14日 3:58
  • try this!

    试过了,不行呀 :(
    2010年9月14日 5:23
  • I tried to link the data source on sql2005, now it works. I don't know why.

    2010年9月14日 6:53
  • where can I find the SSRS log?


    Take a look at this article:  http://www.bridata.ca/blog/?p=172

     

    2010年9月14日 13:18
    版主
  • I tried to link the data source on sql2005, now it works. I don't know why.

    Is it another remote server? Same settings in data source?
    2010年9月14日 13:27
  • yes, it's another remote server, same setting, very strange.
    2010年9月17日 14:13