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.