Error 18483 Could Not Connect Server
Contents |
360 games PC games
Sp_addremotelogin
Windows games Windows phone games Entertainment All Entertainment sp_dropdistributor Movies & TV Music Business & Education Business Students & educators
Sp_dropserver
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
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » SS2K5 Replication » Error 18483 Could not connect to server bcs... Error 18483 Could not connect to server bcs distributor_admin Rate Topic Display Mode Topic Options Author Message Ed7Ed7 Posted Monday, August 4, 2008 10:10 AM Old Hand Group: General Forum Members Last Login: Thursday, January 21, https://support.microsoft.com/en-us/kb/818334 2016 8:34 AM Points: 355, Visits: 930 Hello room,I setup a transaction replication between SQL 2000 (Publisher and Local Distributor) and SQL 2005 (Subscriber).I run into an error:Msg 18483, Level 14, State 1, Procedure sp_adddistributor, Line 130Could not connect to server 'SERVER_A' because 'distributor_admin' is not defined as a remote login at the server.Can anyone help http://www.sqlservercentral.com/Forums/Topic546215-291-1.aspx on this? Thanks in advance.Regards,TJ Post #546215 « Prev Topic | Next Topic » Permissions You cannot post new topics. You cannot post topic replies. You cannot post new polls. You cannot post replies to polls. You cannot edit your own topics. You cannot delete your own topics. You cannot edit other topics. You cannot delete other topics. You cannot edit your own posts. You cannot edit other posts. You cannot delete your own posts. You cannot delete other posts. You cannot post events. You cannot edit your own events. You cannot edit other events. You cannot delete your own events. You cannot delete other events. You cannot send private messages. You cannot send emails. You may read topics. You cannot rate topics. You cannot vote within polls. You cannot upload attachments. You may download attachments. You cannot post HTML code. You cannot edit HTML code. You cannot post IFCode. You cannot post JavaScript. You cannot post EmotIcons. You cannot post or upload images
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 http://stackoverflow.com/questions/2953383/help-with-linked-server-error company Business Learn 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, 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 error 18483 stored procedure in a database on 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 error 18483 could Could not connect to server 'RemoteServer' because '' is 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