Connection login error in web appliction

Question

0.00/5 (No votes)

See more:

i got following error when i try to run it.

VB

[SqlException (0x80131904): Login failed for user 'mukteshUser'.]
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +428
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
   System.Data.SqlClient.SqlConnection.Open() +122
   YABlog.DAL.Functions.ExecuteSelectCommand(String CommandName) in C:\RahulSingh\TestProjects\YaBlogEngine\YaBlog.DAL\Functions.cs:46
   YABlog.DAL.EntriesDb.GetEntryList() in C:\RahulSingh\TestProjects\YaBlogEngine\YaBlog.DAL\EntriesDb.cs:37
   YABlog.BLL.EntriesAction.GetEntryList(Repeater rep) in C:\RahulSingh\TestProjects\YaBlogEngine\YaBlog.BLL\EntriesAction.cs:37
   _Default.ShowAllBlogs() +45
   _Default.Page_Load(Object sender, EventArgs e) +210
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

what should i do to solve it ?

And this is the site where i got the error message

http://blog.muktesh.in/[^]

Posted 19-Aug-13 0:46am

Archit Patel

Updated 19-Aug-13 0:48am

v2

Add a Solution

Comments

Maarten Kools 19-Aug-13 6:47am

Use the correct username/password probably. Or perhaps you're not selecting the correct database, also an option.

[no name] 19-Aug-13 6:48am

i check it. all think are correct

Maarten Kools 19-Aug-13 6:50am

Well, check your database configuration then, see if everything is configured correctly on that end (e.g. see if you can connect using the SQL Server Management Studio)

CodeBlack 19-Aug-13 7:10am

are you able to access 64.71.143.154 from the server ?
i have checked your site and i am not getting any error.

Maarten Kools 19-Aug-13 7:32am

Maybe it's fixed, because when I checked about 30 mins ago the error was there.

ZurdoDev 19-Aug-13 9:50am

The error is clear. The login failed. Either because you are pointing to the wrong server, the login isn't in the database you are trying to access, the password is wrong.

Asp_Learner 19-Aug-13 10:48am

yes the only one possibility either IP is wrong or userid or password is wrong.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Keith Barrow · Answer 1 · 2013-08-19T04:25:00

As others have said in the comments, the error is clear, one of the following is incorrect:

1. You are connecting to the incorrect database
2. You are using the wrong username
3. You are using the wrong password.
4. You are supply a correct username and password, but your connection is using Windows authentication
5. The account you are using is locked out on the SQL server.
6. You aren't picking up the config values for some reason.

The thing to do is to use the credentials you are passing (copy these from config or where-ever you are storing them) to connect via SQL Management Studio. If you can login this way you can discount 2, 3, and 5 in one step. You can also put a breakpoint on the call itself and inspect the connection object for the connection string.
Other than that you'll have to work out this for yourself as we don't have access to the database to see what is happening.