SQL Server to SQL Server connection

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.
dspaceAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RiteshShahCommented:
are both server stands in same network? if yes, have you set up linked server? if no, do it now than proceed further.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
aboredmanCommented:
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
pssandhuCommented:
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
dspaceAuthor Commented:
Linked server login was the problem.  Thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server OS

From novice to tech pro — start learning today.