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-13 : 08:10:24
|
| nadeesh writes "Hi,I am running sql 2000 Enterprise edition on Windows 2000 which is in workgroup. I am not using any domain or active directory on that computer.MSSQLSERVER and SQLSERVERAGENT services are running as local system account.I want to use Replication and log shipping (combination of both). Is it possible in workgroup model or domain is the only option for it." |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-06-13 : 14:52:23
|
| Replication can be implemented between databases on the same server or between different servers connected by LANs, WANs, or the Internet.I suggest you 'pick your poison' and try some searches on the Microsoft site. You should be able to find some 'How To's on setting up replication for your preferred connection. |
 |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-06-13 : 16:26:39
|
| Like Kevin said, you should be able to set up replication and log shipping under a workgoup model. But in order to set it up the services will need to run under a user account rather than LocalSystem because LocalSystem does not have network access priveledges. |
|
|
|
|
|
|
sql server high availibility