I am using Crystal Report 2008 and SQL Server 2005.
I use: myconnectioninfo.integratedsecurity = true
and the screen pops up with a login page when attempting to access SQL Server. Is there a way to put the user's login credential in visual basic so there is no login prompts?
i.e.
myconnectioninfo.userid = XXXXX
myconnectioninfo.passowrd = xxxx
for all users?