?
Solved

SQL Server to SQL Server connection

Posted on 2009-07-13
4
Medium Priority
?
259 Views
Last Modified: 2013-12-05
I am trying to update data in sql server Y (SQL 2000 on Win 2000) from a stored procedure in sql server X (SQL 2005 on Win 2003).

I am NOT running active directory.

When the procedure runs, or for that matter when I issue a simple select statement from server X such as select * from Y.database.dbo.table I get the dreaded   'Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.'

Both servers use windows and sql security.

Anyone have any ideas?  Thanks.
0
Comment
Question by:dspace
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 31

Accepted Solution

by:
RiteshShah earned 1000 total points
ID: 24839879
are both server stands in same network? if yes, have you set up linked server? if no, do it now than proceed further.
0
 
LVL 7

Expert Comment

by:aboredman
ID: 24839884
SQL Errors usually have a number associated with them. Try to google that number along with "SQL Error" and, in my experience, the solution is usually pretty easy to find.

Good luck
0
 
LVL 17

Assisted Solution

by:pssandhu
pssandhu earned 1000 total points
ID: 24839971
If you have set up a linked server and still getting the error then the quickest way to solve would be to edit the login information in the linked server settings and explicitly provide a valid sql server login (username and password) and save the changes.
P.
0
 

Author Closing Comment

by:dspace
ID: 31602830
Linked server login was the problem.  Thanks!
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

765 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