Sign in
 
Home20132010Other VersionsLibraryForumsGallery
TechCenter >
> 
> 
Cannot connect to Server (AS) anymore with Excel 2007

Answered Cannot connect to Server (AS) anymore with Excel 2007

  • Tuesday, July 06, 2010 12:34 PM
     
     
    Sign In to Vote
    0

    Since yesterday I can't connect to Analysis Services with Excel 2007. The Error I get is "Fehler auf der Transportebene" which means "Error on the transport layer". No further information, just this small message.

    At first I tried to connect to a different server - same pc I run Excel. It was possible for months, but now I get the same error message. Then I tried it with windows authentification and this is working, but not an option for the other server I want to connect to.

    Connection with SQL Server Management Studio is working without any problem. But I can test only the SQL and not the Analysis Services, because SQL SMS allows only Windows Auth for it...

     

    What is most confusing for me, is the fact that the connection was working for months. I still have Excel files with PivotTables that were working and should still. But now they can't connect. And I even had a connection to the other Server in Excel last week. And I can't remember that something changed.

    I hope you have an idea what the problem could be.

     

All Replies

  • Wednesday, July 07, 2010 6:53 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi,

    Thank you for using  Excel IT Pro Discussions forum.

    From your description, I understand that  you are unable to connect to SQL Server Analysis Services with Excel 2007 and receive an error that error on the transport layer. If there is any misunderstanding, please feel free to let me know.

    This issue is related to the SQL Server. I performed some research and found the following article. You can try to resolve the issue by the suggestions in this article:

    http://technet.microsoft.com/en-us/library/cc917670.aspx

    The following thread from the newsgroup might also provide some ideas:

    http://groups.google.com/group/microsoft.public.sqlserver.olap/browse_frm/thread/fda9edcc5cabaaa6/ae553b59c97dd4b5%20lnk=st&q=&rnum=7#ae553b59c97dd4b5

    At the same time, I suggest posting this thread in the SQL Server forum to see if they have better ideas. For your convenience, I have included the SQL Server forum link below:

    http://social.msdn.microsoft.com/Forums/en/category/sqlserver/

    If anything is unclear or if there is anything I can do for you, please feel free to let me know.

    Best Regards,

    Sally Tang

     
  • Wednesday, July 07, 2010 1:13 PM
     
     Answered
    Sign In to Vote
    0

    Thank you for trying to help.

    I opened a thread in the SQL Server forum because I still could not find a solution:

    http://social.msdn.microsoft.com/Forums/en/sqlanalysisservices/thread/a1067af0-65f3-4c8b-88dd-a86bc9e3d364