SQLServer Connection String

[bob6265]

The string below is used to connect to our DB from within the EA user interface.  This works great.

"enterarchrepd --- DBType=1;Connect=Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDB;Data Source=SomeDataSource"

However, if I use this connection string in C#, it prompts me for a password.  Even if I type in my Windows password it fails.  

Has anyone run into this issue?  If so, please help!!

Thanks.

Bob

[«Midnight»]

Hi Bob,

Some questions...

What happens if you try to connect to SQL Server from your desktop, without an application open. You can check this by creating a new DSN on your system.

Do not enter username or password credentials, choosing instead to connect via Windows integrated security.

What happens? Are you challenged, or does SQL Server accept you Windows ID as sufficient?

If that works, what happens if you attempt to connect EA to a SQL Server repository in another Windows domain?

David

[bob6265]

Thanks for the quick reply David!!  I created a local DSN and the test connection works fine.  It will take some time to test out the other domain suggestion.  I'll need to request access.

[«Midnight»]

I Bob,

I don't know if you need to do all that, at least not yet.

It is just that I have had difficulty in a similar scenario when the EA file was hosted on another domain. I get various permutations of whether (and how) I can connect with EA or by using the EA connection string (or any other string).

These problems seem to be related to credentials. However, given some recent problem reports they might also have been the result of the database providers (client side) involved.

Sadly, I am not using a configuration where I can test this for you. Nor can I narrow this down. In particular, I cannot say whether this is where you are having your problem.

David

[bob6265]

Thanks for taking the time.  Once I figure it out I'll post the solution.