Duplicated Admin Passwords need to be replaced with unique passwor

We need to change passwords for 4 replicating servers. To date, they've all
shared the same Administrator password and connect using NT authentication.
The servers now need to have unique passwords. 2 servers are members of the
same domain and the other two are members of seperate workgroups. What's the
most secure and efficient setup for replicating servers with unique
passwords? Create a unique administrator rights user on each server and set
SQL to start up as this user on each server and duplicate the user on the
other servers so authentication works? ...
Steven,
I assume you are referring to the agent startup logins? Typically you use a
domain login who is a local administrator - same account for the SQL Server
agent and SQL Server Service. If they are different on each server and
replication is using trusted security, have a look in BOL for the rights
required in replication for the SQL Server Agent in each part of your
topology ("replication, security"), and the entry required in the PAL.
HTH,
Paul Ibison

Dump of databasse

I have a sql 2000 database on my local machine that I need to get to a far
away server so he can make one like it on his server. The admin tells me I
need to make a dump of it and send it to him. I just don't know how to do
that. Can someone help me out?

Thanks,
JerryI would just backup the database so the far-away can restore it on his
side.|||Jerry (notmyspam@.houston.rr.com) writes:
> I have a sql 2000 database on my local machine that I need to get to a far
> away server so he can make one like it on his server. The admin tells me I
> need to make a dump of it and send it to him. I just don't know how to do
> that. Can someone help me out?

BACKUP DATABASE db TO DISK = 'C:\temp\db.bak'

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx