Not a Trusted Connection

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.

Who is Participating?
RainMan82Connect With a Mentor Commented:
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.
DanimalAuthor Commented:
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.


DanimalAuthor Commented:
NO ONE has an answer to this?  Dang!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.