How to add a TDE encrypted database to an Availability Group
First published on MSDN on Jan 07, 2015 By default, the Add Database Wizard and New Availability Group Wizard for AlwaysOn Availability Groups do not support databases that are already encrypted: see Encrypted Databases with AlwaysOn Availability Groups (SQL Server).
How to communicate with Linked Server encryption
I'm using SQL SERVER's Linked Server to link between databases. But there is a security problem with this method. So is there a way to encrypt the communication section when accessing other databases through Linked Server and importing data? Please let me know if you have any good method or experience applying it Thank you.
"Caller does not have permissions to execute the stored procedure" based on sys procedure
Did create the following procedure on my DB to read SQL Server Log: USE [MyDB] GO ALTER PROCEDURE [OMEGACA].[P_SYS_READ_POL_DEBUG] ( @p_log_no int, @p_search_1 nvarchar(4000), @p_search_2 nvarchar(4000) ) AS BEGIN EXEC sys.sp_readerrorlog @p_log_no, 1, @p_search_1, @p_search_2 ; END; Schema, DB user and Login is granted server role "sysadmin". Execute on the above procedure is granted to a certain MyDB's role. This role is granted to a certain DB user X (and login). When this user tries to execute the procedure above, it receives error: Caller does not have permissions to execute the stored procedure based on sys procedure Question: How can I get the needed permission for user X? ps. Granting sysadmin to X is not liked.How to grant ReadServicePrincipalName and WriteServicePrincipalName rights to SQL Server service start-up account without using ADSDIEDIT tool.
First published on MSDN on Jan 06, 2010 I hope you probably know how to fix below different authentication related errors that can occur while connecting to SQL Server with Windows Integrated Authentication.
