October 18, 2007 at 7:56 pm
Guys i just want to ask something but before i start asking just let me share the scenario for a moment....
i have a server which i want to create a replicate but when doing so it returns an error something like this "SQL Server doesnt support nickname blah blah blah..." the main reason is that the sql server registration name is "local" and the only thing to do ( so far the only thing i know) is to delete the server registration and create it again.. this is easy if it is only remote in this server but the thing is the sql server registration is local to the server. My questions are:
1. If i delete the sql server registration (with name local) my databases,sp,schedules etc.. will be lost also right??
2. how can i rebuild them again?? since this is not a sql server registration from another server but a local server?
3. is there any way (other than deleting the sql server registration) to edit the sql server registration name? because it is the only problem when it come to building the replication (in my case).
"-=Still Learning=-"
Lester Policarpio
October 18, 2007 at 9:39 pm
Deleting the server registration has absolutely no affect on the server. It is only removing it from the list of server that Enterprise Manager shows you.
For replication, you need to register the server to Enterprise Manager using its name (the name of the server instead of the nickname "Local" which is the default if you are connecting to the default instance on the server you are logged into).
The reason for this is that the list of servers that the replication wizards use are based on the servers that are registered to Enterprise Manager. Local is not acceptable as a server name to replication when it is up and running since, depending on your context, any of the servers in your replication topology may be "Local" depending on where you are.
October 19, 2007 at 1:16 am
Yeah right thanks happycat im just double checking if i there is no connections or problems in deleting sql server registration names thankss...
"-=Still Learning=-"
Lester Policarpio
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply