Can't perform user authentication with my SQL server

Question

0.00/5 (No votes)

See more:

I just got a web application that was transferred to me to finish. I have step my microsoft management studio. The issue i'm having now is that, each time i run my application and i supply a wrong username or password, i get an error message that my login credentials are wrong. but when i supply a correct username and password, i cant the following output from my browser

Server Error in '/' Application.

Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Unable to connect to any of the specified MySQL hosts.

Source Error:

Line 283: Line 284: Line 285: Line 286: Line 287:

I have searched all through the internet without an answer. What could be the cause?

What I have tried:

Tried to check my connection string, and it is okay

Posted 17-Oct-16 2:14am

Mcbaloo

Updated 17-Oct-16 4:42am

#realJSOP

v2

Add a Solution

Comments

#realJSOP 17-Oct-16 8:22am

Did you ask the original developer for help?

[no name] 17-Oct-16 8:22am

The cause is probably exactly what it says, "Unable to connect to any of the specified MySQL hosts".

#realJSOP 17-Oct-16 8:32am

I wasn't aware that Management Studio could even connect to MySQL databases...

[no name] 17-Oct-16 8:53am

Yeah that part doesn't make any sense. He probably doesn't know that there is a difference between SQL Server and MySQL.

Mcbaloo 17-Oct-16 9:39am

of course i do know that there is a difference between sql sever and Mysql. I have been using Mysql for my asp.net projects for a while. For this issue, i just got the code and database from a co-worker that just left. All i did was to change the config file to ask to provide my own sql details then run the codes. I made use a one of the registered username and password and all i got was the error which i have written above

[no name] 17-Oct-16 9:44am

And, so? What does this have to do with anything? You act as if we personally know you, your skill level, your knowledge, have the ability to see your code, your project, your monitor. The fact of the matter is, we know nothing about you or your project. We only know what you tell us. And the only thing you told us was that you are unable to connect to your MySQL hosts. Well. your code is probably not lying to you.

Mcbaloo 17-Oct-16 9:57am

Well, if i probably said something out of line here i'm sorry. i was only trying to explain my issues. Besides i'm just a rookie seeking for help. Would be glad if you can help with where i can start from.

[no name] 17-Oct-16 10:03am

start by googling "mysql can't connect" and start doing some research.

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)

Mcbaloo · Accepted Answer · 2016-10-17T04:42:00

Solution 1

Well, i had to uninstall the mysql connector running on my system for me to access my sql server. Can't say why this is so but it got my issue solved .

Posted 17-Oct-16 4:42am

Mcbaloo