2a:I[36659,["/_next/static/chunks/db81714fcc2637ae.js","/_next/static/chunks/5a20416657f93342.js","/_next/static/chunks/ea63446d7a289bb1.js","/_next/static/chunks/a4df8fc19a9a82e6.js","/_next/static/chunks/962842257c5ad6ea.js","/_next/static/chunks/12e3badc47343568.js"],"PixCategory"] :HL["/logo_pixnet_ch.svg","image"] 15:["$","div",null,{"className":"article-content-inner","id":"article-content-inner","suppressHydrationWarning":true,"dangerouslySetInnerHTML":{"__html":"

解決電腦名稱改變導致無法作複寫。
錯誤訊息:
SQL Server 無法連接到伺服器 'NewServerName'。
其他資訊:
SQL Server 複寫需要有實際的伺服器名稱才能連接到伺服器。
不支援透過伺服器別名、IP 位址或任何其他替代名稱來進行連接。
請指定實際的伺服器名稱,'OldServerName'。 (Replication.Utilities)

SELECT @@SERVERNAME, SERVERPROPERTY('ServerName')
Select @@ServerName
OldServerName

sp_DropServer 'OldServerName'
sp_AddServer 'NewServerName','Local'

SQL Server restart

Select @@ServerName
NewServerName

"}}] 16:["$","div",null,{"className":"tag-container-parent","children":[["$","div",null,{"className":"tag-container article-keyword","data-version":"a","children":[["$","div",null,{"className":"tag__header","children":["$","div",null,{"className":"tag__header-title","children":"文章標籤"}]}],["$","div",null,{"className":"tag__main","id":"article-footer-tags","children":[]}]]}],["$","div",null,{"className":"tag-container global-keyword","children":[["$","div",null,{"className":"tag__header","children":["$","div",null,{"className":"tag__header-title","children":"全站熱搜"}]}],["$","div",null,{"className":"tag__main","children":[]}]]}]]}] 17:["$","div",null,{"className":"author-profile","children":[["$","div",null,{"className":"author-profile__header","children":"創作者介紹"}],["$","div",null,{"className":"author-profile__main","id":"mixpanel-author-box","children":[["$","a",null,{"children":["$","img",null,{"className":"author-profile__avatar","src":"https://pimg.1px.tw/flyfox/logo/flyfox.png","alt":"創作者 flyfox 的頭像","loading":"lazy"}]}],["$","div",null,{"className":"author-profile__content","children":[["$","a",null,{"className":"author-profile__name","children":"flyfox"}],["$","p",null,{"className":"author-profile__info","children":"flyfox"}]]}],["$","div",null,{"className":"author-profile__subscribe hoverable","children":["$","button",null,{"data-follow-state":"關注","className":"subscribe-btn member"}]}]]}]]}] 18:["$","p",null,{"className":"author","children":["flyfox"," 發表在"," ",["$","a",null,{"href":"https://www.pixnet.net","children":"痞客邦"}]," ",["$","a",null,{"href":"#comments","children":"留言"}],"(","0",")"," ",["$","span",null,{"className":"author-views","children":["人氣(",["$","span",null,{"id":"BlogArticleCount-223677942","children":"322"}],")"]}]]}] 19:["$","div",null,{"id":"pixnet-ad-content-left-right-wrapper","children":[["$","div",null,{"className":"left"}],["$","div",null,{"className":"right"}]]}] 1a:["$","div",null,{"className":"article-footer","children":[["$","ul",null,{"className":"refer","children":[["$","li",null,{"children":["全站分類：",["$","a",null,{"href":"#","children":"$undefined"}]]}]," ",["$","li",null,{"children":["個人分類：",["$","a",null,{"href":"#","children":"M"}]]}]," "]}],["$","div",null,{"className":"back-to-top","children":["$","a",null,{"href":"#top","title":"back to the top of the page","children":"▲top"}]}]]}]

flyfox

flyfox's blog

SQL Server 2008 Replication

自訂側欄

最新文章

最新留言

留言板

個人資訊

文章精選

文章分類

Linux (4)

BSD (1)

Windows (2)

VM (3)

Program (3)

參觀人氣