Converting Default Instance To A Named Instance (SQL Server 2000)

I have a server running SQL Server 2000 that now has to be configured as a publisher for replication. The issue is that it won't allow a default instance to be a publisher, it must be a named instance. How can I easily convert the default instance, in place with all of the databases intact, to a named instance?
Who is Participating?
Kevin3NFConnect With a Mentor Commented:
What won't allow it?  A default instance of SQL Standard or Enterprise can certainly be a publisher.  Is this a requriement of your application?
rboyd56Connect With a Mentor Commented:
You cannot convert a default instance to a named instance. You will have to un-install and re-install SQL Server to do that. As kevin3nf indicated a default instance can be a publisher.
HavaganAuthor Commented:
I was posting this question second hand for a new DBA. On my local test server I was able to easily set up a default instance as a publisher. The error he was receiving was "Error 14114: '(null)' is not configured as a Distributor" when using the Publishing wizard.

There is a KB article for this error related to this error.

I asked the wrong question, but you both gave me useful information related to the question I did ask, so I'll split the points.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.