Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
12angrymentiger
Advocate II
Advocate II

Can't connect to Lakehouse SQL Endpoint -- Error

I tried renaming my lakehouse and thought it went through correctly but when I couldn't connect via Azure Data Studio with an error I tried to then unsucessfully delete that lakehouse.   I'm not able to delete that lakehouse or connect to it either.

 

I even tried creating 2 more lakehouses and tried to connect to their sql endpoints in Azure Data studio but am getting the following error message:

 

 

TITLE: Connect to Server
------------------------------

Cannot connect to xxxxxxxxxxxxxxxxxxxxxxxxxx.datawarehouse.pbidedicated.windows.net.

------------------------------
ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-10054-database-engine-...

------------------------------

An existing connection was forcibly closed by the remote host

------------------------------
BUTTONS:

OK
------------------------------

1 ACCEPTED SOLUTION
12angrymentiger
Advocate II
Advocate II

I figured it out. You must delete all references to the renamed lakehouse and then you can delete that lakehouse. For me I had to go through all my notebooks and pipelines and remove all the lakehouses first.

 

That worked. You may want to record that as a solution that works.

View solution in original post

9 REPLIES 9
niksvisuals
New Member

I am facing this same issue. I even tried deleting all the items in my workspace and then after 7 hours created a new warehouse, but still I can't connect to it from Azure Data studio.

Receiving following error.

Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
---> System.ComponentModel.Win32Exception (10054): An existing connection was forcibly closed by the remote host.
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
at Microsoft.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
at Microsoft.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
at Microsoft.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(SqlConnectionEncryptOption encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean& marsCapable, Boolean& fedAuthRequired, Boolean tlsFirst, String serverCert)
at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnectionString connectionOptions, Boolean withFailover)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken, DbConnectionPool pool)
at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at Microsoft.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen()
--- End of stack trace from previous location ---
at Microsoft.Data.SqlClient.SqlRetryLogicProvider.ExecuteAsync(Object sender, Func`1 function, CancellationToken cancellationToken)
at Microsoft.Data.SqlClient.SqlRetryLogicProvider.ExecuteAsync(Object sender, Func`1 function, CancellationToken cancellationToken)
at Microsoft.SqlTools.ServiceLayer.Connection.ReliableConnection.ReliableSqlConnection.<>c__DisplayClass30_0.<<OpenAsync>b__0>d.MoveNext() in /_/src/Microsoft.SqlTools.ManagedBatchParser/ReliableConnection/ReliableSqlConnection.cs:line 319
--- End of stack trace from previous location ---
at Microsoft.SqlTools.ServiceLayer.Connection.ConnectionService.TryOpenConnection(ConnectionInfo connectionInfo, ConnectParams connectionParams) in /_/src/Microsoft.SqlTools.ServiceLayer/Connection/ConnectionService.cs:line 705
ClientConnectionId:eb897154-473a-45bd-be17-df82780078ca
Error Number:10054,State:0,Class:20

12angrymentiger
Advocate II
Advocate II

I figured it out. You must delete all references to the renamed lakehouse and then you can delete that lakehouse. For me I had to go through all my notebooks and pipelines and remove all the lakehouses first.

 

That worked. You may want to record that as a solution that works.

Hi @12angrymentiger 
It was great to know that you were able to get to a resolution. We expect you to keep using this forum and also motivate others to do that same.
Thanks

12angrymentiger
Advocate II
Advocate II

@v-nikhilan-msft  I appreciate it. I'll let you know after a few days if the issue has been resolved.

12angrymentiger
Advocate II
Advocate II

Hi @v-nikhilan-msft there is another post you replied to where after a few days it resolved on its own  Solved: SSMS connection was successfully established with ... - Microsoft Fabric Community

Currently I can't connect to any new or old lakehouses in Azure Data Studio. There is an issue going on with the backend I believe. It might be due to me renaming the lakehouse.

Hi @12angrymentiger ,
Thanks for using Fabric Community.
In the above post which you mentioned, the issue got resolved after waiting for sometime. Hence I request you to wait for sometime and try again. If the issue still persists , please let me know. 

There was also a bug related to this. After renaming your Lakehouse or Warehouse items in Microsoft Fabric, you may experience a failure when trying to access the SQL endpoint or Warehouse item using client tools. Please refer to this link: Link1

Currently the bug has been fixed. So please retry after sometime.

Hope this helps. Please let me know if you have any further queries. Glad to help.

Hi @v-nikhilan-msft As of this morning (3 days later), I still can't delete the renamed lakehouse

 

These are the 3 objects renamed (Lakehouse, SQL endpoint, and semantic model.

 

The SQL endpoint has a triangle warning. Below is the warning message. When I try to delete the lakehouse I get the error below: This item can't be deleted. Please try again later.

 

 

 

12angrymentiger_1-1699888893843.png

 

12angrymentiger_2-1699888909370.png

 

 

 

12angrymentiger_0-1699888841134.png

 

Hi @12angrymentiger 
Thanks for the update.

At this time, we are reaching out to the internal team to get some help on this.
We will update you once we hear back from them.
Thanks.

Thank you. Much apreciated!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Fabric Hack Slide Banner

Hack Together: The Microsoft Fabric AI Global Hack

Learn from experts, get hands-on experience, and win awesome prizes.