Solved

SQL Server to SQL Server connection

Posted on 2009-07-13
4
209 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
4 Comments
 
LVL 31

Accepted Solution

by:
RiteshShah earned 250 total points
Comment Utility
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
Comment Utility
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 250 total points
Comment Utility
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
Comment Utility
Linked server login was the problem.  Thanks!
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

763 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

6 Experts available now in Live!

Get 1:1 Help Now