SQL Server supports load balancing on read only database only, where more than one instance access the same database.

However other ways to load balance will be

1. Add a new SQL Server and setup merge replication between two servers, you can then load balance the connection using any load balancer (Cisco, F5).

2. If merge replication is not an option then you have to consider splitting the application and database if possible.