Error 18483 Could Not Connect
Contents |
360 games PC games sp_addremotelogin Windows games Windows phone games Entertainment All Entertainment
Sp_dropserver
Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet 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
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » Replication » configure publishing and distribution wizard... configure publishing and distribution wizard error Error 18483: could not connect to server because ''distributor_admin'' is not defined as a remote login at... Rate Topic Display Mode Topic Options Author Message adam spenceradam spencer Posted Wednesday, May 4, 2005 6:42 PM SSC Veteran Group: General Forum Members Last Login: Tuesday, September 23, 2014 4:16 PM Points: 224, Visits: 304 I am trying to configure replication on my https://support.microsoft.com/en-us/kb/818334 box, I am not conected to a network yet. the last screen of the 'configure publishing and distribution' wizard titled 'completing the configure publishing and distribution' , I click finish and get the following error message:SQL server EM could not configure 'Sp190' as the distributor for 'Sp190'.Error 18483: could not connect to server because 'distributor_admin' is not defined as a remote login at the server.I am new at this, http://www.sqlservercentral.com/Forums/Topic180059-7-1.aspx what do I need to do here???thank you very much!! Post #180059 Site OwnersSite Owners Posted Monday, May 9, 2005 8:00 AM SSChampion Group: General Forum Members Last Login: Friday, May 18, 2007 3:36 PM Points: 10,041, Visits: 1 No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have! Post #180832 goinggoing Posted Wednesday, May 11, 2005 4:19 AM Forum Newbie Group: General Forum Members Last Login: Wednesday, May 11, 2005 8:15 AM Points: 2, Visits: 1 i am also met the same problem,so i want to know how to discussion. Post #181346 goinggoing Posted Wednesday, May 11, 2005 4:52 AM Forum Newbie Group: General Forum Members Last Login: Wednesday, May 11, 2005 8:15 AM Points: 2, Visits: 1 WORKAROUNDTo work around this problem, replace the SQL Server 2000 server name with the correct network name of the computer. To do so, follow these steps: 1.Log on to the computer where you deployed SQL Server 2000 from the disk image, and then run the following Transact-SQL statement in SQL Query Analyzer:
-- Use the Master databaseUSE masterGO-- Declare local variablesDECLARE @serverproperty_servername varchar(100), @servername varchar(100)-- Get the value returned by the SERVERPROPERTYhere 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 http://stackoverflow.com/questions/2953383/help-with-linked-server-error more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, http://www.dbforums.com/showthread.php?1039547-18483-COULD-NOT-CONNECT-TO-SERVER-xxxxx helping each other. Join them; it only takes a minute: Sign up Help with Linked Server Error up vote 0 down vote favorite In SSMS 2008, I am trying to execute a stored procedure in a database on error 18483 another server. The call looks something like the following: EXEC [RemoteServer].Database.Schema.StoredProcedureName @param1, @param2 The linked server is set up correctly, and has both RPC and RPC OUT set to true. Security on the linked server is set to Be made using the login's current security context. When I attempt to execute the stored procedure, I get the following error: Msg 18483, Level 14, State 1, Line 1 Could not connect to server 'RemoteServer' because '' is error 18483 could not defined as a remote login at the server. Verify that you have specified the correct login name. I am connected to the local server using Windows Authentication. Anyone know why I would be getting this error? sql-server share|improve this question asked Jun 1 '10 at 21:13 Randy Minder 24.8k21107206 Just a guess but maybe a kerberos double hop issue? blogs.msdn.com/b/sql_protocols/archive/2006/08/10/694657.aspx –Martin Smith Jun 1 '10 at 21:17 add a comment| 2 Answers 2 active oldest votes up vote 2 down vote accepted 'Be made using the login's current security context' translates as impersonation (aka. as 'self-mapping' in SQL Server linked in terms). Access a remote server under an impersonated context means delegation. 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. The user AD property Account is sensitive and cannot be delegated must not be selected. The client computer must be using TCP/IP or named pipes network connectivity. Requirements for the First/Middle Server (SQLSERVER1) The server must have an SPN registered by the domain administrator. The account under which SQL Server is running must be trusted for delegation. The server must be using TCP/IP or named pipes network connectivity. The linked server logins must be configured for self mapping. Requirements for the Seco
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 3 of 3 Thread: 18483 COULD NOT CONNECT TO SERVER xxxxx Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 10-08-04,01:43 #1 ravindramall View Profile View Forum Posts Registered User Join Date Sep 2004 Posts 76 Unanswered: 18483 COULD NOT CONNECT TO SERVER xxxxx I have to registered remote server at each one other and going to configure publisher on of them got following error- SQL SERVER ENTERPRISE MANAGER- SQL SERVER ENTERPRISE MANAGER COULD NOT CONFIGURE 192.168.0.246\SQLIND AS THE DISTRIBUTOR FOR 192.168.0.246\SQLIND ERROR - 18483 COULD NOT CONNECT TO SERVER PRSTGIND\SQLIND BECAUSE 'distributor admin' is not defined as a remote login at the server. Thanks to all of you Reply With Quote 10-08-04,02:05 #2 openmind View Profile View Forum Posts Registered User Join Date Oct 2004 Location Korea Posts 9 Maybe your login Id does'nt exist on 192.168.0.246 Database Server Last edited by openmind; 10-08-04 at 02:10. Reply With Quote 10-08-04,06:29 #3 ravindramall View Profile View Forum Posts Registered User Join Date Sep 2004 Posts 76 How I can configure login for 'distributor admin'. I am using tools/replication/configure publisher......... Thanking You R.Mall Reply With Quote Quick Navigation Microsoft SQL Server Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Microsoft SQL Server MySQL Oracle Pervasive.SQL PostgreSQL Sybase Other Data Access, Manipulation & Batch Languages ASP Crystal Reports Delphi, C etc JAVA Perl and the DBI PHP ANSI SQL Unix S