SQL Server 2005 integrated security

[Former Member]

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?

[former_member183750 · Accepted solution]

See if this White paper will be of any help:

https://websmp109.sap-ag.de/~form/handler?_APP=01100107900000000342&_EVENT=REDIR&_NNUM=1219774&_NLAN...

[Former Member]

Thank you much for the response. I believe I tried the steps to turn on integrated security

i.e. myconnectioninfo.integratedsecurity = true

edit web.config

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..

Thanks again.

[former_member183750]

You need kerberos if you are doing a "double hop". E.G.; the app is on one server and the database is on another server(?).

[Former Member]

Both App and DB are in same server. But I still get prompted with userid and password.

Is that mean I should be able to login automatically when the setup is correct?

[former_member183750]

If by " login automatically", you mean run the report without passing any database connection parameters then yes that is true.

Can you paste your code in here?

[Former Member]

the link needed userid and password to access. The userid I used for this forum does not work. Not sure why I have to go through so many logins for said articles.

[ted_ueda]

Here's a SDN link to a whitepaper:

[https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b021e47e-be1d-2b10-c6b2-efa9db3abd6b|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b021e47e-be1d-2b10-c6b2-efa9db3abd6b]

Sincerely,

Ted Ueda