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,291 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

856 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