Yes, sounds like that is likely what the DBA did...those dang DBAs are always messing things up 🙂  I think that's one of the reasons that people often have examples...

You can create an alert for that error number which I think would be 1101, you can check your logs to verify. On the response, send the notification to whatever...

Changing the initial size in SSMS just executes a DBCC SHRINKFILE.  You may have tried to shrink to a size that it couldn't shrink to due to space in use....

You can try the process of unloading and reloading the performance counters - the steps are outlined in this post:

https://andyhogg.wordpress.com/2014/10/03/repairing-dropped-ssas-performance-counters/

If this is SSAS 2017 tabular, the counters are known...

You might also want to try a tracert from the two different servers to the DB2 server and see if you can find anything in the network paths that could...

You wouldn't need to enable the snapshot daily, you just use that when you have updated the publication and need to send a new snapshot to the subscribers. You could...

The principals would still need access/connect permissions to the database, not just the insert permissions from the public role.  The trigger will still execute under the login's permissions. When you...

It doesn't necessarily need to be one or the other. Kerberos would be preferred but the connections should fall back to NTLM if Kerberos fails. If on start up it...

Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: 10.11.12.13] Error: 18452, Severity: 14, State: 1. SSPI handshake failed with error...

Thanks...they show up now. You can find more information for the error in the SQL Server error log or clicking on the Technical Details on the bottom left of the...

Ah yes, Production In Lieu Of Testing (PILOT). I drink because I've spent two days trying to persuade somebody that the issue was not in the database, and that...

The error didn't come across if that was an attachment - could you type out the exact error message and error number?

Sue

Ran into the SPN (cannot create sspi context) issue but only for some named instances however we are also missing some SPN's they are not associated with either the...

I think you identified the issues 🙂

Don't forget to check the reporting services logs, they can give you a lot...

It's just missing the closing parenthesis after 107 on formatting the date - should be GETDATE(), 107) + '.xlsx)'

Sue