Solving SQL Connectivity issues: A new guided walk through just got published

Published Jan 15 2019 05:23 PM 207 Views
Microsoft
First published on MSDN on Jan 29, 2017
We recently published a new document that provides a one stop shop for solving majority of connectivity issues that you may run into when working with SQL Server. This can be accessed here:

Solving Connectivity errors to SQL Server

In addition to providing a quick checklist of items that you can go through, the doc provides step by step troubleshooting procedures for the following error messages:

  • A network-related or instance-specific error occurred while establishing a connection to SQL Server

  • No connection could be made because the target machine actively refused it

  • SQL Server does not exist or access denied

  • PivotTable Operation Failed: We cannot locate a server to load the workbook Data Model

  • Cannot generate SSPI context

  • Login failed for user

  • Timeout Expired

  • The timeout period elapsed prior to obtaining a connection from the pool


We hope that you use this to guide your troubleshooting of connectivity issues and would love to get your feedback on these kind of documentation experiences.

We also have the following troubleshooters available for Always On and SQL Azure DB connectivity issues:

Troubleshooting Always On Issues

Troubleshooting connectivity issues with Microsoft Azure SQL Database
%3CLINGO-SUB%20id%3D%22lingo-sub-318904%22%20slang%3D%22en-US%22%3ESolving%20SQL%20Connectivity%20issues%3A%20A%20new%20guided%20walk%20through%20just%20got%20published%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-318904%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3EFirst%20published%20on%20MSDN%20on%20Jan%2029%2C%202017%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20We%20recently%20published%20a%20new%20document%20that%20provides%20a%20one%20stop%20shop%20for%20solving%20majority%20of%20connectivity%20issues%20that%20you%20may%20run%20into%20when%20working%20with%20SQL%20Server.%20This%20can%20be%20accessed%20here%3A%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F4009936%2Fsolving-connectivity-errors-to-sql-server%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Solving%20Connectivity%20errors%20to%20SQL%20Server%20%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20In%20addition%20to%20providing%20a%20quick%20checklist%20of%20items%20that%20you%20can%20go%20through%2C%20the%20doc%20provides%20step%20by%20step%20troubleshooting%20procedures%20for%20the%20following%20error%20messages%3A%20%3CBR%20%2F%3E%3CUL%3E%3CBR%20%2F%3E%3CLI%3EA%20network-related%20or%20instance-specific%20error%20occurred%20while%20establishing%20a%20connection%20to%20SQL%20Server%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ENo%20connection%20could%20be%20made%20because%20the%20target%20machine%20actively%20refused%20it%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ESQL%20Server%20does%20not%20exist%20or%20access%20denied%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3EPivotTable%20Operation%20Failed%3A%20We%20cannot%20locate%20a%20server%20to%20load%20the%20workbook%20Data%20Model%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ECannot%20generate%20SSPI%20context%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ELogin%20failed%20for%20user%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3ETimeout%20Expired%3C%2FLI%3E%3CBR%20%2F%3E%3CLI%3EThe%20timeout%20period%20elapsed%20prior%20to%20obtaining%20a%20connection%20from%20the%20pool%3C%2FLI%3E%3CBR%20%2F%3E%3C%2FUL%3E%3CBR%20%2F%3E%20We%20hope%20that%20you%20use%20this%20to%20guide%20your%20troubleshooting%20of%20connectivity%20issues%20and%20would%20love%20to%20get%20your%20feedback%20on%20these%20kind%20of%20documentation%20experiences.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20We%20also%20have%20the%20following%20troubleshooters%20available%20for%20Always%20On%20and%20SQL%20Azure%20DB%20connectivity%20issues%3A%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F10179%2Ftroubleshooting-alwayson-issues%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Troubleshooting%20Always%20On%20Issues%20%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-in%2Fhelp%2F10085%2Ftroubleshooting-connectivity-issues-with-microsoft-azure-sql-database%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Troubleshooting%20connectivity%20issues%20with%20Microsoft%20Azure%20SQL%20Database%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-318904%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Jan%2029%2C%202017%20We%20recently%20published%20a%20new%20document%20that%20provides%20a%20one%20stop%20shop%20for%20solving%20majority%20of%20connectivity%20issues%20that%20you%20may%20run%20into%20when%20working%20with%20SQL%20Server.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-318904%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Econnectivity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Jan 15 2019 05:23 PM
Updated by: