Error 18482 Sql Server

360 games PC games error 18482 could not connect Windows games Windows phone games Entertainment All Entertainment mssql error 18482 Movies & TV Music Business & Education Business Students & educators

Sp_addremotelogin

Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet

Sp_dropdistributor

Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States)‎ Terms of use Privacy & cookies Trademarks © 2016 Microsoft

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 2008 cannot delete publisher error 18482 Want to Advertise Here? Solved SQL Server 2008 cannot delete publisher error 18482 Posted on 2012-08-15 MS SQL Server 1 Verified https://support.microsoft.com/en-us/kb/217395 Solution 5 Comments 776 Views Last Modified: 2013-01-24 I tried to delete publisher and got error: Cannot delete publication xxx. Cannot connect to server'Distibution server name' becase 'Publisher server name' is not defined as a remote server. error 18482. I checked and my publisher server defined as remote server and distibution server, subscriber server also in sysserver table defined as remote servers. appreciate your https://www.experts-exchange.com/questions/27829895/SQL-Server-2008-cannot-delete-publisher-error-18482.html help in advance. 0 Question by:DDB Facebook Twitter LinkedIn Google LVL 25 Best Solution byTempDBA Try running following in master server select @@servername If this gives NULL it means something is wrong with the metadata. So, make it fine using:- Use Master go exec Sp_DropServer '' Go to Solution 4 Comments LVL 25 Overall: Level 25 MS SQL Server 14 Message Accepted Solution by:TempDBA2012-08-16 Try running following in master server select @@servername If this gives NULL it means something is wrong with the metadata. So, make it fine using:- Use Master go exec Sp_DropServer '' go Use Master go exec Sp_Addserver '', 'local' go 0 LVL 3 Overall: Level 3 MS SQL Server 1 Message Author Comment by:DDB2012-08-31 I've requested that this question be deleted for the following reason: Issue was resolved by myself 0 LVL 25 Overall: Level 25 MS SQL Server 14 Message Expert Comment by:TempDBA2012-09-02 What was the solution? Can you please share with us? It would be helpful to assist others. And also request for closing the question rather than deletion. 0 LVL 3 Overall: Level 3 MS SQL Serv

produced: SQLServer Enterprise Manager could not configure 'server' as the Distributor for 'server' Error 18482: Could not connect to server 'SSSS' because 'SSSS' is not defined as http://www.cryer.co.uk/brian/sqlserver/ssem_cncd.htm a remote server. Where ‘server' is the name of the local server (which is also acting as the distributor) and ‘SSSS' is a different name. Cause: This error has been http://www.bigresource.com/MS_SQL-Remote-server-err-18482-BpUXOyRy.html observed on a server that had been renamed after the original installation of SQL Server, and where the SQL Server configuration function ‘@@SERVERNAME' still returned the original name of error 18482 the server. This can be confirmed by: select @@SERVERNAME
go This should return the name of the server. If it does not then follow the procedure below to correct it. Remedy: To resolve the problem the server name needs to be updated. Use the following: sp_addserver real-server-name, LOCAL if this gives an error complaining that the name already exists then error 18482 sql use the following sequence: sp_dropserver real-server-name
go
sp_addserver real-server-name, LOCAL
go If instead the error reported is 'There is already a local server.' then use the following sequence: sp_dropserver old-server-name
go
sp_addserver real-server-name, LOCAL
go Stop and restart SQL Server. Other Possible Remedies Phillip Ushijima has told me that he had an issue with pushing a subscription with the error messages indicated. His solution was to edit the SQL Server registration properties in the Enterprise Manager MMC to match the name returned by @@servername. Whilst he is not sure whether it was significant, he had previously added an alias into the client configuration on the distributor/publisher with a matching name (although this was unsuccessful in resolving the error on its own). These notes are believed to be correct for SQL Server 7 and may apply to other versions as well. About the author: Brian Cryer is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.

at the site. when I try to execute from the server NTSQL2 a stored procedure who take the information to the server NTSQL1 for insert in NTSQL2. The 2 server are defined as remote each other. It was working before the restart ! The both server have the same config: NT 4.0 spa5 SQL server 6.5 spa5a, standart netwerk connection. They should log each other with sa login, the computer NTSQL2 was restart with the same login as before. Any ideas ? Thanks, and HAPPY NEW YEAR :-) STEPHAN View 3 Replies Similar Messages: Remote Access Server Configuration Option And Remote Query Timeout? Error 15185: There Is No Remote User 'sa' Mapped To Local User '(null)' From The Remote Server 'DTS_FSERVER'. Remote Connections Enabled, But I Still Get Error That Remote Is Not Configured - Sql 2005 SQL Server 2008 :: Restoring A Database / Server Using A Remote Server As The Service Call? An Error Has Occurred While Establishing A Connection To The Server. When Connecting To SQL Server 2005, This Failure May Be Caused By The Fact That Under The Default Settings SQL Server Does Not Allow Remote Connections. Error :Execute Trigger From Remote Server To Another Server By Linked Server An Error Has Occurred While Establishing A Connection To The Server. When Connecting To SQL Server 2005, This Failure May Be Caused By The Fact That Under The Default Settings SQL Server Does Not Allow Remote Connections. (provider: SQL Network Interfa An Error Has Occurred While Establishing A Connection To The Server. When Connecting To SQL Server 2005, This Failure May Be Caused By The Fact That Under The Default Settings SQL Server Does Not Allow Remote Connections. (provider: Named Pipes Provide An Error Has Occurred While Establishing A Connection To The Server. When Connecting To SQL Server 2005, This Failure May Be Caused By The Fact That Under The Default Settings SQL Server Does Not Allow Remote Connections. (provider: Named Pipes Provide SQL Remote Connection Not Being Seen, Though Remote Connections Allowed SQL Server 2014 :: Synchronize Table On Remote Server Via Update Trigger Failing Do I Need To Create A Domain To Get Connectivity To A Report Server Database On A Remote SQL Server Instance? Error Connecting To Remote Server Using Microsoft SQL Server M