Linked Server Error 15429
Contents |
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 null is an invalid product name sp add linked server Help Receive Real-Time Help Create a Freelance Project Hire for a
Sql Server Linked Server Login Timeout Expired
Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products ole db provider sqlncli11 for linked server returned message login timeout expired BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > create link server got error Want to Advertise Here? Solved create ole db provider sqlncli10 for linked server returned message login timeout expired link server got error Posted on 2011-02-08 MS SQL Server 1 Verified Solution 14 Comments 2,730 Views Last Modified: 2012-05-11 Dear expert, I tried to create link server, after give server name, local Login, Remote user, and remote password, checked vidio box 'be make using this security context', clike OK, it give me error
Named Pipes Provider Could Not Open A Connection To Sql Server 53 . Linked Server
like: (null) is an invalid product name. ( Microsfot SQL server, Error: 15429) I have filled all of fields, I don't know why it complain NULL? can you help? Thank you, LYNN 0 Question by:yrcdba7 Facebook Twitter LinkedIn Google LVL 29 Best Solution byPaul Jackson Check this : http://blogs.msdn.com/b/sql_protocols/archive/2006/08/10/694657.aspx (http://blogs.msdn.com/b/sql_protocols/archive/2006/08/10/694657.aspx) Go to Solution 14 Comments LVL 29 Overall: Level 29 MS SQL Server 10 Message Expert Comment by:Paul Jackson2011-02-08 What did you put in the product name field on the general tab? 0 LVL 29 Overall: Level 29 MS SQL Server 10 Message Expert Comment by:Paul Jackson2011-02-08 Also what type of server are you trying to link to? 0 Message Author Comment by:yrcdba72011-02-08 in the SQL server 2005 to link to SQL server 2005 0 LVL 40 Overall: Level 40 MS SQL Server 22 Message Active 1 day ago Expert Comment by:Sharath2011-02-08 Can you try this? EXEC master.dbo.sp_addlinkedserver @server = N'LogicalServerName', @srvproduct=N'''''',
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 company Business Learn more named pipes provider could not open a connection to sql server 53 . (microsoft sql server error 53) about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users login failed for user linked server Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each
Sp_addlinkedsrvlogin
other. Join them; it only takes a minute: Sign up Having trouble adding a linked SQL server up vote 9 down vote favorite 1 I'm trying to pull in data from a remote SQL Server. I can access https://www.experts-exchange.com/questions/26806688/create-link-server-got-error.html the remote server using SQL authentication; I haven't had any luck using the same credentials with sp_addlinkedserver. I'm trying something like this: Exec sp_dropserver 'Remote', 'droplogins' go EXEC sp_addlinkedserver @server='Remote', @srvproduct='', @provider='SQLNCLI', @datasrc='0.0.0.0' EXEC sp_addlinkedsrvlogin @useself='FALSE', @rmtsrvname='Remote', @rmtuser='User', @rmtpassword='Secret' Select Top 10 * from Remote.DatabaseName.dbo.TableName Here's what I get: OLE DB provider "SQLNCLI" for linked server "Remote" returned message "Login timeout expired". OLE DB provider "SQLNCLI" for linked server "Remote" returned message "An error has occurred while http://stackoverflow.com/questions/841339/having-trouble-adding-a-linked-sql-server 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.". Msg 53, Level 16, State 1, Line 0 Named Pipes Provider: Could not open a connection to SQL Server [53]. Again, I can access the server directly (in SQL Management Studio) using these exact credentials, so it's not a problem with my network or credentials. Most of the examples I've seen online seem to involve Windows domain accounts, as opposed to SQL security logins. Does this not work with SQL authentication? sql-server linked-server share|improve this question edited May 9 '09 at 19:13 asked May 8 '09 at 19:08 Herb Caudill 20.8k3199154 add a comment| 6 Answers 6 active oldest votes up vote 6 down vote accepted It does work with sql authentication. In fact its easier, as you don't have to set up Kerberos if you use SQL authentication. One thing is confusing about your error messages, your address is an IP address : 123.45.678.90 your error message is talking about Named Pipes. Could this be a clue? You don't have to reference the server in TSQL by it's IP address. If you add an alias on the local server, pointing to the remote server, you can give a more sensible name. Refering to it by IP add
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » Administering » SQL Linked server error 17 posts,Page 1 http://www.sqlservercentral.com/Forums/Topic658199-146-1.aspx of 212»» SQL Linked server error Rate Topic Display Mode Topic Options Author Message marees.inspiremarees.inspire Posted Monday, February 16, 2009 10:06 PM Valued Member Group: General Forum Members Last Login: Thursday, January 21, 2016 1:45 PM Points: http://qogoyevoryjojaqytud.xpg.uol.com.br/null-is-an-invalid-product-name-error-15429.html 60, Visits: 247 Hi ALl,I am getting the following error for linked server.Plz help. Thanks in advance.OLE DB provider "SQLNCLI10" for linked server "X" returned message "Login timeout expired".OLE DB provider "SQLNCLI10" for linked server "X" returned linked server message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".Msg 53, Level 16, State 1, Line 0Named Pipes Provider: Could not open a connection to SQL Server [53]. OLE DB provider "X" for linked server "CPSERVER" returned message login timeout expired "Invalid connection string attribute". Post #658199 John H Marsh John H Marsh Posted Monday, February 16, 2009 11:53 PM Ten Centuries Group: General Forum Members Last Login: Monday, November 9, 2015 9:56 AM Points: 1,337, Visits: 1,448 Hello,Has this Linked Server ever worked?Can you post a screen-shot of the Linked Server General Properties page? Failing a screen-shot please detail each property-value pair.Regards,John Marsh www.sql.luSQL Server Luxembourg User Group Post #658229 marees.inspiremarees.inspire Posted Tuesday, February 17, 2009 12:08 AM Valued Member Group: General Forum Members Last Login: Thursday, January 21, 2016 1:45 PM Points: 60, Visits: 247 Thanks John.the issue was resolved now:) Post #658235 Steve-443559Steve-443559 Posted Friday, March 13, 2009 11:25 AM SSC-Enthusiastic Group: General Forum Members Last Login: Monday, February 22, 2016 7:08 AM Points: 165, Visits: 574 I'm getting this same problem. Can you tell me how the issue was resolved?Thanks! Post #675451 John H Marsh John H Marsh Posted Sunday, March 15, 2009 9:04 PM Ten Centuries Group: General Forum Members Last Login: Monday, November 9, 2015 9:56 AM Points: 1,337, Visits: 1,448 Hello Steve,I would ask the same two questions of you i.e. has this Linked Server ever worked, and can you post a screen-shot of the Linked Server General Properties page?Regards,John Marsh www.sql.luSQL Server Luxembourg User Group Post #676222 Steve-443559Steve-443559 Posted Monday, March 16, 2009 7: