Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Question

0.00/5 (No votes)

See more:

Hi there my Name is Edwin

i having a problem with my website i cannot login via my connection string i get a error say:
==================================================================
Login failed for user ";. The user is not associated with a trusted SQL Server connection.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Source Error:
Line 74:
Line 75: objConnection = New SqlConnection("Data Source=myserverip address,port;Initial Catalog=Matlatladb;Integrated Security=SSPI;User ID=matlala;Password=m@t007;")
Line 76: objConnection.Open()
==================================================================

I asked the company that is hosting my website to change the Authentication to "Windows Authentication Mode (Windows Authentication)" to "Mixed Mode (Windows Authentication and SQL Server Authentication)".
but they told me that they cannot do that since the it will affect other websites on their server.

My question is: Is there a way to get around this, using web config file?

Posted 4-Oct-10 21:48pm

Edwin Rams

Updated 5-Oct-10 2:52am

v3

Add a Solution

2 solutions

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)

Pavel Yermalovich · Answer 1 · 2010-10-04T22:48:00

Solution 1

1. Try to dig out this question at www.connectionstrings.com[^]

2. Try to connect with the next connection string:
Data Source=dbserver;Initial Catalog=db;User ID=some user; Password=some password;

Posted 4-Oct-10 22:48pm

Pavel Yermalovich

Comments

Sandeep Mewara 5-Oct-10 16:58pm

Comment from OP:
Hey Pavel Yermalovich ,

i have tried the link you have given me b4 but it seems that my error is not related to the connection string but i am starting to think the issue is relates to user privileges.

so do you have any idea on how to go about it.

Prerak Patel · Answer 2 · 2010-10-05T01:40:00

Solution 3

I guess User ID=matlala;Password=m@t007; is your windows user ID and password.

Just remove it from your connection string, and add impersonation as the same user in your web.config.

<identity impersonate="true" userName="matlala" Password="m@t007">

:-D Happy coding :-D

Posted 5-Oct-10 1:40am

Prerak Patel