Error Occurred In Transport
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site
A Transport Level Error Has Occurred
About Us Learn more about Stack Overflow the company Business Learn more about a transport level error has occurred sql server hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss a transport level error has occurred when receiving results Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up OLAP cube / https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b2861abd-0060-4efb-970b-bf455731f5a9/an-error-was-encountered-in-the-transport-layer?forum=sqlanalysisservices Analysis Services = error on transport layer up vote 0 down vote favorite 1 Problem: When connecting to an OLAP cube via Excel by using Windows authentication we receive this error: "An error was encountered in the transport layer" When connecting to Analysis Services via SQL Server Management Studio 2008 R2 by using Windows authentication we receive this error: "Cannot connect to Lake. A connection http://stackoverflow.com/questions/29644848/olap-cube-analysis-services-error-on-transport-layer cannot be made. Ensure that the server is running." The thing is that a connection with a proxy user via an automated SQL Server job in which the cube is deployed and processed worked. Using the credentials of that user when trying to connect to Analysis Services via SQL Server Management Studio however, does not work. The server, on which the cube is deployed, is named Lake and is definitely running. Also, the connection to the database engine on Lake is possible. What could cause this issue? Why is it possible that a proxy user can update the cube in a SQL Server Job but the very same credentials cannot be used to manually log in to the Analysis Services server? sql-server authentication connection ssas share|improve this question asked Apr 15 '15 at 8:07 user3716424 3329 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote accepted It is possible that the SQL Job uses credentials of a Service Account - most likely SQL Server Agent (NT Service\SQLServerAgent) or Analysis Services (NT Service\MSSQLServerOlapService) to connect to the SSAS database and this account has access to the cube but the
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company http://dba.stackexchange.com/questions/64409/a-transport-level-error-has-occurred-when-sending-the-request-to-the-server Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=184154 their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up error occurred and rise to the top A transport-level error has occurred when sending the request to the server up vote 4 down vote favorite In our Vb.net application(userd within a local network connection inside a office), which is used from long time now some of the users get the errors only sometimes a day A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly error occurred in closed by the remote host. I have already checked following All databases are set to autoclose OFF Didn't find much network problems and network speed is good. When I checked in SSMS the under server properties remote query time-out set to 600 seconds I checked sql server log and no errors found relating to it or same error message So what may be the reason for this error? And how to troubleshoot it? sql-server sql sql-server-2008-r2 tcpip share|improve this question edited May 3 '14 at 19:37 Aaron Bertrand♦ 114k14196335 asked May 3 '14 at 7:00 IT researcher 1,19772950 add a comment| 4 Answers 4 active oldest votes up vote 4 down vote If an application opens a connection (successfully) to SQL Server, and leaves it open in anticipation of sending a (or possible 'another') query, and in the meantime, SQL kills that connection for some reason (eg, service restarts, or a kill command is sent), then when the connection (which thinks it's open) tries to send a command, you'll get this error. So catch the error in your application, and reconnect. Then try the command again. share|improve this answer answered May 3 '14 at 7:06 Rob Farley 11.3k11735 add a comment| up vote 3 down vote I mostly see this error if for some reason the network connectivity was lost, even for a fe
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2008 Forums Analysis Server and Reporting Services (2008) error in the transport layer Reply to Topic Printer Friendly Author Topic HenryFulmer Posting Yak Master USA 110 Posts Posted-03/28/2013: 18:30:02 I have created a cube using Analysis services 2008. The cube is deployed on a remote server to which I am connected via VPN.I now would like to use the cube as a datasource for a Pivot table in Excel 2010 which is running on my PC. My PC is logged on to a different domain than the analysis services server.I can connect to the remote AS and I can also select the cube but when I finish up the connection I get the following error:"An error was encountered in the transport layer" prett Posting Yak Master USA 212 Posts Posted-03/31/2013: 23:06:32 Check this post: http://www.codeproject.com/Questions/448262/Cannot-connect-Analysis-Service-2008-from-Excel-20Hope it will help you to solve the issue!! Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database Design and Application Architecture SQL Server 2012 Forums Transact-SQL (2012) SQL Server Administration (2012) SSIS and Import/Export (2012) Analysis Server and Reporting Services (2012) Replication (2012) Availability Groups and DR (2012) Other SQL Server 2012 Topics SQL Server 2008 Forums Transact-SQL (2008) SQL Server Administration (2008) SSIS and Import/Export (2008) High Availability (2008) Replication (2008) Analysis Server and Reporting Services (2008) Other SQL Server 2008 Topics SQL Server 2005 Forums Transact-SQL (2005) SQL Server Administration (2005) .NET Inside SQL Server (2005) SSIS and Import/Export (2005) Service Broker (2005) Replication (2005) High Availability (2005) Analysis Server and Reporting Services (2005) Express Edition and Compact Edition (2005) Other SQL Server Topics (2005) SQL Server 2000 Forums SQL Server Development (2000) SQL Server Administration (2000) Import/Export (DTS) and