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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
