Replication Errors

I have three questions?
1. I have a Sql server instance running without any name, it just has a
default name (local), when i try to go configure replication its says that
replication does not support (local) name. This server is in production
right now. And it will be hard to shut it down. Is there anyway to change
the name of the instance? Even if i unregister and re-register a new
server, will all my databses and plans, etc. will be the exact same as on
the last instance? Whats the best possible way can i configure replication
on this instance?
2. I was subscribed to a couple push subscriptions replication from a
different server, but that server no longer exists, but my server still goes
out and looks for the subscription, I tried to remove the subscription, but
i get the same errror like on the question one, "replication does not
support (local) name." so i can't remove the subscription. What can i do to
remove this subscriptions?
3. When i try to configure the Replication, its says that Server Agent uses
the local service account you need to change the account? Whats the Local
service account? Can two services not use the same local service account?
How do i need to set this up, to use the account? Do i need to create
another account?
Thanks for all your help.
Hi Shash Goyal,
Most of your problems relate to having registered your server as "(local)"
in Enterprise Manager. Try reregistering it as the name of your computer
instead. I think that will fix problems 1 and 2. With the 3rd one, all it's
trying to tell you is that if you want to connect to anything outside your
computer, you normally need a domain user account. The "Local Service"
account is a special account on your computer that only applies to that
computer. Try creating a new user that will be used only as a service
account (ie something like "sqlservice" for a name). Make it a domain user
if you are in a domain. Give it appropriate permissions and change SQL
Server and SQL Agent to run as that user (you can do this by right-clicking
each in Enterprise Manager) and choosing the "Security" option.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Shash Goyal" <Shash703@.gmail.com> wrote in message
news:%23j6aiu5vEHA.3080@.TK2MSFTNGP12.phx.gbl...
>I have three questions?
> 1. I have a Sql server instance running without any name, it just has a
> default name (local), when i try to go configure replication its says that
> replication does not support (local) name. This server is in production
> right now. And it will be hard to shut it down. Is there anyway to change
> the name of the instance? Even if i unregister and re-register a new
> server, will all my databses and plans, etc. will be the exact same as on
> the last instance? Whats the best possible way can i configure
> replication
> on this instance?
>
> 2. I was subscribed to a couple push subscriptions replication from a
> different server, but that server no longer exists, but my server still
> goes
> out and looks for the subscription, I tried to remove the subscription,
> but
> i get the same errror like on the question one, "replication does not
> support (local) name." so i can't remove the subscription. What can i do
> to
> remove this subscriptions?
> 3. When i try to configure the Replication, its says that Server Agent
> uses
> the local service account you need to change the account? Whats the Local
> service account? Can two services not use the same local service account?
> How do i need to set this up, to use the account? Do i need to create
> another account?
>
> Thanks for all your help.
>