Error 18483 Sql Server
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 sp_addremotelogin this site About Us Learn more about Stack Overflow the company Business
Sp_dropserver
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 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
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 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 http://dba.stackexchange.com/questions/6845/sql-server-error-18483-when-setting-up-sql-distribution 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: Could not connect to server because "distributor_admin" is not defined as a remote login at http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=19639 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 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 fai
18483) http://www.sql-server-performance.com/forum/threads/replication-error-18483.6337/ Discussion in 'General DBA Questions' started by boam5, https://www.experts-exchange.com/questions/21585274/SQL-server-Replication-distributor-admin.html Sep 30, 2005. boam5 New Member when configuring publisher and distributor i've got 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 sql 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...
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