Quick google brought me to this:

https://www.microsoft.com/en-us/download/details.aspx?id=57473

Sounds like you need to register your SPN's.  Chances are the SQL Server service account doesn't have permission to register SPN's so you will need to use an account that...

To add to what Steve said, DBMail cannot write to a file on a local folder.  If you are looking to write results from a SQL query to file, there...

Since you are seeing the version as 12.0.2000.8, you are not on SP3.

Doing a quick google, I am fairly confident the problem is you downloaded the installer for SQL Server...

My 2 complaints about amazon (from a shopping user experience) are the push for prime and the items that qualify for free shipping.  Push for prime seems to come at...

I read your question a little differently than Grant and Jeff, so I just wanted to confirm what you were looking to do.

If I understand your question correctly, you want...

If I remember right, the certificate is bound then for all new connections.

This is easy to test by connecting to the database instance with SSMS with and without the "Encrypt...

A repair install doesn't hurt though - it could be something with an update or if your computers were built from a WSUS image (for example) with VS2019 pre-installed, the...

Screenshot is a little hard to read, but I would guess the problem is that the SQL Server Agent user doesn't exist on the database.  Looking at the user, it...

They should just need EXECUTE permissions as far as I am aware.

I would double check that you granted permissions on the correct object in the correct database on the correct...

I created a script that replicates this behavior but I do not have a good "reason" why this behavior exists, just a theory.  Sample script:

DROP TABLE IF...

I would try a repair install of VS2019 or look for updates to VS2019.

It sounds like something may be broken with your VS install (just a guess).

What error are you getting?

Did you install the SSDT (or whatever they are calling it in VS 2019)?  Chances are you are missing the reporting templates for VS2019.  This link has some directions:

https://tomaztsql.wordpress.com/2019/11/03/installing-ssis-ssrs-and-ssas-with-visual-studio-2019/

But the...

If you don't want to create the object on the secondary server first (which is the method I would HIGHLY recommend doing as then you can properly define the datatypes...