Solved

"Login failed for user ''. The user is not associated with a trusted SQL Server connection." How do I fix this issue?....

Posted on 2007-03-28
7
7,281 Views
Last Modified: 2013-11-24
At work I have a Windows logon account called username 'bullwinkle' and a password called 'moose'

The IT dept has set up a new machine for me so I can setup IIS with a virtual server to an application I wrote that collects data. The application works 100% fine on my development machine. On the new machine it works great up until the point at the end where I have to connect to the SQL db for writing the data.... then I get the following error:

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

***I would like to emphasize the fact that:

1) there is no username that shows up in the error... only an empty set of commas ' '
2) SQL server is already set to 'mixed' mode

The IT SQL Server guy gave me the user name and password that allow writing and reading from the SQL database for the application I wrote. The username and password he gave me for this is username 'batman' and the password is called 'robin'. However, there is no account on the new machine for 'batman' to logon with.... only my 'bullwinkle' user account will allow me to logon.

I told the IT guy that the new machine needed an account setup for 'batman' and the pasword setup to 'robin' .... this will allow me to use the Windows logon account of 'batman' and password 'robin'. Having IIS set to use Windows logon will then fall back on this 'batman' account----which is the same account and password that is set up with permission to access the SQL Server dbase.

At the moment, the error occurs when I am logged in with my 'bullwinkle' account----but the SQL Server permission to write-read from the database is only authorized for the 'batman' account---which doesn't exist on the new machine.

Am I correct about insisting there has to be a 'batman' account in order to have an existing Windows logon account that will also have permission to write-read to the SQL Server?

Help. ..... many thanks.

0
Comment
Question by:jazjef
  • 3
  • 2
  • 2
7 Comments
 
LVL 13

Expert Comment

by:Wizilling
ID: 18812924
current user logged into the computer/pc/server doesnt have access to the sql databse.
get an adminstrator to give accesss to database.
0
 
LVL 13

Expert Comment

by:Wizilling
ID: 18812956
ignore my first comment.
1) i think the connection string used trucsted connection. you might need to change it in the application so that it uses the choosen user/password.
>>>batman' account in order to have an existing Windows logon
2) if u use a windows authenication (i hope that what is what u meant) then not neccsary to setup a sql authentication account eg batman.
again u need to check the application code for the connection string to see how it connects to the database.

check sql server logs and event viewer failed logins. then u will know what failed for whom. If that information is not there then u need to select (tick) this option in sql server properties.
0
 
LVL 4

Author Comment

by:jazjef
ID: 18813085
Wizilling:

here is my connection string as it is in the application....

        Dim conPACBEW As New SqlConnection
        Dim sConnectionString As String _
        = "Data Source=ABSQL;" _
        & "Initial Catalog=ABINCOMES;" _
        & "Integrated Security=SSPI"
        conPACBEW.ConnectionString = sConnectionString
        Return conPACBEW

Does this connection string info give you any additional insight or suggestions?

That's a great idea about having them look at the logs... that will give me more specific info.....


0
[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 18813132
Since you are using anonymous login, your best bet is to use SQL Server authentication instead of Windows Authentication.
0
 
LVL 13

Accepted Solution

by:
Wizilling earned 500 total points
ID: 18813186
try if this helps

        Dim sConnectionString As String _
        = "Data Source=ABSQL;" _
        & "Initial Catalog=ABINCOMES;" _
        & "UserId=Batman;Password=Robin"

and later if the above works u will have to learn to encrypt the connection string.
0
 
LVL 4

Author Comment

by:jazjef
ID: 18819683
thanks a ton Wizilling! Your solution worked perfectly right off the bat....
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 18820227
You are welcome.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now