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.
See inline
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Shash Goyal" <Shash703@.gmail.com> wrote in message
news:eiVPxa7vEHA.824@.TK2MSFTNGP11.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?
>
Every server has a name, the default name is the same as the name of the NT
server on which SQL runs... YOu simply have SQL registered in you SEM unding
(local) instead of the server name... Get the real servername, Un-register
it in SEM , then register it with the real name...
> 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?
Re-register the server, and take a look at the sp_dropsubscription
> 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?
> Set up a domain account for SQL Server. Add the domain account to each of
your SQL Servers as a SQL administrator. In SEM, go to SQL Agent and right
click and go to properties. I think the second tab is where you put the
login password ( instead of system checkbox.) Stop and re-start SQL Agent
and you should be good.
> Thanks for all your help.
>