Grant Fritchey (2/23/2016)

---

One good example I know that people use, it's a structured study program that forces them to learn stuff they wouldn't necessarily work with. I hear that, I'm...

Thanks for your response Grant. At what point do you feel experience outweighs the need for a certification? I'm coming up on 7 years as being a DBA.

It is set to auto shrink. :pinch:

Thank you Craig. I will get it turned off.

It's set to full recovery with hourly log backups.

Just in case anyone else is having this issue, this is what I did to solve it. The command needed a tick mark (`) to escape a special character....

A little more info. This used to be a stand alone server and the job would work even with a non default port number. We then moved it...

It is still happening. Haven't been able to duplicate it on another system.

I'm having the exact same issue as this post but not a virtual server nor in a clsuter.

http://www.sqlservercentral.com/Forums/Topic984495-146-1.aspx

On the default instance, under policies, there is a SQL Server Password Policy. It has a check condition of Password Policy Enforced and the target is Every Login. ...

These were taken from the B instance.

Login failed for user 'TestServer\DefaultAgent'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]

Error: 18456<c/> Severity:...

http://support.microsoft.com/kb/921106

Under the "Cause" section.