cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Server 2005 integrated security

Former Member
0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

former_member183750
Active Contributor
0 Kudos

Answers (2)

Answers (2)

Former Member
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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