Prizm ?

When I install Prizm on a server do i install Microsft SQL on same server or can i install it on another please gives some suggestion

You can do both, depending on your needs.

Running everything on one server is just fine, or if your Canopy network is huge (or your server(s) wimpy) then you could seperate the Prizm processes onto several servers:

Server A: SQL
Server B: License management
Server C: Prizm

It would not supprise me if it can be sepperated even further, this is just all I think of off the top of my head.