Microsoft Error 15429
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 14:03:43 GMT by s_wx1085 (squid/3.5.20)
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 > create link server got error Want to Advertise Here? Solved create link server got error Posted on 2011-02-08 MS http://answers.microsoft.com/en-us/windows/forum/windows_other-windows_programs/how-to-fix-the-error-15429-of-sqlserver-2008r2/24ec8316-6edd-4791-8de9-720c263d874e 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 like: (null) is an invalid product name. ( Microsfot SQL server, Error: 15429) https://www.experts-exchange.com/questions/26806688/create-link-server-got-error.html 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'''''', @provider=N'SQLNCLI', @datasrc=N'ActualServerName' Select all Open in new window 0 LVL 29 Overall: Level 29 MS SQL Server 10 Message Expert Commen
SQL Server experts to answer whatever question you can come up with. Our new SQL http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=11324 Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2000 Forums SQL Server Administration (2000) Linked Server linked server using spAddLinkedServer Reply to Topic Printer Friendly Author Topic AskSQLTeam Ask SQLTeam Question USA 0 Posts Posted-12/11/2001: 09:42:59 Ike writes "Hi,Is there a way to link a server with a different password for SA using sp_addlinkedserver? If so, how? I use "EXEC sp_addlinkedserver @server = @linkedServer" in my TSQL (I change the server microsoft error 15429 name in the variable). I tried using the "@provider" and "@provstr" parameters but I kept receiving a "Server: Msg 15429, Level 16, State 1, Procedure sp_addlinkedserver, Line 72'(null)' is an invalid product name." error. If the password is the same, I use the "EXEC sp_addlinkedserver @server = @linkedServer" with no trouble." izaltsman A custom title USA 1139 Posts Posted-12/11/2001: 14:01:47 How about EXEC sp_addlinkedserver @server = @linkedServer, @srvproduct ='SQL_SERVER', @provider = 'SQLOLEDB', @datasrc = @linkedServer, @catalog = 'mydb' 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 Corruption Issues Database Design and Application Architecture SQL Server 2012 Forums Transact-SQL (2012) SQL Server Administration (2012) SSIS and Import/Export (2012) Analysis Server and Reporting Services (2012) Replication (2012) Availability Groups and DR (2012) Other SQL Server 2012 Topics SQL Server 2008 Forums Transact-SQL (2008) SQL Server Administration (2008) SSIS and Import/Export (2008) High Availability (2008) Replicat