SQL Server Blog

Options
1,824
DavidEngelMS on May 03 2024 03:50 PM
4,783
TarynPratt on Apr 15 2024 06:43 PM
1,975
HarveyMoraSQL on Apr 11 2024 04:14 PM
1,907
HarveyMoraSQL on Apr 09 2024 02:03 PM
1,856
HarveyMoraSQL on Apr 09 2024 02:03 PM
1,946
HarveyMoraSQL on Apr 09 2024 02:03 PM
1,867
HarveyMoraSQL on Apr 09 2024 02:02 PM
26.2K
DavidEngelMS on Apr 09 2024 11:10 AM
1,681
EbruErsan on Apr 03 2024 01:17 PM
13.9K
erinstellato on Mar 19 2024 11:18 AM
2,010
SrinivasSQL on Mar 14 2024 04:37 PM
11.2K
erinstellato on Feb 29 2024 03:50 PM
6,303
DavidLevy on Feb 28 2024 02:49 PM
4,132
Venkata Raj Pochiraju on Feb 26 2024 09:06 AM
2,387
DavidEngelMS on Feb 16 2024 02:42 PM
2,485
DavidEngelMS on Feb 16 2024 02:35 PM
2,193
DavidEngelMS on Feb 16 2024 02:02 PM
19.2K
erinstellato on Feb 16 2024 10:51 AM
2,426
SrinivasSQL on Feb 15 2024 01:54 PM
3,619
DavidEngelMS on Jan 31 2024 09:00 AM
2,206
DavidEngelMS on Jan 31 2024 09:00 AM
2,096
EbruErsan on Jan 26 2024 12:45 AM
2,605
SrinivasSQL on Jan 11 2024 06:45 PM
2,094
SrinivasSQL on Jan 10 2024 09:50 AM
2,512
SrinivasSQL on Jan 10 2024 09:40 AM
12.6K
DavidEngelMS on Jan 09 2024 11:34 AM
3,307
SrinivasSQL on Dec 14 2023 04:39 PM
6,098
Venkata Raj Pochiraju on Dec 12 2023 07:07 PM

Latest Comments

@Jay_Patel225 Make sure you have enabled Microsoft Update (Receive updates from other Microsoft products). For ODBC 17, ensure the following registry entries exist: LCID (REG_DWORD) HKLM\Software\Microsoft\Microsoft ODBC Driver 17 for SQL Server PatchLevel (REG_SZ) under HKLM\Software\Microsoft\Micr...
0 Likes
Hello @DavidEngelMS , Thank you for the informative article. We have noticed that half of the servers didn't receive an ODBC and OLE update through Microsoft Automatic Windows Update. We have double check the below path to make sure the ODBC or OLE Drivers are installed and properly registered in or...
0 Likes
all of that is great and well, but someone in your org decided to default the encryption level to MANDATORY when OPTIONAL would have been a smoother transition for orgs with hundreds of thousands of dollars in MS licenses per year.
1 Likes
@sqlBender We migrated SSMS 20 to version 5.x of the Microsoft.Data.SqlClient driver because support for additional encryptions (via the driver) was added in SQL Server 2022, and we needed to bring that same encryption functionality to SSMS. This offers customers improved security, which many compan...
0 Likes
we are using the shared central management server feature, and using SSMS 20 with the encryption set to mandatory as a default, we are not able to "connect" to the group without manually setting the encryption property to "Optional" and saving each connection. Where is this connection information sa...
0 Likes