cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL Server Blog
Options
2,380

Packed/Batched Transact-SQL (TSQL) RPC Invocation

BobDorr on Oct 26 2023 07:50 AM
Discusses TSQL Packed/Batched RPCs.
2,790

How to Automate Disaster Recovery in SQL Server On-Prem | Data Exposed: MVP Edition

MarisaMathews on Dec 08 2020 09:00 AM
Learn how disaster recovery can be simplified using SQL Server dbatools.
1,397

SQL Server "Login Failure" troubleshooter

SQL-Server-Team on Mar 23 2019 11:28 AM
First published on MSDN on Apr 02, 2010 Our colleagues over in the SQL Server Security team have developed an open tool ...
1,254

Selectively using secure connection to SQL Server

SQL-Server-Team on Mar 23 2019 11:21 AM
First published on MSDN on Oct 19, 2009 Secure connection to SQL Server can be enforced by different ways, e.
2,140

Connection from a Windows Service could be blocked by firewall even if firewall is disabled

SQL-Server-Team on Mar 23 2019 11:19 AM
First published on MSDN on Sep 21, 2009 Recently, I worked on a customer issue.
11.1K

Understanding the error “An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full.”

SQL-Server-Team on Mar 23 2019 11:13 AM
First published on MSDN on Mar 09, 2009 This error message, which is associated with the Winsock error WSAENOBUFS and ac...
2,041

TCP listening ports and ENDPOINT ports behavior

SQL-Server-Team on Mar 23 2019 11:05 AM
First published on MSDN on Nov 05, 2008 Endpoint configuration seems to be creating some confusion.
10.9K

Understanding “Data Source=(local)” in SQL Server Connection Strings

SQL-Server-Team on Mar 23 2019 11:02 AM
First published on MSDN on Sep 19, 2008 Lately we have noticed many misunderstandings surrounding the usage of the Data ...
1,518

Configuring SQL Protocols through Windows PowerShell

SQL-Server-Team on Mar 23 2019 11:01 AM
First published on MSDN on Aug 28, 2008 Sometimes we are asked about the possibility of configuring SQL Server protocols...
2,478

Connection failure because of mismatched TDS version

SQL-Server-Team on Mar 23 2019 10:58 AM
First published on MSDN on Jul 15, 2008 Some customers have reported connection failure because of wrong TDS version.
502

Troubleshooting SQL Server Cluster Installations

SQL-Server-Team on Mar 23 2019 05:23 AM
First published on MSDN on Jun 16, 2008 On a Windows Cluster it is possible to install a SQL Server Cluster, which will ...
4,533

Connectivity troubleshooting in SQL Server 2008 with the Connectivity Ring Buffer

SQL-Server-Team on Mar 23 2019 05:21 AM
First published on MSDN on May 20, 2008 SQL Server 2008 contains a new feature designed to help troubleshoot particularl...
10.5K

Understanding the error message: “Login failed for user ''. The user is not associated with a trusted SQL Server connection.”

SQL-Server-Team on Mar 23 2019 05:21 AM
First published on MSDN on May 02, 2008 Understanding the error message: “Login failed for user ''.
7,373

Steps to troubleshoot SQL connectivity issues

SQL-Server-Team on Mar 23 2019 05:20 AM
First published on MSDN on Apr 30, 2008 We have been seeing and trying to resolve SQL connectivity issue all the time.
386

Could not connect to X64 named instance

SQL-Server-Team on Mar 23 2019 05:20 AM
First published on MSDN on Apr 20, 2008 We see a couple of cases where customer could not connect to named instance on X...
16.2K

Understanding “Connection forcibly closed by remote host” Errors Caused by TOE/Chimney

SQL-Server-Team on Mar 23 2019 05:20 AM
First published on MSDN on Apr 08, 2008 Sporadic “Connection forcibly closed by remote host” errors with SQL Server conn...
698

Service Principal Name (SPN)

SQL-Server-Team on Mar 23 2019 05:20 AM
First published on MSDN on Apr 02, 2008 Did you know that beginning with SQL Server 2008, support for service principal ...
36.3K

TCP Provider: No connection could be made because the target machine actively refused it

SQL-Server-Team on Mar 23 2019 05:06 AM
First published on MSDN on Jul 19, 2007 In this post, I am trying to list out potential cause and general solution to th...
3,246

Login failed for user <xx>, Msg 18456, Level 14, State 1

SQL-Server-Team on Mar 23 2019 05:05 AM
First published on MSDN on Jun 30, 2007 This post focus on a typical cause of sql login failure issue described as the t...
16.6K

SSL Cipher Suites used with SQL Server

SQL-Server-Team on Mar 23 2019 05:04 AM
First published on MSDN on Jun 29, 2007 When enabling channel encryption between the application and SQL Server, users m...
2,491

Install a self-signed test certificate that can be loaded by SQL Server automatically

SQL-Server-Team on Mar 23 2019 05:04 AM
First published on MSDN on Jun 27, 2007 In the blog Certificate for SQL Server 2005, I explained the requirements of a c...
9,909

Named Pipes Provider, error: 40 - Could not open a connection to SQL Server (Microsoft SQL Server, Error: XXX)

SQL-Server-Team on Mar 23 2019 05:01 AM
First published on MSDN on May 16, 2007 This error message is the most frequent error message when connecting to SQL Ser...
145K

SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

SQL-Server-Team on Mar 23 2019 05:00 AM
First published on MSDN on May 13, 2007 Users often see this error message when connection to a SQL Server and don't kno...
9,384

Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

SQL-Server-Team on Mar 23 2019 04:53 AM
First published on MSDN on Mar 31, 2007 This error was most frequently hitted by our customers, and in this post, give a...
354

Building a WebMethod FORMAT=NONE Stored Procedure

SQL-Server-Team on Mar 23 2019 04:51 AM
First published on MSDN on Feb 25, 2007 Commonly for Web Services, the exposed interfaces (webmethods) must conform to s...
1,191

TDSSNIClient initialization failed with error 0x50, status code 0x50

SQL-Server-Team on Mar 23 2019 04:50 AM
First published on MSDN on Jan 31, 2007 In this post, I want to talk about a special cause of this specific error messag...
974

Connection Alias

SQL-Server-Team on Mar 23 2019 04:45 AM
First published on MSDN on Jan 07, 2007 SQL Server client stack has a facility to let user define connection aliases.
2,025

"Cannot Generate SSPI Context" error message, Poisoned DNS

SQL-Server-Team on Mar 23 2019 04:44 AM
First published on MSDN on Jan 02, 2007 Incorrect DNS can lead to various network connectivity issues.
31.3K

Understanding Kerberos and NTLM authentication in SQL Server Connections

SQL-Server-Team on Mar 23 2019 04:43 AM
First published on MSDN on Dec 02, 2006 In this post, I focus on how NTLM and Kerberos are applied when connecting to SQ...

Latest Comments

erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 17 2024 11:54 AM
@DavidYorkshire Following up on your statement that WSUS isn't consistently for updates, with the example that new versions of Windows OS have been available through WSUS for years. Correct. You can update from Windows 8 -> 8.1 ->10 -> 11, or Windows Server 2016 -> 2019 -> 2022 and presumably -> 202...
0 Likes
erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 17 2024 07:13 AM
@sgtmango333 We don't overwrite settings with any upgrade (minor or major). You have to import settings from a previous version to update them. We understand there is additional effort related to connection settings with SSMS 20 - that is why we shared information about the release in advance and no...
0 Likes
sgtmango333
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 17 2024 06:48 AM
I understand the intent, but that makes life a difficult for those using a Central Management Server with hundreds of instances. That means that every one on my team must now connnect to every server and update this setting just to maintain functionality after installing version 20. So next question...
0 Likes
SivertSolem
in Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager on Apr 17 2024 04:16 AM
@TarynPratt wrote:At this point, patching SQL Server on Azure VMs through Azure Update Manager or Automated Patching via the SQL IaaS extension is not aware if the SQL Server is a part of an Always On availability group. It is important to keep this in mind when scheduling your updates with an autom...
1 Likes
erinstellato
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on Apr 16 2024 06:15 PM
@sgtmango333 I missed your question, apologies. It is not possible to set the default value for the Encryption property to optional. With SSMS 20 we upgraded to MDS 5.x, which sets Encryption to Mandatory (true) by default. We intentionally decided to stay with the default, to encourage folks toward...
1 Likes