SQL Server Blog

Options

533

SQL-Server-Team on Mar 23 2019 04:41 AM

First published on MSDN on Nov 07, 2006 We've gotten feedback from customers who have asked if it is possible to write a...

4,456

SQL-Server-Team on Mar 23 2019 04:34 AM

First published on MSDN on Aug 10, 2006 SQL Server 2005: “Login failed for user 'NT AUTHORITYANONYMOUS LOGON'”.

1,496

SQL-Server-Team on Mar 23 2019 04:32 AM

First published on MSDN on Jul 26, 2006 In this blog, I am focusing on one specific error message which I think a little...

313

SQL-Server-Team on Mar 23 2019 04:19 AM

First published on MSDN on Apr 24, 2006 To be able to do this, you need more than one network interface cards on the loc...

279

SQL-Server-Team on Mar 23 2019 04:19 AM

First published on MSDN on Apr 21, 2006 In order to better assist troubleshooting connectivity related issues, the more ...

1,362

SQL-Server-Team on Mar 23 2019 04:18 AM

First published on MSDN on Apr 10, 2006 Recently, we in customer scenario, amount of attacks come through making connect...

375

SQL-Server-Team on Mar 23 2019 04:17 AM

First published on MSDN on Apr 08, 2006 In my previous post, I provided some sample C# code that allows you to configure...

1,156

SQL-Server-Team on Mar 23 2019 04:14 AM

First published on MSDN on Feb 27, 2006 We have been seeing several occurrences where users failed to connect to SQL Ser...

5,419

SQL-Server-Team on Mar 23 2019 04:14 AM

First published on MSDN on Feb 21, 2006 In continuing with the theme of understanding error messages I'll discuss the "l...

759

SQL-Server-Team on Mar 23 2019 04:14 AM

First published on MSDN on Jan 10, 2006 With SQL Server 2005, a server-side protocol error will generally prevent the in...

484

SQL-Server-Team on Mar 23 2019 04:14 AM

First published on MSDN on Dec 21, 2005 Part III – Connection Fail when SqlClient connects to Sql Server 2005When you co...

936

SQL-Server-Team on Mar 23 2019 04:13 AM

First published on MSDN on Dec 19, 2005 I recently worked on three customer issues.

301

SQL-Server-Team on Mar 23 2019 04:13 AM

First published on MSDN on Dec 06, 2005 Recently, we encountered an issue reported by a customer on a clustered SQL Serv...

274

SQL-Server-Team on Mar 23 2019 04:13 AM

First published on MSDN on Nov 14, 2005 Networking protocols are disabled by default in SQL Server Express.

651

SQL-Server-Team on Mar 23 2019 04:13 AM

First published on MSDN on Nov 10, 2005 There are a few different encryption options for SQL Server 2005By default using...

539

SQL-Server-Team on Mar 23 2019 04:13 AM

First published on MSDN on Nov 02, 2005 Just as normal connections to SQL server support SQL user credentials, when logg...

555

SQL-Server-Team on Mar 23 2019 04:12 AM

First published on MSDN on Oct 30, 2005 I've seen this problem posted a couple times on the MSDN forums so I'm including...

335

SQL-Server-Team on Mar 23 2019 04:12 AM

First published on MSDN on Oct 29, 2005 Please visit http://blogs.

408

SQL-Server-Team on Mar 23 2019 04:12 AM

First published on MSDN on Oct 26, 2005 Say you want to create an SSL endpoint for SOAP such as the followingCREATE ENDP...

4,802

SQL-Server-Team on Mar 23 2019 04:12 AM

First published on MSDN on Oct 21, 2005 This post provides some tips to troubleshoot Sql Server connection problems base...

8,722

SQL-Server-Team on Mar 23 2019 04:12 AM

First published on MSDN on Oct 19, 2005 The “Cannot generate SSPI context” issue is described by http://support.

1,138

SQL-Server-Team on Mar 23 2019 04:11 AM

First published on MSDN on Oct 18, 2005 One of the common problems people face when using SQL 2005 web services for the ...

1,450

SQL-Server-Team on Mar 23 2019 04:11 AM

First published on MSDN on Oct 14, 2005 Users sometime see the “Cannot Generate SSPI Context” error message.

3,763

SQL-Server-Team on Mar 23 2019 04:11 AM

First published on MSDN on Oct 11, 2005 Kerberos is a widely accepted network authentication protocol that is used to pr...

196

SQL-Server-Team on Mar 23 2019 04:11 AM

First published on MSDN on Oct 11, 2005 In reference to a previous blog from Il-Sung Lee called "How to enable channel e...

244

SQL-Server-Team on Mar 23 2019 04:10 AM

First published on MSDN on Oct 10, 2005 When using a Visual Studio 2005 application to retrieve a SELECT statement resul...

691

SQL-Server-Team on Mar 23 2019 04:10 AM

First published on MSDN on Oct 03, 2005 SQL Server 2005 offers the capability of channel encryption through the use of S...

374

SQL-Server-Team on Mar 23 2019 04:10 AM

First published on MSDN on Sep 23, 2005 Another customer issue using SQL Server enumeration.

199

SQL-Server-Team on Mar 23 2019 04:10 AM

First published on MSDN on Sep 23, 2005 I have recently came across the following problem: a customer was using EnumAvai...

Latest Comments

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

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

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

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

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