Error 18483 Could Not Connect Server Because Distributor_admin Not Defined
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 login SQL Server sp_addremotelogin > SQL Server Replication Question 0 Sign in to vote Hi All,
Sp_dropserver
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 then adding a \ and the instance name after it. You will need to restart sql server to
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6ec434b1-30ee-472f-93f6-894438c212fb/distributor-admin-is-not-defined-as-remote-login?forum=sqlreplication community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top SQL Server Error 18483 - When Setting Up SQL Distribution up vote 2 down vote favorite I'm trying to synchronize a couple tables in one SQL Server 2000 http://dba.stackexchange.com/questions/6845/sql-server-error-18483-when-setting-up-sql-distribution database into another SQL Server 2005 database using replication. When I am attempting to set up my SQL Server as a distributor, I'm getting the following error: SQL Server Enterprise Manager could not configure 'VIPER' as the Distributor for 'VIPER' . Error 18483: Could not connect to server 'VIPER' because 'distributor_admin' is not defined as a remote login at the server. In doing research, I found several sources and articles that show that my machine name, and the actual name of the server are not the same. When I check the sysservers view in master, I see that: 0 1089 VMSSERV SQL Server SQLOLEDB VMSSERV 4/23/2008 9:50:41 AM 1 1601 repl_distributor SQL Server SQLOLEDB VIPER 10/12/2011 1:23:18 PM 2 1184 CHARLIE SQL Server SQLOLEDB CHARLIE 2/18/2011 1:32:14 PM The first line is the original database that was setup, and that I intend on using. You can see (kinda) that the original name is VMSSERV and the actual machine name is VIPER. So, from the results of my extensive web search, I ran this in Query Analyzer: USE MASTER GO SELECT @@SER
SQL Server experts to answer whatever question you can come up with. Our new SQL http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=19639 Server Forums are live! Come on over! We've restricted the ability to https://www.experts-exchange.com/questions/21585274/SQL-server-Replication-distributor-admin.html create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2000 Forums Import/Export (DTS) and Replication (2000) Error 18483 error 18483 while configuring distributor Reply to Topic Printer Friendly Author Topic dontipton Starting Member USA 8 Posts Posted-09/09/2002: 11:28:22 While configuring my distributor I received the following error:Error 18483: Could not connect to server because "distributor_admin" is not defined as a remote login at the server.Anyone have any ideas? dtipton@state.oh.us chadmat The Chadinator USA 1974 Posts error 18483 could Posted-09/09/2002: 16:25:00 Is your server registered as an IP address? If so, register it as the servername instead, then try again.If that doesn't do it, select @@servername and make sure it matches the netbios name.-Chad mko Starting Member 2 Posts Posted-04/02/2003: 17:26:18 I have the same problem. What do you mean that the servername should match the netbios name? tkizer Almighty SQL Goddess USA 38200 Posts Posted-04/02/2003: 18:05:44 Sort of a double post:(Edit Removed the link to post info)This article explains NetBIOS:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnntpro00/html/NetBIOS.aspFor the most part, the NetBIOS name of the server is actually the real name of the server. Chadmat was just saying not to use the IP address as the name, but instead use the NetBIOS name.Tara garyn Starting Member USA 5 Posts Posted-11/17/2011: 18:43:16 I encountered this error after someone had left unfinished a failed attempt to setup ServerA as Publisher using the existing Distributor on ServerB. When I tried to run SQL2000 E/M's "Configure Publishing and Distri
for 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 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 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. 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 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