常見問題 登入
搜尋 個人資料
會員列表 會員群組
登入檢查您的私人訊息
會員註冊
Error Message 14114: "null" 並未設定為散發者
發表新主題   回覆主題
UnixCafe 首頁 » MS SQL » Error Message 14114: "null" 並未設定為散發者
上一篇主題 :: 下一篇主題  
發表人 內容
juan
Site Admin


註冊時間: 2004-03-31
文章: 54
來自: Taiwan

 發表 發表於: 星期四 四月 08, 2004 10:25 am    文章主題: Error Message 14114: "null" 並未設定為散發者
引言回覆

PRB: Error Message 14114: "(NULL) is not configured as a distributor"

The information in this article applies to:
Microsoft SQL Server 2000 (all editions)

This article was previously published under Q302223

SYMPTOMS
When you try to set up a SQL Server server as a distributor for replication, the following error message may occur:

Error 14114:(NULL) is not configured as a distributor

CAUSE
The error message appears because there is not an entry for the local server in the sysservers table in the master database.

To verify that there is no entry for the local server in the sysservers table in the master database, connect to the local server and run "select @@servername" from Query Analyzer. If a (NULL) is returned, then an entry for the local server does not exist in the sysservers table in the master database.

WORKAROUND
To correct the problem, use these steps:
Run this code:

use master
go
select * from sysservers
go
Identify the name of the local server in the list. If the name exists, and the server id is anything other than 0, run the following statement and replace "yourservername" with the name of the local server:

sp_dropserver 'yourservername','droplogins'
If a non-local server has a server id value of 0, then you need to drop that entry and run the sp_dropserver stored procedure.


Add the local server back to the list by running this code:

sp_addserver 'localservername', 'local'

You must stop and then restart the SQL Server server for the changes to take effect. After the server has been restarted, run "select @@servername" to verify that the changes have been applied. Executing "select @@servername", should return the name of your local server with a server id of 0.

REFERENCES
SQL Server 2000 Books Online; topic: "Renaming Servers"

_________________
This is Juan (http://juan.idv.tw)
I'd like to be a teardrop,
To be born in your eye,
To live my life on your cheek,
And on your lips to die.
 回頂端 »
檢視會員個人資料 發送私人訊息 參觀發表人的個人網站 雅虎訊息通 MSN Messenger ICQ 號碼
從之前的文章開始顯示:   
UnixCafe 首頁 » MS SQL » Error Message 14114: "null" 並未設定為散發者
發表新主題   回覆主題 所有的時間均為 台北時間 (GMT + 8 小時)
1頁(共1頁)

 
前往:  
無法 在這個版面發表文章
無法 在這個版面回覆文章
無法 在這個版面編輯文章
無法 在這個版面刪除文章
無法 在這個版面進行投票
You cannot attach files in this forum
You can download files in this forum




Solaris phpBB theme/template by Jakob Persson
Copyright © Jakob Persson 2003



Powered by phpBB 2.0.11 © 2001, 2002 phpBB Group
正體中文語系由 phpbb-tw 維護製作