?
Solved

Not a Trusted Connection

Posted on 2005-05-13
3
Medium Priority
?
235 Views
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.


0
Comment
Question by:Danimal
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
RainMan82 earned 225 total points
ID: 13999195
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.
0
 
LVL 1

Author Comment

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

http://citrix.cabotcheese.com/dev_02/cheesehub/

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.

Thanks.


0
 
LVL 1

Author Comment

by:Danimal
ID: 14018187
NO ONE has an answer to this?  Dang!

0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

862 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