Not a Trusted Connection

Posted on 2005-05-13
Last Modified: 2010-03-19
I have a web server (IIS) on my PC with web pages that hit SQL Server, through ODBC.  

I have SQL Server installed on a few different machines on our network.

The web pages on my server can hit all the different SQL Server machines,
except one.  When the web pages try accessing that one server, I get an
error message stating

Login failed for user 'lenbean'. Reason: Not associated with a trusted SQL Server connection.

lenbean is registered as a system administrator on the server in question.

I checked the Server Properties, under the Security tab, to make sure it allows
both Windows and SQL Server authentication.  

So, now I am stuck.  I cannot figure out what is different about this computer
from all the others.

I hope someone has an answer to this one.

I'll be hoping, thanks.

Question by:Danimal
    LVL 7

    Accepted Solution

    In order to allow the the web applications  to work correctly you must configure your Internet Explorer web browser to "trust" that particular site. In order to do that, follow these steps:

    1) If you aren't looking at this in Internet Explorer (IE), close your current browser then open IE and return to this page.

    2) From the menu at the top of IE, click "Tools"

    3) Click "Internet Options"

    4) In the window that opens click the tab labeled "Security"

    5) Click the green circle that indicates "Trusted Sites"

    6) Click the "Sites" button

    7) In the window that opens, position your cursor in the box labeled "Add this Web site to the Zone:"

    8) Type the web page you want to be seen.

    9) Click the "Add" button. The text you typed should now appear in the box below.

    10) Click "OK" and then on the next window click "OK" again.

    11) You will need to click the "Refresh" button to reload the current page before the settings will take effect.
    LVL 1

    Author Comment

    My browser works with the web application in question.  Take a look for yourself:

    That website runs on web server on a PC named WebMachine.
    It connects to a MS SQL Server database, which runs on
    another machine, named SqlMachine.  

    However, when I move the database from SqlMachine
    to a different machine with SQL Server, I get the error:

    Login failed for user 'danimal'. Reason: Not associated with a trusted SQL Server connection.  

    Changing browser settings regarding trusted sites/domain/etc. is unrelated to this problem... unless I am confused.  So, if I am confused, pls let me know.


    LVL 1

    Author Comment

    NO ONE has an answer to this?  Dang!


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    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.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    779 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

    18 Experts available now in Live!

    Get 1:1 Help Now