Publishing data while using same server as distributor

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
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
|||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...
> server
>
>
|||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[vbcol=seagreen]
> 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:
problem[vbcol=seagreen]
Can[vbcol=seagreen]
domain[vbcol=seagreen]
while[vbcol=seagreen]
cannot be[vbcol=seagreen]
do i[vbcol=seagreen]
|||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...
> uses
> i
> problem
> Can
> domain
> while
> cannot be
> do i
>
>
|||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[vbcol=seagreen]
>it? and what do i do with it?
>thanks
>sudha
>"Hilary Cotter" wrote:
security tab and its at[vbcol=seagreen]
message[vbcol=seagreen]
2F35F430B5D7@.microsoft.com...[vbcol=seagreen]
Agent on "servername"[vbcol=seagreen]
servers to fail.[vbcol=seagreen]
do i change it and do[vbcol=seagreen]
change?[vbcol=seagreen]
heard of it having a[vbcol=seagreen]
local system account.[vbcol=seagreen]
running under a[vbcol=seagreen]
manager.[vbcol=seagreen]
message[vbcol=seagreen]
8AEE0656F752@.microsoft.com...[vbcol=seagreen]
server as Distributor[vbcol=seagreen]
account and the server[vbcol=seagreen]
do i go around this?[vbcol=seagreen]
different account? and setup
>.
>
|||Thanks Paul,
I will try out the things which you have suggested and let you know if i am
fine.
Great to know how things get fixed and from which places.The more we try to
dig the more we are ignorant.Thanks for giving me the information.
Sudha
"Paul Ibison" wrote:

> 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)
>
>
> Security Tab of database
> frame is disabled,why is
> security tab and its at
> message
> 2F35F430B5D7@.microsoft.com...
> Agent on "servername"
> servers to fail.
> do i change it and do
> change?
> heard of it having a
> local system account.
> running under a
> manager.
> message
> 8AEE0656F752@.microsoft.com...
> server as Distributor
> account and the server
> do i go around this?
> different account? and setup
>