Project Managment Software

I am looking for software to manage our inhouse IT projects. I would like to host on our own intranet or it could be a windows app I guess and maybe link it to our sql 2000 server as well. Does anyone have any suggestions or recommendations on what to use? Thanks in advance.