Replication and permisions

From: Hernán Paggi (forosql_at_yahoo.com.ar)
Date: 07/21/04 

Date: Wed, 21 Jul 2004 11:31:20 -0300

Hi, I have some troubles with replication and permissions. I have two SQL
Servers on different phisical locations. Both servers establish your
comunication through a VPN. But replication don't works due permissions
problems between both servers (this happens on Windows and SQL. I think that
the solution is to deploy a DC on a server, and make member of that domain
to other server and clients. I'm confused and it's critical.

Sorry my english, I'll wait for some suggestions-

Thanks

Hernán Paggi
Argentina

Relevant Pages

  • Re: Need starting advice...
    ... Never ask a woman about to give birth if she wants more kids. ... to non domain servers as well as domain servers... ... done it many times) that it can take 200 lines of code to setup SQL ... Server Express to handle replication. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL 2000 view current job status best practice
    ... The TargetServer role doesn't let you see the current status of a job you ... Jasper Smith (SQL Server MVP) ... Then what you could do is grant permissions to execute the procedure to ... jobs running on production SQL 2000 Servers. ...
    (microsoft.public.sqlserver.security)
  • 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: A clustering question
    ... completely synchronize the SQL application with synchronous replication. ... This will virtually mirror the SQL application on the 2 servers. ... replicated data cluster which can perform the exact task that you ...
    (microsoft.public.windows.server.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)