Re: Publishing data while using same server as distributor
From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 02/16/05
- Next message: Fatiya: "Re: Replication does not work properly"
- Previous message: Paul Ibison: "Re: how to configure one-way merge replication?"
- In reply to: sudha: "Re: Publishing data while using same server as distributor"
- Next in thread: sudha: "Re: Publishing data while using same server as distributor"
- Reply: sudha: "Re: Publishing data while using same server as distributor"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 16 Feb 2005 02:16:18 -0800
You need to set up a domain user account for your sql
server service and sql server agent. Editing the startup
properties in EM won't give you the option to browse AD,
so it's easiest to do this in Control Panel,
Administratove Tools, Services.
Have a look for MSSQLSERVER, SQLSERVERAGENT. For
replication purposes we are almost always just concerned
with the latter service. From the ideal DBA point of
view, you should change them both, however. To make
things simple, select the same domain user for both
services, and this account must be a local administrator.
If not, you'll end up editing permissions on various
registry keys, and you really don't want to have to do
this. After you've restarted, it should all be tickety-
boo.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
>-----Original Message-----
>Hi Hilary,
>Thanks for your response again but in my EM in the
Security Tab of database
>properties the server agent account start up options
frame is disabled,why is
>it? and what do i do with it?
>
>thanks
>sudha
>
>"Hilary Cotter" wrote:
>
>> Right click on EM, select Properties, click on the
security tab and its at
>> the bottom - yes there will be a restart.
>>
>> --
>> Hilary Cotter
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>>
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>>
>> "sudha" <sudha@discussions.microsoft.com> wrote in
message
>> news:9B912EFE-BF61-4C57-B7A1-
2F35F430B5D7@microsoft.com...
>> > Hi Hilary,
>> > I appreciate your reply. Yes it says "SQL Server
Agent on "servername"
>> uses
>> > System Account,which causes replication between
servers to fail.
>> > You suggested me to change,sql service account ,how
do i change it and do
>> i
>> > need to stop and start the server after i make a
change?
>> >
>> > I will be thankful if i can get this answer.
>> >
>> > Sudha
>> >
>> > "Hilary Cotter" wrote:
>> >
>> > > Does it say "Local System" or "sa" I have never
heard of it having a
>> problem
>> > > with the sa account but I have when it uses the
local system account.
>> Can
>> > > you ensure that your SQL Server service account is
running under a
>> domain
>> > > account? Make this change through enterprise
manager.
>> > > --
>> > > Hilary Cotter
>> > > Looking for a SQL Server replication book?
>> > > http://www.nwsu.com/0974973602.html
>> > >
>> > > Looking for a FAQ on Indexing Services/SQL FTS
>> > > http://www.indexserverfaq.com
>> > >
>> > > "sudha" <sudha@discussions.microsoft.com> wrote in
message
>> > > news:9DA7173A-C32D-4953-9453-
8AEE0656F752@microsoft.com...
>> > > > Hi all,
>> > > >
>> > > > I am trying to publish data making the same
server as Distributor
>> while
>> > > > using the wizard it says i am using "sa"
account and the server
>> cannot be
>> > > > used as a distributor if i use "sa" account,how
do i go around this?
>> do i
>> > > > need to stop the server and start with a
different account? and setup
>> > > server
>> > > > agent to use other account ?
>> > > >
>> > > > Can anyone clear my doubts?
>> > > >
>> > > > Thanks
>> > > > Sudha
>> > >
>> > >
>> > >
>>
>>
>>
>.
>
- Next message: Fatiya: "Re: Replication does not work properly"
- Previous message: Paul Ibison: "Re: how to configure one-way merge replication?"
- In reply to: sudha: "Re: Publishing data while using same server as distributor"
- Next in thread: sudha: "Re: Publishing data while using same server as distributor"
- Reply: sudha: "Re: Publishing data while using same server as distributor"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
