Error 18483 Distributor_admin Is Not Defined
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related sp_addremotelogin threads Remove From My Forums Answered by: distributor
Sp_dropserver
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 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 |
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 community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6ec434b1-30ee-472f-93f6-894438c212fb/distributor-admin-is-not-defined-as-remote-login?forum=sqlreplication 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 http://dba.stackexchange.com/questions/6845/sql-server-error-18483-when-setting-up-sql-distribution 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 g
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73263 to create new threads on these forums. SQL Server Forums Profile | ActiveTopics http://forums.databasejournal.com/showthread.php?20199-Error-18483-%22Distributor_Admin%22-is-not-defined | 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) How can i create distributor_admin account Reply to Topic Printer Friendly Author Topic kmhsad Starting Member Myanmar (Burma) 1 Posts Posted-10/10/2006: 00:17:44 error 18483 Hello , Please help me. I am new for this forum.Now,i meet with one problem.I use SQL server 2000 desktop edition and window XP professional.I want to make replication with another server,But , when i configure publishing and distribution , one error arise that is "Error 18483:could not connect to server 'SVR' because 'distributor_admin' is not defined as a remote login at the server"How can i error 18483 distributor_admin define distributor_admin account as remote login at my server....Please help me ... eyechart Flowing Fount of Yak Knowledge USA 3575 Posts Posted-10/10/2006: 01:14:35 have a look at this KB articlehttp://support.microsoft.com/kb/818334/en-us-ec Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database Design and Application Architecture SQL Server 2012 Forums Transact-SQL (2012) SQL Server Administration (2012) SSIS and Import/Export (2012) Analysis Server and Reporting Services (2012) Replication (2012) Availability Groups and DR (2012) Other SQL Server 2012 Topics SQL Server 2008 Forums Transact-SQL (2008) SQL Server Administration (2008) SSIS and Import/Export (2008) High Availability (2008) Replication (2008) Analysis Server and Reporting Services (2008) Other SQL Server 2008 Topics SQL Server 2005 Forums Transact-SQL (2005) SQL Server Administration (2005) .NET Inside SQL Server (2005) SSIS and Import/Export (2005) Service Broker (2005) Replication (2005) High Availability (2005) Analysis Server and Reporting Services (2005) Express Edition and Compact Edition (2005) Other SQL Server Topics (2005) SQL Server 2000 Forums SQL Server Development (2000) SQL Server Administration (2000) Import/Export (DTS) and Replication (2000) Transact-SQL (2000) Analysis Services (2000) MSDE (2000) Development Tools ASP.NET Repor
New? Advanced Search Forum Database Discussions MS SQL Server 7/MS SQL Server 2000 Error 18483 "Distributor_Admin" is not defined If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 1 of 1 Thread: Error 18483 "Distributor_Admin" is not defined Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 11-22-1999,05:14 PM #1 Tom Bartos Guest Error 18483 "Distributor_Admin" is not defined I am attempting to setup Replication on a SQLServer 7.0 Standard Edition. Unfortunately there is an error while using the Configure Publishing and Distribution Wizard. Error 18483: Could not connect tot he server 'server_name' because 'distributor_admin' is not defined as a remote login at the server. Remote logins for remote server 'repl_distributor' have been dropped Server dropped. Server added. Server network name set. Any Good Ideas? Thanks- -tom Reply With Quote Quick Navigation MS SQL Server 7/MS SQL Server 2000 Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Database Discussions IBM DB2 Informix Microsoft Access Microsoft SQL Server 2008 Microsoft SQL Server 2005 MDX and Analysis Services Reporting Services MS SQL Server 7/MS SQL Server 2000 MySQL Oracle PostgreSQL Sybase Miscellaneous General Database Discussions Ask an Expert Database Design Database Programming Database News and Announcements Structured Query Language (SQL) SQL Scripts Database Lounge Feedback Related Sites SQL Course SqlCredit « Previous Thread | Next Thread » Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off [VIDEO] code is Off HTML code is Off Forum Rules -- New Theme -- Default Mobile Style Contact Us Database Journal Forums Top All times are GMT -5. The time now is 09:54 AM.