Error 18483 Distributor_admin
Contents |
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
Sp_addremotelogin
the company Business Learn more about hiring developers or posting ads with us Database Administrators sp_dropserver 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 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 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 @@SERVERNAME, SERVERPROPERTY('ServerName') This returns: VMSSERV VIPER Most of my web searches show that I should refer to http://support.microsoft.com/kb/818334, which instructs to use: -- Use the Master database USE master GO -- Declare local variables DECLARE @serverproperty_servername varchar(100), @servername varchar(100) -- Get the value returned by the SERVERPROPERTY system function SELECT @serverproperty_servername = CONVERT(varchar(100), SERVERPROPERTY('ServerName')) -- Get the value returned by @@SERVERNAME global variable SELECT @servername = CONVERT(varchar(100), @@SERVERNAME) -- Drop the server with inc
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) 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 > SQL Server Replication Question 0 Sign in to vote Hi All, when i try to configure replication on my server it http://dba.stackexchange.com/questions/6845/sql-server-error-18483-when-setting-up-sql-distribution 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 https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6ec434b1-30ee-472f-93f6-894438c212fb/distributor-admin-is-not-defined-as-remote-login?forum=sqlreplication 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.sql
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 http://microsoft.public.sqlserver.replication.narkive.com/n1BA16WA/error-18483-distributor-admin 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 http://www.verycomputer.com/156_b2ec6485377920ff_1.htm 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 error 18483 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. error 18483 distributor_admin 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 message will self destruct. benno2004 2005-03-17 09:20:16 UTC PermalinkRaw Message Hi,is the login used to configure the publication a member of the 'systemadministrators'? I had a similar problem when creating a pullsubscription and this solved it!Bruno*I'm trying to publish a database and when I get to the end of thewi
out how to set distributor_admin as remote login user. Since the EM does not allow me to delete the publication from one of my 3 SQL servers. Thanks in advance, Sergei Rassk Top Error 18483 distributor_admin is not defined as remote server by Jun Chen[M » Fri, 16 Nov 2001 14:28:42 Hello, In Enterprise Manager, you can go to servername->security->remote servers , right click on the remoteservername->properties and change the remote login information. Regards, Jun Chen This posting is provided "AS IS" with no warranties, and confers no rights. Top Error 18483 distributor_admin is not defined as remote server by Sergei Rass » Sat, 17 Nov 2001 03:31:12 Hi Jun Chen, Thanks a lot. It's solved almost all of my replication problem. Best Regards Sergei *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Top 1. Error 18483 distributor_admin is not defined as remote server HI, I have alredy look't at every thing I could find on the web about this but I cant get this to work this is the error I get "Error 18483 distributor_admin is not defined as remote server" dose any one know of a how to about setting up replication between servers -- Posted via dBforums http://dbforums.com 2. SqlServer Crosstab / flattening a table 3. replication error 18483(distributor_admin) 4. Clipper 5.2 INFO WANTED] 5. Distributor_admin is not defined as a remote login at the server 6. Powerbuilder Connections to Informix 7. distributor_admin not defined as remote login 8. Processes 9. "Error 18483: Could not connect to server... 10. Error 18483 Could not Connect to Server 11. Help -- Error 18483: Could not connect to the server 12. ???define 'distributor_admin' as a remote login 3 post • Page:1 of 1 All times are UTC Board index Spam Report