In SQL 2000, only dbo (not just member of db_owner) and members of sysadmin can execute sp_adduser. Try using sp_grantdbaccess instead.