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,467

Packed/Batched Transact-SQL (TSQL) RPC Invocation

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

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,405

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,276

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,158

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.3K

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,064

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.
11.1K

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,534

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,526

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.
512

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,602

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.8K

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,519

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.
392

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...
711

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.9K

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,258

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.8K

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,535

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...
10K

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,549

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...
377

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,214

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...
996

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,036

"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.7K

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 May 08 2024 07:47 AM
@EdElfrink2026 I appreciate the additional context and would ask that you add your scenario to (and upvote) this feedback item: SSMS - Registered Servers and CMS do not persist auth settings for encryption · Community (azure.com). I do understand the challenge that you have, and while we do not have...
1 Likes
EdElfrink2026
in Upcoming changes for SQL Server Management Studio (SSMS) - Part 1 on May 08 2024 07:16 AM
@erinstellato I echo the comments of @sgtmango333. This is more than inconvenient for users of CMS (Central Management Server) that have a lot of SQL servers without encryption. At first, I thought it wouldn't be a problem if I had to go through them all once, change the setting to "optional" and sa...
0 Likes
Karl_Wester-Ebbinghaus
in Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager on Apr 30 2024 11:11 AM
You're welcome. Will do @TarynPratt.
0 Likes
TarynPratt
in Announcing GA of enhanced patching for SQL Server on Azure VM with Azure Update Manager on Apr 30 2024 07:03 AM
@Karl_Wester-Ebbinghaus I appreciate the feedback on this and thanks for reporting what you are seeing. My suggestion would be to open a support request for the issue as they should be able to help and then raise it with the proper team.
1 Likes
amvin87
in Deploy Always On Availability Groups (AG) on SQL Server RHEL based Azure VMs - The Ansible Way! on Apr 30 2024 05:19 AM
Hi @vivek19852225, you need to create the database separately on the primary server add it to the AG and then to perform failover you should do it outside of SSMS as documented here: Manage availability group failover - SQL Server on Linux - SQL Server | Microsoft Learn.
0 Likes