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

Thanks very much: I altered my publisher account to impersonate the SQLServer
Agent acount and that seemed to clear up the problem.

Much appreciated!

"Hilary Cotter" wrote:

> Are both SQL Servers and SQL Server agent running under the same account?
> Are they in the same domain or in trusted domains?
>
> Can you ensure that on both servers when you do a select @@servername you
> get the server name and not local?
>
> Also verify that you are using the impersonate the SQL Server agent account
> on the publisher.
>
> Finally what proc is causing these errors?
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "len" <len@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:1BAE7160-938A-4479-B1F1-871F63624CF6@xxxxxxxxxxxxxxxx
> > 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: Running SQLServer and SQLServer Agent as Power User
    ... The account that starts the services needs to have the "log on as a service" ... Without this MSSQLServer and MS SQL Server Agent will not start. ... Also why would you want end users to have admin rights on the server at all? ... > on our Win2K servers, ...
    (microsoft.public.sqlserver.security)
  • Re: Remote disk space analysis
    ... Check the drive space on all of the servers listed in a text file and store the output like Server name, Drive Name, Disk Space and Free space information on a SQL Server table. ...
    (microsoft.public.scripting.vbscript)
  • Re: Has anyone got delegation to work???
    ... Yeah I am trying to set up and it is a PITA. ... Both servers are running only TCP/IP ... My account has "Account is sensitive and cannot be delegated" cleared ... > Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Clustered Node restarting unexpectedly
    ... Found it to be a NMI that was caught by the system BIOS ... Mike Epprecht, Microsoft SQL Server MVP ... > Servers on 2 nodes connected to SAN Storage using Fibre ... > for network name resource SQL network name ...
    (microsoft.public.sqlserver.clustering)
  • Re: Not associated with a trusted SQL Server connection....
    ... Are both SQL Servers and SQL Server agent running under the same account? ... Are they in the same domain or in trusted domains? ...
    (microsoft.public.sqlserver.replication)