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?
myconnectioninfo.userid = XXXXX
myconnectioninfo.passowrd = xxxx
for all users?
Thank you much for the response. I believe I tried the steps to turn on integrated security
i.e. myconnectioninfo.integratedsecurity = true
changed IIS setting to disallow anonymous access
but it is prompting for userid and password when accessing the DB. Not sure this is by design.
The last part of the article about single sign on appeared to say you need Kerberos ?
So I am not sure if I need Kerberos to get rid of the login prompt..