Ryan Adams Blog

SQL, Active Directory, Scripting

Browsing Posts in SQLAgent

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 [...]