Not associated with a trusted SQL Server connection....

Tech-Archive recommends: Fix windows errors by optimizing your registry

I'm getting the following error when trying to set up replication between 2
servers (the error occurs on the master when I try to run some stored procs).
Both servers are linked as "Remote Servers":

Login failed for user 'xxxx'. Reason: Not associated with a trusted SQL
Server connection.

The thing is, both servers are enabled for SQL and Windows authentication
and i can log into both servers as user 'xxxx' using SQL Query analyser fine.

Any ideas what could be wrong?
.

Relevant Pages

  • Re: sql 2005 active/passive cluster options
    ... that is storing data on a seperate SQL 2005 Standard box. ... SQL server had an hardware fault causing application downtime for ... their product is an active/passive sql cluster. ... terms of active/passive failover I need two identical servers (since ...
    (microsoft.public.sqlserver.clustering)
  • RE: permissions compatible with pre-Win2000 servers
    ... Based on your reply, the NT machine which running SQL 7 is not a PDC, BDC, ... With regards to the anonymouse connection to SQL, ... >Our concern is for our NT4 servers that are dedicated to running SQL7 ...
    (microsoft.public.windows.server.migration)
  • Re: Performance Monitor / Database Storage using ODBC
    ... This solution would be just working temporarily (a few servers), ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Web App Security Model.
    ... SQL permissions are correctly restrictive (so worse case the allowed ... If these machines are standalone the threats posed by them are ... applications / implementation and whether their design has ... My company wants to have a few Windows Servers running web app's (ASPX ...
    (microsoft.public.security)
  • Chuck, Help! File sharing network issue
    ... Master browser name is: KENSGATEWAY ... backup servers retrieved from master KENSGATEWAY ... Checking \\CAROLYNCOMPUTER...Unable to open Service Control Manager database ...
    (microsoft.public.windowsxp.network_web)