Error 18483 Distributor_admin Is Not
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: distributor admin is not defined as remote sp_addremotelogin login SQL Server > SQL Server Replication Question 0 Sign in
Sp_dropserver
to vote Hi All, when i try to configure replication on my server it raises an error no(18483 ) with error report as 'distributor admin is not defined as remote lo gin ' .please suggest me on this to resolve this problem Thanks venkat reddy Tuesday, December 22, 2009 6:49 AM Reply | Quote Answers 0 Sign in to vote Hello,Check if Select @@Servername is same as host name.If not use the sp_dropserver, sp_addserver accordingly.Else,Check if distributor_admin is available & has permissions.Thanks,Krishnawww.sqlserver.in http://blogs.sqlserver.in Marked as answer by Venkat Reddy BashiReddy Tuesday, December 22, 2009 11:28 AM Tuesday, December 22, 2009 7:21 AM Reply | Quote All replies 0 Sign in to vote Hello,Check if Select @@Servername is same as host name.If not use the sp_dropserver, sp_addserver accordingly.Else,Check if distributor_admin is available & has permissions.Thanks,Krishnawww.sqlserver.in http://blogs.sqlserver.in Marked as answer by Venkat Reddy BashiReddy Tuesday, December 22, 2009 11:28 AM Tuesday, December 22, 2009 7:21 AM Reply | Quote 0 Sign in to vote HiFollow the below KB Article.http://support.microsoft.com/kb/818334Thanks,Ramakrishna Tuesday, December 22, 2009 7:40 AM Reply | Quote 0 Sign in to vote http://social.msdn.microsoft.com/forums/en-US/sqlreplication/thread/96bc7f2c-ba76-413d-aef3-ed9a3939129d/Thanks,Krishnawww.sqlserver.in http://blogs.sqlserver.in Tuesday, December 22, 2009 8:24 AM Reply | Quote 0 Sign in to vote Thanks, I already tested @@SERVERNAME is showing different name ,but the server is exist as replicate distributor when i used sp_helpserver stored procedure. Tuesday, December 22, 2009 11:30 AM Reply | Quote 0 Sign in to vote Did you restart the server after dropping it? The correct sequence is use master GO sp_DropServer @@ServerName GO use master GO sp_addserver 'NewName', 'local' GO Where newname is what is returned from typing hostname at the command prompt and th
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » Replication » configure publishing and distribution wizard... configure publishing and distribution wizard error Error 18483: could not connect to server because ''distributor_admin'' is not defined as a remote login at... Rate Topic Display Mode Topic Options Author Message adam spenceradam spencer Posted Wednesday, May 4, 2005 6:42 PM SSC Veteran Group: General Forum Members Last Login: Tuesday, September 23, 2014 4:16 PM Points: 224, Visits: 304 I https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6ec434b1-30ee-472f-93f6-894438c212fb/distributor-admin-is-not-defined-as-remote-login?forum=sqlreplication am trying to configure replication on my box, I am not conected to a network yet. the last screen of the 'configure publishing and distribution' wizard titled 'completing the configure publishing and distribution' , I click finish and get the following error message:SQL server EM could not configure 'Sp190' as the distributor for 'Sp190'.Error 18483: could not connect to server because 'distributor_admin' is not defined as a http://www.sqlservercentral.com/Forums/Topic180059-7-1.aspx remote login at the server.I am new at this, what do I need to do here???thank you very much!! Post #180059 Site OwnersSite Owners Posted Monday, May 9, 2005 8:00 AM SSChampion Group: General Forum Members Last Login: Friday, May 18, 2007 3:36 PM Points: 10,041, Visits: 1 No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have! Post #180832 goinggoing Posted Wednesday, May 11, 2005 4:19 AM Forum Newbie Group: General Forum Members Last Login: Wednesday, May 11, 2005 8:15 AM Points: 2, Visits: 1 i am also met the same problem,so i want to know how to discussion. Post #181346 goinggoing Posted Wednesday, May 11, 2005 4:52 AM Forum Newbie Group: General Forum Members Last Login: Wednesday, May 11, 2005 8:15 AM Points: 2, Visits: 1 WORKAROUNDTo work around this problem, replace the SQL Server 2000 server name with the correct network name of the computer. To do so, follow these steps: 1.Log on to the computer where you deployed SQL Server 2000 from the disk image, and then run the following Transact-SQL statement in SQL Query Analyzer:
-- Usefor Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to https://www.experts-exchange.com/questions/21585274/SQL-server-Replication-distributor-admin.html Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > SQL server Replication - distributor_admin Want to Advertise http://microsoft.public.sqlserver.replication.narkive.com/n1BA16WA/error-18483-distributor-admin Here? Solved SQL server Replication - distributor_admin Posted on 2005-10-05 MS SQL Server 1 Verified Solution 5 Comments 3,924 Views Last Modified: 2008-05-28 Hi I am trying to setup replication in SQL server 2000. error 18483 1. selected distributor 2. Configure the sql server agent service to start automatically 3. specified snapshot folder on a shared drive 4. Customized the distribution database 5. Gave database name and folder path for the db and log 6. Enabled server to use the distributor 7. Enable publication database 8. Did not select subscribers When the wizard is completed and the setup runs, it breaks at 'Configuring Distributor' i get error 18483 distributor_admin the following issue. SQL Server Enterprice Manager could not configure [server name] as the Distributor for 'server name' Error 18483: Could not connect to server 'xxxxxxxx' because 'distributor_admin' is not defined as a remote login at the server. Help is appreciated. 0 Question by:sansoftura Facebook Twitter LinkedIn Google Best Solution bymaxomedia You need to run sp_dropserver first, then go for sp_addserver. No worries, it does not delete your database. Do you have Publication and Distribution on the same server ? If you do, and you have Go to Solution 4 Comments Message Expert Comment by:maxomedia2005-10-07 Hello Check to make sure SELECT @@SERVERNAME returns correct servername. If not then you will need to run sp_dropserver
and sp_addserver , local. Quite a helpful article on this topic is that one http://support.microsoft.com/default.aspx?scid=kb;en-us;321822 Cheers, Toby 0 LVL 6 Overall: Level 6 MS SQL Server 1 Message Author Comment by:sansoftura2005-10-10 I went through the article and chenge the alias name for the SQL server. That did not fix the problem. Also i trided creating a 'distributor_admin' and gave full access to the DB. It still fails I get the error SQL Server Enterprise Manager could not configure [server name] as the Distributor for '[server name] ' Error 18483: greeted by this message:SQL Server Enterprise Manager could not configure 'SERVERNAME' as theDistributor for 'SERVERNAME'.Error 18483: Could not connect to server 'SERVERNAME' because'distributor_admin' is not defined as a remote login at the server.The MS articles did not help me. Can someone, please?--Wack----This message will self destruct. Hilary Cotter 2005-03-10 20:02:10 UTC PermalinkRaw Message try to drop the server and then recreate itsp_dropserver @@servernameGOsp_addserver @@servername, 'local'GO--Hilary CotterLooking for a SQL Server replication book?http://www.nwsu.com/0974973602.htmlLooking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.comPost by Ray LewisI'm trying to publish a database and when I get to the end of the wizard, ISQL Server Enterprise Manager could not configure 'SERVERNAME' as theDistributor for 'SERVERNAME'.Error 18483: Could not connect to server 'SERVERNAME' because'distributor_admin' is not defined as a remote login at the server.The MS articles did not help me. Can someone, please?--Wack----This message will self destruct. Ray Lewis 2005-03-14 13:15:56 UTC PermalinkRaw Message I tried this, and used MS article 818334. I found that the SQL Server Namewas not the same as the Computer Name. However, when I try and drop the SQLserver name, I get a message stating that the SQL server does not exist.So, I cannot rename my SQL Server 2000 server. What now?--Wack----This message will self destruct.Post by Hilary Cottertry to drop the server and then recreate itGOGO--Hilary CotterLooking for a SQL Server replication book?http://www.nwsu.com/0974973602.htmlLooking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.comPost by Ray LewisI'm trying to publish a database and when I get to the end of thewizard,Post by Hilary CotterIPost by Ray LewisSQL Server Enterprise Manager could not configure 'SERVERNAME' as theDistributor for 'SERVERNAME'.Error 18483: Could not connect to server 'SERVERNAME' because'distributor_admin' is not defined as a remote login at the server.The MS articles did not help me. Can someone, please?--Wack----This messa