• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • Last Modified:

SQL Server 2000sp3a upgrade from wmsde, for sharepoint services, sql agent wont start

I have installed sharepoint services on windows server 2003, using wmsde as db server.
I have now upgraded wmsde to sql server 2000 sp3a, problem is SQL Agent wont start, error log shows 'SQLAgent is not allowed to run'. this happens using local system or domain account as service log on. I need to be able to schedule backups so this is a real pain.

Any ideas??

Rgds
0
chrisfez
Asked:
chrisfez
  • 3
  • 2
1 Solution
 
arbertCommented:
What does the error log show????
0
 
chrisfezAuthor Commented:
just.... [LOG] SQLAgent is not allowed to run same in Win app. log. as well.

0
 
arbertCommented:
Ok, you said "sql server 2000 sp3a"  do you mean you acually upgraded MSDE to SQL Server, or you upgrades MSDE with SP3a?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
chrisfezAuthor Commented:
Sorry, I havent described this very well. Yes it was originally MSDE which was installed when Sharepoint services were installed.

Once sharepoint was up and running on MSDE, I upgraded MSDE to an instance of SQL  Server 2000 SP2, and then applied SP3 to that.
0
 
chrisfezAuthor Commented:
If anyone needs to know I now have have a solution provided by MS Support.

I have posted it here:

http://www.dbforums.com/showthread.php?postid=3609533#post3609533

Thanks
0
 
moduloCommented:
PAQed, with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now