security

45 Topics

SQL Server Unconstrained Delegation failing after 10 hours
After the Windows updates from November 2020, you might be facing some issues running Bulk Inserts or working with linked servers, if you keep an open session for more than 10 hours. Some recent changes were done on the Windows side when it comes to the way S4U (Unconstrained delegation) Kerberos tickets work.
FranciscoBertao
Jan 27, 2021 Place SQL Server Support Blog
5KViews
7likes
0Comments
TLS Issue with SSIS package while accessing OData Source like Dynamics AX Online
First published on MSDN on Jan 16, 2018 I have come across an interesting scenario recently while working on one of the customer issues.
Krishnakumar_Rukmangathan
Jan 15, 2019 Place SQL Server Support Blog
8.7KViews
1like
1Comment
Changes to hashing algorithm for self-signed certificate in SQL Server 2017
First published on MSDN on Nov 08, 2017 Starting with SQL Server 2005, a self-signed certificate is created automatically during the startup to be used for channel encryption.
Venu Cherukupalli
Jan 15, 2019 Place SQL Server Support Blog
22KViews
0likes
2Comments
Error while impersonating an user in SQL Server Analysis Services
First published on MSDN on May 30, 2017 Hi folks, recently I came across an interesting issue related to impersonation in SSAS and I thought of sharing with you.
Krishnakumar_Rukmangathan
Jan 15, 2019 Place SQL Server Support Blog
6.2KViews
0likes
0Comments
Unable to drop a user in a database
First published on MSDN on Nov 15, 2016 A user called in for help because he wasn’t able to drop a user from a database.
mssql-support
Jan 15, 2019 Place SQL Server Support Blog
7.7KViews
0likes
0Comments
Unable to connect to SQL Server on azure VM due to an extra NSG applied to subnet
First published on MSDN on Sep 18, 2016 If you need to open up your SQL Server on an Azure VM to public internet access, you need to look no further than this document Connect to a SQL Server Virtual Machine on Azure (Resource Manager).
mssql-support
Jan 15, 2019 Place SQL Server Support Blog
5.5KViews
0likes
0Comments
Enable TLS 1.2 protocol for Reporting Services with custom .NET application
First published on MSDN on Jul 12, 2016 If you are using any custom application which is integrated with any payment gateway you might be thinking of using a secure protocol while doing the communication between them.
Krishnakumar_Rukmangathan
Jan 15, 2019 Place SQL Server Support Blog
46KViews
0likes
1Comment
Why do I get the infrastructure error for login failures?
First published on MSDN on Jul 09, 2016 In the past few weeks, I saw this error come across quite a bit and thought I will provide an explanation for the reasons why we generate this error.
mssql-support
Jan 15, 2019 Place SQL Server Support Blog
29KViews
0likes
5Comments
SQL 2016 - It Just Runs Faster - AlwaysOn AES-NI Encryption
First published on MSDN on May 05, 2016 The SQL Server 2016, AlwaysOn, log transport takes advantage of hardware based encryption to significantly improve scale and performance.
mssql-support
Jan 15, 2019 Place SQL Server Support Blog
760Views
0likes
0Comments
SQLCMD 2014 fails to authenticate via Kerberos
First published on MSDN on Apr 27, 2016 Understanding of the issue:When we try to execute a query on a SQL server from a remote machine using SQLCMD.
Krishnakumar_Rukmangathan
Jan 15, 2019 Place SQL Server Support Blog
2.5KViews
0likes
0Comments