Cannot open database error

Question

I have the below query in my console appliaction

 SqlConnection myConnection = new SqlConnection("user id=abc;" +
      "password=xyz;server=test;" +
      "Trusted_Connection=yes;" +
      "database=tested123; " +
      "connection timeout=30");
                myConnection.Open();

When I run the above application, it is working fine .But when publish this, it is throwing an error for the other users who are not having access to this DB .To avoid this I have created one service account "abc" and added it to the required DB.But it is still failing with the below error .

System.Data.SqlClient.SqlException (0x80131904): Cannot open database "tested123" requested by the login. The login failed.

Login failed for user >> user who is running this app.

How to run EXE with some custom account for all the users ?

I think your fixing the wrong error here.. you should be fixing the one that throws the error for users without access — Sayse, Jul 11 '14 at 06:56
my question is for all users it should run with some custom account — user3543884, Jul 11 '14 at 06:58

Baximilian · Accepted Answer · 2018-05-01T20:11:14.997

2

I think you have to remove this row

Trusted_Connection=yes;

Using Windows credentials and is 100% equivalent to:

Integrated Security=SSPI;

Or

Integrated Security=true;

If you don't want to use integrated security / trusted connection you will need to specify user id and password

More about .NET Data Provider for SQL here

More about connection string here

As you can see in MSDN

Integrated Security -or- Trusted_Connection

When false, User ID and Password are specified in the connection. When true, the current Windows account credentials are used for authentication.

edited May 01 '18 at 20:11

answered Jul 11 '14 at 07:01

Baximilian

885
7
25

Thanks man it is working. But i have one question when we publish our web application in IIS ,we specify account details in application pool settings ,Do we have same mechanism for console application instaed of hard coding account details in the code – user3543884 Jul 11 '14 at 07:26
@user3543884 You can use app.config to store connection string in your console application. This can help you with flexibility – Baximilian Jul 11 '14 at 07:34

dougajmcdonald · Answer 2 · 2014-07-11T07:06:15.547

0

This is because you've got Trusted Connection in your connection string.

That means you're effectively using Windows Auth, not the details in the string. Remove that and you should be ok.

By using Windows authentication you're asking the application to make the connection as the user who is running it.

edited Jul 11 '14 at 07:06

answered Jul 11 '14 at 07:00

dougajmcdonald

19,231
12
56
89

score 0 · Answer 3 · edited May 23 '17 at 12:22

0

You could go to the web http://www.connectionstrings.com/ and find out the connection string of your specific data base.

On the other hand, there is another similar question about this here: SqlException: System.Data.SqlClient.SqlException (0x80131904)

edited May 23 '17 at 12:22

Community

1
1

answered Jul 11 '14 at 07:15

Pablo Caballero

340
2
10

score 0 · Answer 4 · answered Jul 11 '14 at 07:15

0

Replace

Trusted_Connection=yes;

to

Integrated Security=false;

in your connection string.

answered Jul 11 '14 at 07:15

tom

719
1
11
30

Cannot open database error

4 Answers4