Ryan Adams Blog

SQL, Active Directory, Scripting

Browsing Posts in SQLAgent

Have you ever had an error when using a SQL Server Proxy Account?  I ran across a misleading error.  Let me qualify that a little.  It wasn’t misleading in the sense of it saying one thing and meaning another.  It was misleading because it’s one of those errors you see for multiple things and I […]

I recently had to rename my laptop on which I have two SQL server instances.  I have a default instance and a named instance.  I actually have had the laptop renamed for awhile without any issues, but it’s not production and I don’t use it every day.  I first encountered the error while creating a […]

Do you get error 435 in the Application event log and your SQLAgent fails to start?  The reason you’re getting this error is that the SQLAgent error log and working directory file locations are not available. I recently ran into this after moving the user and system databases to a different SAN drive.  Even though you tell SQL […]