Yes, your query should show Kerberos connections if they are using them. To check if the spn has been set up, you could do two things:

Firstly, from a command...

If you're using the search tool on the New Login screen, it won't find the managed service account and you will get this error - I take it that is...

No, the account cannot be shared for another sql service on another server. The account is tied to the server. Even if you were using a normal service account,...

I've used them since SQL 2012. The only issues I had is with setting up kerberos delegation, but this site explains how to get it working:

http://ityogi.se/wordpress/msas-and-kcd/

Oh, and...

Excellent. That works fine. Just what I need.

Thanks.

Perfect, thank you.

If anyone is interested, this is the script I wrote to read the data. This reads the input of one column, reads the first row of the data and...

I asked a question, but I think I've found the solution... ignore me!

Excellent. Thank you. That makes sense. I'll look at the asynchronous scripting and see if I can get it working. Thanks.

drew.allen (3/17/2016)

---

Actually, the best approach is to CROSS JOIN your missing Jobs table with your status table and then LEFT JOIN to the job status table. That way you...

Jacob Wilkins (3/17/2016)

---

To elaborate on this, it sounds like you're looking for something...

I thought that, and it works for where there is a job with no status, but where a job has one or two status's then it joins the wrong status...

Shameless plug:

If you have Redgate SQL Monitor, you could use my custom metric:

http://sqlmonitormetrics.red-gate.com/principals_with_sysadmin_login/

Even if you dont have sql monitor, I am sure you could adapt it to...

Perfect, thank you.

I'll have a dig around and see what I can come up with.

LightVader (2/5/2016)

---

Maddave (2/4/2016)

---

Maddave I'm curious about this issue you saw. I would expect that an entry wouldn't be written to backupset until the backup actually completed? Or was...