You might be able to get a self-signed certificate to work by importing it into the client as well as the server.

Have you tried connecting to the IP address instead of localhost or the server name?

The following is a .NET reporting solution:

.NET and JS Reporting Solutions | Design Custom Reports in Code | ActiveReports (mescius.com)

TDE seems to be a tick box to lower insurance premiums, meet regulatory compliance etc. Personally I would concentrate on encrypting sensitive columns, with something like Always Encrypted, before getting...

Our servers force encryption so the following works for me.

USE [master];
GO
EXEC dbo.sp_addlinkedserver
    @server = N'<FQDN of Linked Server>'
    ,@srvproduct=N'SQL Server';
GO

Our infrastructure team now has a CA server which is recognised as such by every machine on our network. All I have to do is ask for a certificate with...

Here are my notes about forcing encryption on a local instance. I presume EC2 will be much the same.

1. Check the DoD is a valid CA on the EC2 instance...

• This reply was modified 1 years, 6 months ago by Ken McKelvey.

The customer does not want to spend money on code changes really.... so I have to keep everything basically the same but get rid of filestream and move to...

• This reply was modified 1 years, 6 months ago by Ken McKelvey.

You shold

You may also want to look at object storage. eg...

You shold

You may also want to look at object storage. eg...

Your question is too open-ended.

You need to provide details of the process, versions of SQL Server etc.

You can get a large file very quickly. In SSMS I would go Management | Extended Events | Sessions and right click on Track_Login and start it. Let it run...

No, but it will tell you if the SQL Server SPNs are configured correctly. It also allows you to generate a script, to give to your domain admins, if they...

It might be a Kerberos double hop problem where it falls back to, and manages to connect with, NT AUTHORITY\ANONYMOUS LOGON.

You could try checking the SPNs with the Kerberos...

If there are only a few rows, why is bridgeid a bigint?