A transport-level error has occurred when receiving results from the server. Error 10054Can't restore...
Tikz: Perpendicular FROM a line
Is the UK legally prevented from having another referendum on Brexit?
In a post apocalypse world, with no power and few survivors, would Satnav still work?
Quick Way to Extrude Line to Make Ledges?
Disk space full during insert, what happens?
Boss asked me to sign a resignation paper without a date on it along with my new contract
Is it possible to have the same planeswalker from different editions in a Commander deck?
Third wheel character
Expression for "unconsciously using words (or accents) used by a person you often talk with or listen to"?
Can I use a single resistor for multiple LED with different +ve sources?
Coworker asking me to not bring cakes due to self control issue. What should I do?
What is an efficient way to digitize a family photo collection?
How to write Muḥammad ibn Mūsā al-Khwārizmī?
What is an explicit bijection in combinatorics?
Isn't a semicolon (';') needed after a function declaration in C++?
What if I miss a connection and don't have money to book next flight?
Dealing with an internal ScriptKiddie
Is it possible to narrate a novel in a faux-historical style without alienating the reader?
If we can’t finish all tasks, does this mean we are doing Scrum wrong?
How do I add a strong "onion flavor" to the biryani (in restaurant style)?
Select all columns except geometry using virtual layers
Is it possible to methodically find the total of ways to read a given phrase making a stack?
Is Screenshot Time-tracking Common?
Is the Maximum Use License for Everybody (MULE) a FOSS license?
A transport-level error has occurred when receiving results from the server. Error 10054
Can't restore database: A transport-level error has occurred when receiving results from the serverA Difficult Case of “A transport-level error has occurred when receiving results from the server” SQL ServerA transport-level error has occurred when sending the request to the serverConnection problem different errors .net applicationDelete From sys.views With WildcardsError 10054 encountered exporting localhost SQL Server to .bacpacAttempt at SSIS Execution Throws Invalid object name 'SSISDB.catalog.customized_logging_levels'SSMS 17.8.1 Error: Accessing SQL Server logs0x80131904 - An existing connection was forcibly closed by the remote hostSSMS can't connect to Azure database
I have been using SQL Server & Azure for almost two years with Zero problems. Now for some reason I am getting the following error when I try to connect to my Azure database from SSMS. I have tried everything I could find: extend connection time-outs, checked open firewall port 1433, used my phone Hotspot to make internet connection, turned off public and private firewalls (temporarily for testing)... with no difference. I have Azure BASIC service and the database only holds dummy information for testing.
Everything in the Azure Portal looks fine. I can't find any errors or outages. The only thing I thought was weird was that my Server is in "West Europe" (I'm in Florida). And my Storage Account is in "East US". Maybe that's not unusual though?
Microsoft SQL Server Management Studio
------------------------------
Error connecting to 'gobo.database.windows.net'.
------------------------------
ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)
------------------------------
An existing connection was forcibly closed by the remote host
Tried testing with Azure Data Studio, where I could connect and I could run a query against a datatable successfully, however when I tried to expand the server list to show the database I got the following:
Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) ---> System.ComponentModel.Win32Exception: The specified network name is no longer available
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.GetExecuteReader(SqlCommand command)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Common.ServerConnection.GetExecuteReader(SqlCommand command)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String query, SqlCommand& command)
at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
at Microsoft.SqlServer.Management.Smo.DatabaseLevel.GetData(EnumResult res)
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request req)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean allProperties)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String propname, Boolean useDefaultValue)
at Microsoft.SqlServer.Management.Smo.PropertyCollection.RetrieveProperty(Int32 index, Boolean useDefaultOnMissingValue)
at Microsoft.SqlServer.Management.Smo.Database.get_IsSqlDw()
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.SmoModel.DatabaseTreeNode.EnsureContextInitialized() in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerSmoModelDatabaseTreeNode.cs:line 32
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.SmoModel.SmoTreeNode.GetContext() in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerSmoModelSmoTreeNode.cs:line 98
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.Nodes.TreeNode.GetContextAs[T]() in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerNodesTreeNode.cs:line 310
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.SmoModel.DatabaseTreeNode.PopulateChildren(Boolean refresh, String name, CancellationToken cancellationToken) in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerSmoModelDatabaseTreeNode.cs:line 46
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.Nodes.TreeNode.Expand(String name, CancellationToken cancellationToken) in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerNodesTreeNode.cs:line 248
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.ObjectExplorerService.<>c__DisplayClass36_0.<QueueExpandNodeRequest>b__0(IBindingContext bindingContext, CancellationToken cancelToken) in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerObjectExplorerService.cs:line 440
at Microsoft.SqlTools.ServiceLayer.LanguageServices.BindingQueue`1.<>c__DisplayClass34_2.<ProcessQueue>b__1() in D:a1ssrcMicrosoft.SqlTools.ServiceLayerLanguageServicesBindingQueue.cs:line 352
I am at a total loss. Have spent 10+ hours on this with no progress. Any help would be appreciated. I am self taught and understand enough to use, but not experienced enough to do in depth debugging...
I installed sqlcmd and was able to connect to the server and query against the database, but I'm not sure what that tells me about the problem.
sql-server errors azure
asked Feb 17 at 4:06
mjordanmjordan
12
New contributor
mjordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have been using SQL Server & Azure for almost two years with Zero problems. Now for some reason I am getting the following error when I try to connect to my Azure database from SSMS. I have tried everything I could find: extend connection time-outs, checked open firewall port 1433, used my phone Hotspot to make internet connection, turned off public and private firewalls (temporarily for testing)... with no difference. I have Azure BASIC service and the database only holds dummy information for testing.
Everything in the Azure Portal looks fine. I can't find any errors or outages. The only thing I thought was weird was that my Server is in "West Europe" (I'm in Florida). And my Storage Account is in "East US". Maybe that's not unusual though?
Microsoft SQL Server Management Studio
------------------------------
Error connecting to 'gobo.database.windows.net'.
------------------------------
ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)
------------------------------
An existing connection was forcibly closed by the remote host
Tried testing with Azure Data Studio, where I could connect and I could run a query against a datatable successfully, however when I tried to expand the server list to show the database I got the following:
Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) ---> System.ComponentModel.Win32Exception: The specified network name is no longer available
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.GetExecuteReader(SqlCommand command)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Common.ServerConnection.GetExecuteReader(SqlCommand command)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String query, SqlCommand& command)
at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
at Microsoft.SqlServer.Management.Smo.DatabaseLevel.GetData(EnumResult res)
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request req)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean allProperties)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String propname, Boolean useDefaultValue)
at Microsoft.SqlServer.Management.Smo.PropertyCollection.RetrieveProperty(Int32 index, Boolean useDefaultOnMissingValue)
at Microsoft.SqlServer.Management.Smo.Database.get_IsSqlDw()
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.SmoModel.DatabaseTreeNode.EnsureContextInitialized() in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerSmoModelDatabaseTreeNode.cs:line 32
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.SmoModel.SmoTreeNode.GetContext() in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerSmoModelSmoTreeNode.cs:line 98
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.Nodes.TreeNode.GetContextAs[T]() in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerNodesTreeNode.cs:line 310
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.SmoModel.DatabaseTreeNode.PopulateChildren(Boolean refresh, String name, CancellationToken cancellationToken) in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerSmoModelDatabaseTreeNode.cs:line 46
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.Nodes.TreeNode.Expand(String name, CancellationToken cancellationToken) in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerNodesTreeNode.cs:line 248
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.ObjectExplorerService.<>c__DisplayClass36_0.<QueueExpandNodeRequest>b__0(IBindingContext bindingContext, CancellationToken cancelToken) in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerObjectExplorerService.cs:line 440
at Microsoft.SqlTools.ServiceLayer.LanguageServices.BindingQueue`1.<>c__DisplayClass34_2.<ProcessQueue>b__1() in D:a1ssrcMicrosoft.SqlTools.ServiceLayerLanguageServicesBindingQueue.cs:line 352
I am at a total loss. Have spent 10+ hours on this with no progress. Any help would be appreciated. I am self taught and understand enough to use, but not experienced enough to do in depth debugging...
I installed sqlcmd and was able to connect to the server and query against the database, but I'm not sure what that tells me about the problem.
sql-server errors azure
asked Feb 17 at 4:06
mjordanmjordan
12
New contributor
mjordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
It looks like the network connection is getting dropped. Try running a network trace, such as with Wireshark, to monitor the TCP traffic.
– Dan Guzman
Feb 17 at 12:55
The error message indicates that the connection was forcibly closed by the host--this often indicates a firewall blocking the request, but in your case, sqlcmd works, disproving that. The stack trace from ADS indicates the problem is in loading Object Explorer--which is probably what is happening in SSMS, too. What version of SSMS & other SQL Tools do you have installed on your machine? My hunch is a shared component/dll may be to blame.
– AMtwo
Feb 17 at 13:04
Thank you for your replies! I'm not familiar with Wireshark, but I will look into it today. I am using SSMS v17.9.1 and downloaded/installed sqlcmd yesterday. Also (if that helps troubleshoot), I am working on a VS Community 15.8.1 C# project and I have similar problem connecting to my Azure database for there.
– mjordan
Feb 17 at 13:35
I ran Wireshark. I don't fully understand the network traffic, but there was nothing glaring that screamed error or such.
– mjordan
Feb 18 at 0:05
add a comment |
I have been using SQL Server & Azure for almost two years with Zero problems. Now for some reason I am getting the following error when I try to connect to my Azure database from SSMS. I have tried everything I could find: extend connection time-outs, checked open firewall port 1433, used my phone Hotspot to make internet connection, turned off public and private firewalls (temporarily for testing)... with no difference. I have Azure BASIC service and the database only holds dummy information for testing.
Everything in the Azure Portal looks fine. I can't find any errors or outages. The only thing I thought was weird was that my Server is in "West Europe" (I'm in Florida). And my Storage Account is in "East US". Maybe that's not unusual though?
Microsoft SQL Server Management Studio
------------------------------
Error connecting to 'gobo.database.windows.net'.
------------------------------
ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)
------------------------------
An existing connection was forcibly closed by the remote host
Tried testing with Azure Data Studio, where I could connect and I could run a query against a datatable successfully, however when I tried to expand the server list to show the database I got the following:
Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) ---> System.ComponentModel.Win32Exception: The specified network name is no longer available
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.GetExecuteReader(SqlCommand command)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Common.ServerConnection.GetExecuteReader(SqlCommand command)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String query, SqlCommand& command)
at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
at Microsoft.SqlServer.Management.Smo.DatabaseLevel.GetData(EnumResult res)
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request req)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean allProperties)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String propname, Boolean useDefaultValue)
at Microsoft.SqlServer.Management.Smo.PropertyCollection.RetrieveProperty(Int32 index, Boolean useDefaultOnMissingValue)
at Microsoft.SqlServer.Management.Smo.Database.get_IsSqlDw()
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.SmoModel.DatabaseTreeNode.EnsureContextInitialized() in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerSmoModelDatabaseTreeNode.cs:line 32
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.SmoModel.SmoTreeNode.GetContext() in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerSmoModelSmoTreeNode.cs:line 98
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.Nodes.TreeNode.GetContextAs[T]() in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerNodesTreeNode.cs:line 310
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.SmoModel.DatabaseTreeNode.PopulateChildren(Boolean refresh, String name, CancellationToken cancellationToken) in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerSmoModelDatabaseTreeNode.cs:line 46
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.Nodes.TreeNode.Expand(String name, CancellationToken cancellationToken) in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerNodesTreeNode.cs:line 248
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.ObjectExplorerService.<>c__DisplayClass36_0.<QueueExpandNodeRequest>b__0(IBindingContext bindingContext, CancellationToken cancelToken) in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerObjectExplorerService.cs:line 440
at Microsoft.SqlTools.ServiceLayer.LanguageServices.BindingQueue`1.<>c__DisplayClass34_2.<ProcessQueue>b__1() in D:a1ssrcMicrosoft.SqlTools.ServiceLayerLanguageServicesBindingQueue.cs:line 352
I am at a total loss. Have spent 10+ hours on this with no progress. Any help would be appreciated. I am self taught and understand enough to use, but not experienced enough to do in depth debugging...
I installed sqlcmd and was able to connect to the server and query against the database, but I'm not sure what that tells me about the problem.
sql-server errors azure
asked Feb 17 at 4:06
mjordanmjordan
12
New contributor
mjordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have been using SQL Server & Azure for almost two years with Zero problems. Now for some reason I am getting the following error when I try to connect to my Azure database from SSMS. I have tried everything I could find: extend connection time-outs, checked open firewall port 1433, used my phone Hotspot to make internet connection, turned off public and private firewalls (temporarily for testing)... with no difference. I have Azure BASIC service and the database only holds dummy information for testing.
Everything in the Azure Portal looks fine. I can't find any errors or outages. The only thing I thought was weird was that my Server is in "West Europe" (I'm in Florida). And my Storage Account is in "East US". Maybe that's not unusual though?
Microsoft SQL Server Management Studio
------------------------------
Error connecting to 'gobo.database.windows.net'.
------------------------------
ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)
------------------------------
An existing connection was forcibly closed by the remote host
Tried testing with Azure Data Studio, where I could connect and I could run a query against a datatable successfully, however when I tried to expand the server list to show the database I got the following:
Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) ---> System.ComponentModel.Win32Exception: The specified network name is no longer available
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
at Microsoft.SqlServer.Management.Common.ServerConnection.GetExecuteReader(SqlCommand command)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Common.ServerConnection.GetExecuteReader(SqlCommand command)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String query, SqlCommand& command)
at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
at Microsoft.SqlServer.Management.Smo.DatabaseLevel.GetData(EnumResult res)
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request req)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[] fields, OrderBy[] orderby)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean allProperties)
at Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String propname, Boolean useDefaultValue)
at Microsoft.SqlServer.Management.Smo.PropertyCollection.RetrieveProperty(Int32 index, Boolean useDefaultOnMissingValue)
at Microsoft.SqlServer.Management.Smo.Database.get_IsSqlDw()
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.SmoModel.DatabaseTreeNode.EnsureContextInitialized() in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerSmoModelDatabaseTreeNode.cs:line 32
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.SmoModel.SmoTreeNode.GetContext() in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerSmoModelSmoTreeNode.cs:line 98
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.Nodes.TreeNode.GetContextAs[T]() in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerNodesTreeNode.cs:line 310
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.SmoModel.DatabaseTreeNode.PopulateChildren(Boolean refresh, String name, CancellationToken cancellationToken) in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerSmoModelDatabaseTreeNode.cs:line 46
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.Nodes.TreeNode.Expand(String name, CancellationToken cancellationToken) in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerNodesTreeNode.cs:line 248
at Microsoft.SqlTools.ServiceLayer.ObjectExplorer.ObjectExplorerService.<>c__DisplayClass36_0.<QueueExpandNodeRequest>b__0(IBindingContext bindingContext, CancellationToken cancelToken) in D:a1ssrcMicrosoft.SqlTools.ServiceLayerObjectExplorerObjectExplorerService.cs:line 440
at Microsoft.SqlTools.ServiceLayer.LanguageServices.BindingQueue`1.<>c__DisplayClass34_2.<ProcessQueue>b__1() in D:a1ssrcMicrosoft.SqlTools.ServiceLayerLanguageServicesBindingQueue.cs:line 352
I am at a total loss. Have spent 10+ hours on this with no progress. Any help would be appreciated. I am self taught and understand enough to use, but not experienced enough to do in depth debugging...
I installed sqlcmd and was able to connect to the server and query against the database, but I'm not sure what that tells me about the problem.
sql-server errors azure
sql-server errors azure
asked Feb 17 at 4:06
mjordanmjordan
12
New contributor
mjordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Feb 17 at 4:06
mjordanmjordan
12
New contributor
mjordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Feb 17 at 6:18
mjordan
asked Feb 17 at 4:06
mjordanmjordan
12
New contributor
mjordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Feb 17 at 4:06
mjordanmjordan
12
asked Feb 17 at 4:06
mjordanmjordan
12
12
New contributor
mjordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
mjordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
mjordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
It looks like the network connection is getting dropped. Try running a network trace, such as with Wireshark, to monitor the TCP traffic.
– Dan Guzman
Feb 17 at 12:55
The error message indicates that the connection was forcibly closed by the host--this often indicates a firewall blocking the request, but in your case, sqlcmd works, disproving that. The stack trace from ADS indicates the problem is in loading Object Explorer--which is probably what is happening in SSMS, too. What version of SSMS & other SQL Tools do you have installed on your machine? My hunch is a shared component/dll may be to blame.
– AMtwo
Feb 17 at 13:04
Thank you for your replies! I'm not familiar with Wireshark, but I will look into it today. I am using SSMS v17.9.1 and downloaded/installed sqlcmd yesterday. Also (if that helps troubleshoot), I am working on a VS Community 15.8.1 C# project and I have similar problem connecting to my Azure database for there.
– mjordan
Feb 17 at 13:35
I ran Wireshark. I don't fully understand the network traffic, but there was nothing glaring that screamed error or such.
– mjordan
Feb 18 at 0:05
add a comment |
It looks like the network connection is getting dropped. Try running a network trace, such as with Wireshark, to monitor the TCP traffic.
– Dan Guzman
Feb 17 at 12:55
The error message indicates that the connection was forcibly closed by the host--this often indicates a firewall blocking the request, but in your case, sqlcmd works, disproving that. The stack trace from ADS indicates the problem is in loading Object Explorer--which is probably what is happening in SSMS, too. What version of SSMS & other SQL Tools do you have installed on your machine? My hunch is a shared component/dll may be to blame.
– AMtwo
Feb 17 at 13:04
Thank you for your replies! I'm not familiar with Wireshark, but I will look into it today. I am using SSMS v17.9.1 and downloaded/installed sqlcmd yesterday. Also (if that helps troubleshoot), I am working on a VS Community 15.8.1 C# project and I have similar problem connecting to my Azure database for there.
– mjordan
Feb 17 at 13:35
I ran Wireshark. I don't fully understand the network traffic, but there was nothing glaring that screamed error or such.
– mjordan
Feb 18 at 0:05
It looks like the network connection is getting dropped. Try running a network trace, such as with Wireshark, to monitor the TCP traffic.
– Dan Guzman
Feb 17 at 12:55
It looks like the network connection is getting dropped. Try running a network trace, such as with Wireshark, to monitor the TCP traffic.
– Dan Guzman
Feb 17 at 12:55
The error message indicates that the connection was forcibly closed by the host--this often indicates a firewall blocking the request, but in your case, sqlcmd works, disproving that. The stack trace from ADS indicates the problem is in loading Object Explorer--which is probably what is happening in SSMS, too. What version of SSMS & other SQL Tools do you have installed on your machine? My hunch is a shared component/dll may be to blame.
– AMtwo
Feb 17 at 13:04
The error message indicates that the connection was forcibly closed by the host--this often indicates a firewall blocking the request, but in your case, sqlcmd works, disproving that. The stack trace from ADS indicates the problem is in loading Object Explorer--which is probably what is happening in SSMS, too. What version of SSMS & other SQL Tools do you have installed on your machine? My hunch is a shared component/dll may be to blame.
– AMtwo
Feb 17 at 13:04
Thank you for your replies! I'm not familiar with Wireshark, but I will look into it today. I am using SSMS v17.9.1 and downloaded/installed sqlcmd yesterday. Also (if that helps troubleshoot), I am working on a VS Community 15.8.1 C# project and I have similar problem connecting to my Azure database for there.
– mjordan
Feb 17 at 13:35
Thank you for your replies! I'm not familiar with Wireshark, but I will look into it today. I am using SSMS v17.9.1 and downloaded/installed sqlcmd yesterday. Also (if that helps troubleshoot), I am working on a VS Community 15.8.1 C# project and I have similar problem connecting to my Azure database for there.
– mjordan
Feb 17 at 13:35
I ran Wireshark. I don't fully understand the network traffic, but there was nothing glaring that screamed error or such.
– mjordan
Feb 18 at 0:05
I ran Wireshark. I don't fully understand the network traffic, but there was nothing glaring that screamed error or such.
– mjordan
Feb 18 at 0:05
add a comment |
1 Answer
1
active
oldest
votes
In case someone runs into a similar problem... After 1.5 hours on the phone with MSFT, and reinstalling both SSMS and VS with no resolution. I reformatted my machine, reinstalled, and now everything works the way it should. I don't know what got into my system but now it's gone. Not a great solution, but that's what worked.
answered 8 mins ago
mjordanmjordan
12
New contributor
mjordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
mjordan is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f229963%2fa-transport-level-error-has-occurred-when-receiving-results-from-the-server-err%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
In case someone runs into a similar problem... After 1.5 hours on the phone with MSFT, and reinstalling both SSMS and VS with no resolution. I reformatted my machine, reinstalled, and now everything works the way it should. I don't know what got into my system but now it's gone. Not a great solution, but that's what worked.
answered 8 mins ago
mjordanmjordan
12
New contributor
mjordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
In case someone runs into a similar problem... After 1.5 hours on the phone with MSFT, and reinstalling both SSMS and VS with no resolution. I reformatted my machine, reinstalled, and now everything works the way it should. I don't know what got into my system but now it's gone. Not a great solution, but that's what worked.
answered 8 mins ago
mjordanmjordan
12
New contributor
mjordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
In case someone runs into a similar problem... After 1.5 hours on the phone with MSFT, and reinstalling both SSMS and VS with no resolution. I reformatted my machine, reinstalled, and now everything works the way it should. I don't know what got into my system but now it's gone. Not a great solution, but that's what worked.
answered 8 mins ago
mjordanmjordan
12
New contributor
mjordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
In case someone runs into a similar problem... After 1.5 hours on the phone with MSFT, and reinstalling both SSMS and VS with no resolution. I reformatted my machine, reinstalled, and now everything works the way it should. I don't know what got into my system but now it's gone. Not a great solution, but that's what worked.
answered 8 mins ago
mjordanmjordan
12
New contributor
mjordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 8 mins ago
mjordanmjordan
12
New contributor
mjordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 8 mins ago
mjordanmjordan
12
answered 8 mins ago
mjordanmjordan
12
12
New contributor
mjordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
mjordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
mjordan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
mjordan is a new contributor. Be nice, and check out our Code of Conduct.
mjordan is a new contributor. Be nice, and check out our Code of Conduct.
mjordan is a new contributor. Be nice, and check out our Code of Conduct.
mjordan is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f229963%2fa-transport-level-error-has-occurred-when-receiving-results-from-the-server-err%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
It looks like the network connection is getting dropped. Try running a network trace, such as with Wireshark, to monitor the TCP traffic.
– Dan Guzman
Feb 17 at 12:55
The error message indicates that the connection was forcibly closed by the host--this often indicates a firewall blocking the request, but in your case, sqlcmd works, disproving that. The stack trace from ADS indicates the problem is in loading Object Explorer--which is probably what is happening in SSMS, too. What version of SSMS & other SQL Tools do you have installed on your machine? My hunch is a shared component/dll may be to blame.
– AMtwo
Feb 17 at 13:04
Thank you for your replies! I'm not familiar with Wireshark, but I will look into it today. I am using SSMS v17.9.1 and downloaded/installed sqlcmd yesterday. Also (if that helps troubleshoot), I am working on a VS Community 15.8.1 C# project and I have similar problem connecting to my Azure database for there.
– mjordan
Feb 17 at 13:35
I ran Wireshark. I don't fully understand the network traffic, but there was nothing glaring that screamed error or such.
– mjordan
Feb 18 at 0:05