Tuesday, January 19, 2010

Free SharePoint Performance Monitor - Idera

Anyone who is on a budget might appreciate this by Idera.

SQL Error 18456, Severity: 14, State: 16 - Login Failed

Yippppie another awesome error - solution coming soon. Let the count down begin... (really this one only took a few hours, it was an easy one..compared to most)

OK so that was extra stupid. All regarding this SharePoint SSP SQL job; 'DBName_DB_Job_DeleteExpiredSessions'. In my case the job is named 'SharedServices_DB_Job_DeleteExpiredSessions' and I don't even have a database named that. My SSP db is called...'SSP_DB' so I modified steps inside the job by using properties and clicked on steps. The database drop down was set to null, which is why (I think) I was getting errors on 'Master' So I just changed the association to the correct db and it works great now.

I finally found this TechNet blog post explaining what this dang job does...for your reading pleasure. This post also assisted in solving this mystery.

I just want to note that I also have more than one of these jobs, which is due to multiple SSP restores. I also had to kill those by just right clicking on the job and choosing disable. After refreshing the application log in the Event Viewer on the SQL server all my lovely errors are gone.