Are you using an AD account on this service or are you using a local machine service?

Migrating the master key is easy as long as you have the master key password, you just create that master key on the new instance OR you alter an existing...

I appreciate the response but no this is not the case here.. we arent using any sort of clusting or fail over AGs with this.

It is a SSRS 2016 on...

Note: Sorry, my grammar is not the best, horrible about run-on sentences. 😉

ah crap, they are gonna kick me out of shadow...

There is also a traceflag/command for using the old carnality estimator

TraceFlag 9481

Enables you to set the query optimizer cardinality estimation model to the SQL Server 2012 (11.x) and earlier versions,...

are you saying this database is on five machines , or that users can log in on all but one machine?  Is this like a  contractor vm that they remote...

• This reply was modified 5 years, 7 months ago by  oogibah.
• This reply was modified 5 years, 7 months ago by  oogibah.

I might be wrong.. but wouldn't restoring the master database clear this up? if you have a recent backup and you havent done anything else with that database since.. seems...

SELECT  database_name ,
backup_start_date,
is_copy_only,

        MAX(CASE type

              WHEN...

so.. this script will identify objects that use the blob data type...

SELECT o.[name], o.[object_id ], c.[object_id ], c.[name], t.[name]
FROM sys.all_columns c
INNER JOIN sys.all_objects o
ON c.object_id = o.object_id
INNER...

you can also use  the following to test

EXECUTE AS USER = '<user>'

/* Do Something here */

REVERT -- this changes it back to you

So.. just a note to add.. Azure automatically uses TDE on all databases.. and if you leave it on the default of letting azure handle the key it swaps out...

• This reply was modified 5 years, 7 months ago by  oogibah.

I did think that was a bit simple for what you were asking .. I've never used maintenance plans before tbh hopefully somebody here is more familiar with them

There is a tool for this called KerberosConfigMgr  ... it makes things easier but keep in mind it isnt perfect.

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

Also, there is this command that will let you...

Another option that works if your backup path in your sql server settings is correct

DECLARE @BackupDir nvarhcar(255)

EXEC master.dbo.xp_instance_regread
N'HKEY_LOCAL_MACHINE'
, N'Software\Microsoft\MSSQLServer\MSSQLServer'
, N'BackupDirectory'
, @BackUpDir OUTPUT

• This reply was modified 5 years, 7 months ago by  oogibah.