SQL SERVER AGENT I SNOT RUNNING....

• gaddamshiva

  SSC Veteran

  Points: 268

  More actions

  April 29, 2014 at 2:04 am

  #292840

  hI experts....

  Today morning i was deleted eventveiwer logs(applicatin,system) at that onwards my server is running without sqlserver Agent. my sysadmin permission also deleted. Now i cant createw new Database and logins. and some of the MSDB tables not displayed.

  what is the problem...

• SrcName

  Default port

  Points: 1440

  More actions

  April 29, 2014 at 2:23 am

  #1709335

  log in with your Administrator,

  that is user specified when you installed sql server.

  If you forgot the pass and user name then read about recovery SA password