Q. How Named Cal assignment would be done
A. You can create loca windows user or custom directory and assign the named cals
Q. How to establish connection between Database server and Qv server in a workgroup environment . The back-end DB is Sql Server.
A. You can use SQL auth for SQL access from Qlikview.
Let me know if this is help to solve you problem.