Which features of MS SQL are supported through H-Sphere?

You can create user logins, databases, and db users with different database permissions.

Can windows-based accounts use MySQL services?

Yes, MySQL can be installed on any Unix box, and you must have at least one (the control panel).