Not associated with a trusted SQL Server connection.

Posted on 2006-04-25
Last Modified: 2011-10-03
I have added a new server registration and all is running fine for this new instance and the app that uses it.
However, I open QA and I connect to server X and run....

select * from y.myTable (Y is the new instance)
and I get the error...
Server: Msg 18452, Level 14, State 1, Line 1
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Both servers have windows and sql authority.
I am logged on as myself and am a member of SA on both boxes.
Any ideas?
Question by:QPR
    LVL 29

    Author Comment

    I fixed it!
    Under server X security within linked servers, Y was listed. However it was listed as connecting under current security.
    I checked another box and thatw as set to connect using the SA uname/pwd.

    So 500 points to whoever can explain what that is and what I just did please :)

    Accepted Solution

    PAQed with points refunded (500)

    Community Support Moderator

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    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.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now