I suspect that all you have to do is re-register the server with
Enterprise Manager. If you right-click the server in EM, the registration
probably just says "local" or "localhost". Change that to the actual
server name instead and try again. You don't have to uninstall and
reinstall the software, just change how you connect to the server.
"Phillip B" <[EMAIL PROTECTED]>
08/11/2003 02:04 PM
Please respond to sql
To: SQL <[EMAIL PROTECTED]>
cc:
Subject: Re: Any SQL 2000 gurus?
This is a hard problem to describe since I have never come across it
before.
I use database replication to publish data from one database to another.
So,
since I am moving to a new sql server, I have to set up the database for
publishing to its subscribers. When I open Enterprise manager and choose
"Tools, Replication, Create and Manage Publications" I get the error I
mentioned before.
In Enterprise Manager under SQL Server Group it lists the SQL server as
"(Loacl) (Windows NT)". I am assuming, based on the error message, that
the
server cant be named that and that I need to change the name. So how do I
do
this with as little work as possible?
Phillip B.
www.LoungeRoyale.com
www.FillWorks.com
----- Original Message -----
From: "Alex Puritche" <[EMAIL PROTECTED]>
> Phillip,
>
> honestly i didn't 100% understand your problem
> but i make me think that if you'll use server name it should
> work for you. you can find server name by right clicking on
> the "My computer" icon
>
>
> Monday, August 11, 2003, 6:33:14 PM, you wrote:
>
> Phillip> I had a new sql 2000 server set up. I am now migrating from the
old server
> Phillip> to the new one. I am to the stage where I am setting up
replication on the
> Phillip> new server and I'm having a problem. They named the server as
local which
> Phillip> gives me an error when I try to setup replication.
>
> Phillip> "SQL Server does not support nicknames, such as "." or
"(local)",
as a
> Phillip> server names. Delete the SQL Server registration for this
server
and
> Phillip> register it using the actual server name."
>
> Phillip> Do I have to actually delete it or can I rename it? I really
don't want to
> Phillip> have to set the sql server up a second time.
>
> Phillip> Much thanks
>
> Phillip> Phillip B.
>
> Phillip> www.LoungeRoyale.com
> Phillip> www.FillWorks.com
>
> Phillip>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6
Get the mailserver that powers this list at
http://www.coolfusion.com
