Link to home
Start Free TrialLog in
Avatar of Allan
AllanFlag for United States of America

asked on

DB Connection Issue

Hi Experts!

Thanks for reading this.

Have a Win console that reads a table on SQL Sever.

Ran it locally and it works.

Ran it on the DEV server (Win 2008) and we have this error:

 ExecuteReader requires an open and available Connection. The connection's current state is closed.

On the DEV server there's an ODBC instance (SomeDB)

Here's the connectionstring for console app:

<add key="SQLConnection" value="Data Source=SeverA\DB1;Initial Catalog=SomeDB;Integrated Security=SSPI" />

*SomeDB = a db name that the table resides

Any ideas what's causing the issue?


ASKER CERTIFIED SOLUTION
Avatar of vasto
vasto
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Allan

ASKER

yes. Thanks!
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Allan

ASKER

I think I figured it out; it's running under a different AD account. bummers.
Trying to get it to work under the right account. Thanks!
Avatar of Allan

ASKER

We'll; it looks like an account issue; I'll split points. Thanks!