Groups | Blog | Home
all groups > sql server replication > april 2006 >

sql server replication : how to configure the SQL services to use a DOMAIN account



Paul Ibison
4/27/2006 9:51:12 AM
Peter,
go into control panel, administrative tools, services, SQLSERVERAGENT. On
the log on tab, select the account by browsing AD. You can do it through
Enterprise Manager but there's no browse option. You might also want to set
MSSQLSERVER to use the same account.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Paul Ibison
4/27/2006 11:43:27 AM
Peter,

there are several possibilities here:

(1) a naming issue.
Try:
Use Master
go
Select @@Servername

This should return your current server name but if it
returns NULL then try:
Use Master
go
Sp_DropServer 'Server1'
GO
Use Master
go
Sp_Addserver 'Server1', 'local'
GO
Stop and Start SQL Services


(2) If this is not the issue, but you are working across non-trusted doamins
there is the same error, so you might want to have a look at this article:
http://support.microsoft.com/?id=321822.


Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Peter King
4/27/2006 4:34:34 PM
-----------------------------------
SQLCE (Server Tools) will not install without SP1 it will not install with
SP3. You must install SQL2k -> SQL2KSP1 --> SQLCE --> SQL2KSP3
SQL Replication will not work if the SQL service is running under the system
account. You MUST configure the SQL services to use a DOMAIN account with
'run as service' privilege

Steps
Run SQL 2K Installer.
Change the Instance Name
Do NOT use the System account. It does not work for replication.
The account you use must run as a service
The account must have a password
change the sa password
----------------------------------------

Hi All£¬
I already install the sql2K,and then how to add a DOMAIN account?
Thanks
Peter

Peter King
4/27/2006 5:37:04 PM
Hi,Paul:
Error 18483
'distributor_admin' is not setup for remote access.
Peter

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> дÈëÏûÏ¢ÐÂÎÅ:uWiS5edaGHA.1240@TK2MSFTNGP03.phx.gbl...
[quoted text, click to view]

AddThis Social Bookmark Button