Error 18483
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 the company Business
Sql 2000 Error 18483
Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users error 18483 distributor_admin Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their
Mssql Error 18483
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 error 18483 distributor admin 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 error 14114 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 incorrect name EXEC sp_dropserver @server=@servername -- Add the correct server as a local server EXEC sp_addserver @server=@serverpropert
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 to create new threads on
Sp_addremotelogin
these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ sp_dropserver 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 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: http://dba.stackexchange.com/questions/6845/sql-server-error-18483-when-setting-up-sql-distribution 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 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 http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=19639 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 Distribution" wizard on ServerA, I got this error. SSMS has separate wizards for Configuring Publishing vs Configuring Distribution, and one of those offered to drop a hidden existing (broken) Publisher partially-defined in metadata on ServerA. The wizard executed sp_dropdistributor @no_checks = 1, @ignore_distributor = 1, and the error 18483 was resolved for all client tools. I surmise a wizard had neglected in the past to create and coordinate the distributor_admin accounts & passwords between ServerA and ServerB; I never found that account on either, and it is apparently required if Publisher and Distribu
18483) http://www.sql-server-performance.com/forum/threads/replication-error-18483.6337/ Discussion in 'General DBA Questions' started by boam5, Sep 30, 2005. boam5 New Member when configuring publisher and distributor i've got http://www.verycomputer.com/156_2cfa313ca08b011b_1.htm this error : "error 18483 : could not connect to server g4b because 'distributor_admin' si not defined as a remote error 18483 login at the server" please help me..thx boam5, Sep 30, 2005 #2 dineshasanka Moderator Check These http://support.microsoft.com/default.aspx?scid=kb;en-us;321822 http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=7&messageid=220975 ---------------------------------------- Cast your vote http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka dineshasanka, Sep 30, 2005 #2 boam5 New Member ok thx a lot. boam5, Sep 30, 2005 #2 (You error 18483 distributor must log in or sign up to reply here.) Share This Page Tweet Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums. Your name or email address: Do you already have an account? Forgot your password? No, create an account now. Yes, my password is: Stay logged in SQL Server Performance Forums Home Forums > ARCHIVED SQL Server Posts > SQL Server 7.0 and 2000 Forum Topics > General DBA Questions > Forums Forums Quick Links Search Forums What's New? Members Members Quick Links Registered Members Current Visitors Recent Activity Help Help Quick Links Smilies BB Codes Trophies Search titles only Posted by Member: Separate names with a comma. Newer Than: Advanced search...
Replication on SQL 7.0, but I get the following Error: Error 18483: Could not connect to the server "Old_Name" because "distributor_admin" is not defined as a remote login at the server. I renamed the computer, awhile ago, and this is the only reason I can think of for this error, but how to I get around it without, reinstalling the whole thing. Shane. Top Error 18483 - Can't Configure Replication after Renaming Server. by Michael Hote » Tue, 21 Dec 1999 04:00:00 You can't. The only reliable way to get SQL Server running again after renaming a machine is to completely uninstall and reinstall SQL Server. -- Mike Schema Manager 1.0 review is up: http://www.mssqlserver.com/products SQL Server resources: http://www.mssqlserver.com Jokes, general products, and consulting: http://www.mhotek.com Certification resources: http://www.certfaq.com SYSOP PASS Discussion Forums: http://www.sqlpass.org "Aim high. You can never achieve more than you aspire to." - Al Reis Please direct all replies to the newsgroup unless specifically stated otherwise. Top 1. configuring distribution and publishing: error 18483 Hello, I do not manage to configure distribution and publishing for replication in SQL Server 2000. I use SQL Server 2000 SP3 with Windows 2000 Server. The steps: 1) login as 'sa' on the 'my server' in Enterprise Manager 2) click on my server in "server group". 4) right-click -> "properties" 4) tab "replication" 5) click button "configure" 6) the wizard "configure distribution and publishing wizard on 'my server'" appears. 7) click "Next" 8) choose "Make 'my server' its own distributor" and click "Next" 9) choose "Yes, make the 'SQL start agent' start automatically" and click "Next" 10) let the default replication database folder and click "Next" ( if it warns that this is a special network share that can be accessed only by administrator, then click "Yes" ) 11) choose "No, I want to use these default settings" and click "Next" 12) click "Finish" Then, the following error appears: "SQL Server Enterprise Manager could not configure 'my server' as the distributor for 'my server'. Error 18483: Could not connect to server 'my server' because 'distributor_admin' is not defined as a remote login at the server." I tried to cre