Monthly Archives: June 2013

[SOLVED] :MS SQL Server 2008 R2 Error Log Growing in huge size

On SharePoint Database server SQL error log file was getting increased in huge size in 2 day 5 GB and below message was getting recorded in it continuously

SPID 24s ” An exception occurred while enqueueing a message in the target queue. Error: 15517, State: 1. Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission. ”

So get the details which process is getting error followed below steps

  1. Opened new Query Window
  2. SP_who2 and searched for SPID 24
  3. It was spid 24   status: background    loginname: sa    cmd: BRKR Task
  4. Now select * from Sys.sysdatabases to get the list of all databases
  5. Copied all databases names in Excel file and created below commands
  6. Use <Databasename > ( for all databases )
  7. Go
  8. sp_changedbowner ‘SA’
  9. same for all Databases ( list copied from step 5)
  10. executed in bunch
  11. Restarted SQL server service.

That’s all , it has resolved the error logging issue and Log file stopped growing with the error meesages J

Thanks

 

Prashant Deshpande


 

Advertisements

Leave a comment

Filed under Uncategorized

[SOLVED]: 403.18 Cannot execute requested URL in the current application pool

Due to heavy load on web site which is configured on webfarm in remote share environment started giving below error on all servers.

After lot of googling also I haven’t got any appropriate solution

So tried below steps and it worked J

  1. Created new app pool with same framework and credentials.
  2. Assigned the newly created pool to the website
  3. Tried by browsing and it started working.

So according to my experience we need to created new app pool to resolve the 403.18 Error.

 

Thanks

Prashant Deshpande

 

2 Comments

Filed under Uncategorized