Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-24 : 01:24:39
|
| Sylvain writes "Server OS : Windows 2000 SP2SQL Server Engine : SQL Server 2000 SP2I have 2 server one in my lan and the other is in another location on the internet. So those two servers are not on the same domain. I saw in one of my SQL book (written by Marc Israel) if the two servers are not on the same domain you have to start ach of the SQL AGENT SERVICE with the same account name and the same password and those account have to have in the administrator group, have the right to Log on as a service, Can connect at any time, and password never expire ....what I did ! And it s still won't work. My questions are what I'm doing wrong ?Does the MSSQL Server service have to be started with the same service ?Do I have to know anything else ?Please help me I'm in deep trouble with that problem !Thanks a lotSylvain Boisvert" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-24 : 08:14:46
|
| Um, what exactly is not working? Does SQL Server Agent start or not? Does it work for one machine or neither? Do these 2 servers have to communicate with each other? The fact that one is on a LAN and the other is not does not affect whether the services start correctly. The MS SQL Server service does need to be running in order for SQL Agent to work properly. |
 |
|
|
sboisvert
Starting Member
1 Post |
Posted - 2002-06-25 : 12:38:43
|
| Yes Sql server agent start. These two server are not on the same lan but they can communicate by internet. I manage those two sql server with entreprise manager from my desktop ! I took a network sniffer (IRIS) and I saw the packets going to one server to the other but I just don't know what's happen when they try to replicate one to the other ! I think it<s something in the security do you know something else that I don't about the security ? Please help me !Sylvain |
|
|
|
|
|
|
Sql Server 2000 Replication problem !