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: boam5, Sep 30, 2005 #2 (You 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 Can someone, please?--Wack----This message will self destruct. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered!

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. Error 18483: Could not connect to server 'VIPER' because 'distributor_admin' is not defined as a remote login at the server. Even though I was creating a local distributor, the server name did not match what was configured and the login creation failed. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed

Can someone, please?--Wack----This message will self destruct. *--benno2004------------------------------------------------------------------------Posted via http://www.mcse.ms------------------------------------------------------------------------View this thread: http://www.mcse.ms/message1479774.html 3 Replies 136 Views Switch to linear view Disable enhanced parsing Permalink to this page Thread Navigation Ray I tried adding the sp_addserver [server name]. 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 So you need to set up the constraint delegation, see Configuring Linked Servers for Delegation: Requirements for the Client The Windows user must have access permissions to SQLSERVER1 and SQLSERVER2.

LEFT OUTER JOIN in SQL Server77SQL Server 2008 Windows Auth Login Error: The login is from an untrusted domain4“ASP.NET” error: Access to the remote server is denied because no login-mapping exists2060UPDATE Superposition of images Looking for a term like "fundamentalism", but without a religious connotation Why aren't Muggles extinct? When I tried to run SQL2000 E/M's "Configure Publishing and Distribution" wizard on ServerA, I got this error. You cannot upload attachments.

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 login Why are so many metros underground? share|improve this answer answered Jun 1 '10 at 23:19 Remus Rusanu 206k25268405 add a comment| up vote 0 down vote run the following command, and it may fix it for you Log in :: Register :: Not logged in Home Tags Articles Editorials Stairways Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us

Is there a way i can make the [server name] as active? 0 Message Accepted Solution by:maxomedia2005-10-10 You need to run sp_dropserver first, then go for sp_addserver. You will have to stop and start SQL.-- Use the Master databaseUSE masterGO-- Declare local variablesDECLARE @serverproperty_servername varchar(100), @servername varchar(100)-- Get the value returned by the SERVERPROPERTY system functionSELECT @serverproperty_servername = What do you mean that the servername should match the netbios name? You cannot delete your own topics.

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 Terms of Use. Can someone, please?--Wack----This message will self destruct. Post #446581 alpeshpradhanalpeshpradhan Posted Wednesday, June 16, 2010 1:38 AM Grasshopper Group: General Forum Members Last Login: Wednesday, August 20, 2014 3:50 AM Points: 14, Visits: 199 so you mean to

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 The account under which SQL Server is running must be trusted for delegation. Select @@Servername. Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We

Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". 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 thewizard, ISQL Server Enterprise Manager Investigating further, I discovered that the test servers I was given to use were named differently from the configured server name. as 'self-mapping' in SQL Server linked in terms).

The thing that confused me at first was that it was complaining about a missing remote login for the replication linked server that gets created when you run sp_adddistributor.

The reason My math students consider me a harsh grader. The wizard executed sp_dropdistributor @no_checks = 1, @ignore_distributor = 1, and the error 18483 was resolved for all client tools. The error: Msg 18483, Level 14, State 1, Line 1 Could not connect to server 'MyServer' because 'distributor_admin' is not defined as a remote login at the server.

Enable publication database 8. 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. 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. Username: Password: Save Password Forgot your Password?

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. Requirements for the First/Middle Server (SQLSERVER1) The server must have an SPN registered by the domain administrator. You cannot edit your own topics. The computer name is "GHS0023RPT'.3.

You cannot post topic replies. You can see (kinda) that the original name is VMSSERV and the actual machine name is VIPER. Does the string "...CATCAT..." appear in the DNA of Felis catus? Covered by US Patent.

Unlike most other features in SQL Server, replication relies heavily on the actual server name. You cannot send emails. selected distributor 2. I then had to do it with out a variable associated, reran the query and it changed the name. –RogueSpear00 Oct 27 '11 at 20:56 add a comment| Your Answer

You cannot rate topics. Gave database name and folder path for the db and log 6. The linked server logins must be configured for self mapping.

You cannot delete your own topics. I validate the window server 2003 property. Connect with top rated Experts 27 Experts available now in Live! Investigating further, I discovered that the test servers I was given to use were named differently from the configured server name. You cannot post or upload images. 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 Corruptio...

That did not fix the problem. 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 Why don't you connect unused hot and neutral wires to "complete the circuit"? By default, it's "(local)". Join & Ask a Question Need Help in Real-Time? Featured Post Free Trending Threat Insights Every Day Promoted by Recorded Future Enhance your security with...