How do I fix a Database Authentication Error

Question

When I run my aspx file I get this:

      No error message available, result code: DB_SEC_E_AUTH_FAILED(0x80040E4D).

Why is this happening exactly?

Here is my web.config file:

 <add name="2007 Database  05-12-2013(Esfahanian's conflicted copy 2013-06-24)
  ConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data 
  Source=" providerName="System.Data.OleDb"/>

and here relative path in my aspx file:

<script runat="server">
    string connectionString = ConfigurationManager
    .ConnectionStrings["2007 Database 
    05-12-2013(Esfahanian's conflicted copy 2013-06-24)ConnectionString"]
   .ConnectionString + HttpContext.Current.Server.MapPath(@"Anderson\2007 
    Database 05-12-2011 (Esfahanian's conflicted copy 2013-06-24).mdb");
</script>

The web.config string looks like it's missing some pieces, but I've not worked with the Jet.OLEDB before, so I'm not sure. — Garrison Neely
– Garrison Neely, Commented Jul 18, 2013 at 18:13

Bill · Accepted Answer · 2013-07-18 18:24:24Z

3

Your connection string is definitely not right. The "Name" property is only used internally by your application, in this case, the .aspx file. You need to have the name of the database file somewhere in the actual connection string.

Here is my favorite source for all things connection string: http://www.connectionstrings.com

answered Jul 18, 2013 at 18:24

Bill

4,6153 gold badges24 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

foobar2023 Over a year ago

I don't see anything on make the path relative, all the examples show absolute

Bill Over a year ago

Google is your friend: stackoverflow.com/questions/1833640/…

Collectives™ on Stack Overflow

How do I fix a Database Authentication Error

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related