I am trying to connect to crystal report from Visual Studio 2010 but i realised my SQL database should have SQL authentication (i.e requires user and password) instead of windows (which was assigned by default).
I have tried several approaches to achieve this without luck. Will appreciate some help.