I have found, in order to be an effective manager you need five main skills/attributes:
1. Communication Skills
2. Listening ability
3. Organization skills
4. Vast knowledge of your field (IT, Accounting, Sales, etc.)
5. Knowledge of EVERY other department in your company/firm
Those are the business skills you need. We all need to know how to effective talk and listen, naturally if you aren't organized you'll be inefficient (and it can lead to people walking over you - like your own employees), you need to master the knowledge of your field (department). If you are the manager of say programmers - it's only obvious that you yourself should be a pretty darn good programmer as well.
Finally, I think you need to know a fair amount of what EVER department does besides your own. I know this helps me alot. I speak with other managers (some more than others) all the time and try to stay in the loop with what is going out outside of my department (IT).
There are of course many personal skills that are very VERY valuable to possess to, for instance - do you have a sense of humor? Are you a dictator or do look at yourself as a fair person? Do you smile when communicating to your people, or do you look miserable all the time? You know who have been great "tools" for working on my people skills - Sales people. A good sales person, must be masters at people skills to get their big commission checks. Most sales people (especially women..;) ) are very smooth with people. Learn from them.