Ms Sql 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 Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get
Null Is An Invalid Product Name Sp Add Linked Server
Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers login failed for user linked server Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > create link server got error Want to Advertise Here? Solved sp_addlinkedsrvlogin create 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,
Sp_addlinkedserver
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) 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 Active today 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 Active today 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 Active today 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 Active today Expert Comment by:Paul Jackson2011-02-08 Just put a space in the product name field and it should work or run the script above 0 Message Author Comment by:yrcdba72011-02-08 nothing, I only select vidio button in general tab with SQL Server. it gave different error like: Login failed for user xxxxx OLE DB provider "SQLNCLI"for linked server "xxxx" returned message "Communicaton link failure". (Microsoft SQL Server, Error: 10054 0 LVL 40 Overa
SQL Server experts to answer whatever question you can come up with. Our new SQL 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 using spAddLinkedServer Reply to Topic Printer Friendly Author Topic AskSQLTeam Ask SQLTeam Question USA 0 Posts Posted-12/11/2001: 09:42:59 https://www.experts-exchange.com/questions/26806688/create-link-server-got-error.html 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 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 http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=11324 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) Replication (2008) Analysis Server and Reporting Services (2008) Other SQL Server 2008 Topics SQL Server 2005 Forums Transact-SQL (2005) SQL Server Administration (2005) .NET Inside SQL Server (2005) SSIS and Import/Export (2005) Service Broker (2005) Replication (2005) High Availability (2005) Analysis Server and Reporting Services (2005) Express Edition and Compact Edition (2005) Other SQL Server Topics (2005) SQL Server 2000 Forums SQL Server Development (2000) SQL
= N'MYSERVERNAME', @provider=N'SQLNCLI', @datasrc=N'MYINSTANCENAME, @catalog=N'SOMENAME'I dropped the same http://aby-john.blogspot.com/2009/04/sql-server-2005-linked-server-scripting.html and tried to add it with the above script http://forums.databasejournal.com/showthread.php?19740-linked-server and it gave me the errorMsg 15429, Level 16, State 1, Procedure sp_addlinkedserver, Line 42'(null)' is an invalid product name.Solution :- Add the product name also in the sp parameters.An sp_helptext on the sp showed this:-create linked server procedure sys.sp_addlinkedserver @server sysname, -- server name @srvproduct nvarchar(128) = NULL, -- product name (dflt to ss) @provider nvarchar(128) = NULL, -- oledb provider name @datasrc nvarchar(4000) = NULL, -- oledb datasource property @location nvarchar(4000) = NULL, -- oledb location property @provstr nvarchar(4000) = NULL, -- ms sql error oledb provider-string property @catalog sysname = NULL -- oledb catalog propertyasetc etc ...The Script Linked Server as Create To command somehow missed the @srvproduct parameter.So the modified sql statement will be EXEC master.dbo.sp_addlinkedserver @server=N'MYSERVERNAME', @srvproduct=N'MSSQLSERVER', @provider=N'SQLNCLI', @datasrc=N'MYINSTANCENAME, @catalog=N'SOMENAME' Posted by Aby at 1:01 PM 1 comment: coldsurfer said... thank u sir! May 30, 2013 at 2:14 PM Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Search This Blog Loading... Subscribe To Posts Atom Posts Comments Atom Comments Blog Archive ► 2015 (1) ► August (1) ► 2012 (1) ► January (1) ▼ 2009 (7) ► October (3) ► July (1) ▼ April (1) Sql Server 2005 Linked Server Scripting issue ► March (1) ► February (1) ► 2008 (3) ► December (3) About Me Aby View my complete profile
New? Advanced Search Forum Database Discussions MS SQL Server 7/MS SQL Server 2000 linked server.... If this is 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 2 of 2 Thread: linked server.... Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 01-19-2001,03:37 PM #1 Ravi Guest linked server.... Hi All, I am trying execute the following and getting the below shown error. Can you please advise, how to go about???...thanks EXEC sp_addlinkedserver @server = 'server_name', @provider = 'MSDASQL', @provstr = 'DRIVER={SQL Server};SERVER=dsnname;UID=user_id;PWD=password; 39; GO getting error: Server: Msg 15429, Level 16, State 1, Line 0 '(null)' is an invalid product name. Reply With Quote 01-19-2001,03:53 PM #2 Sue Guest linked server.... (reply) The product name is the OLE DB data source to add as a linked server. I think you can put anything there except 'SQL Server'. Add this to your sp: @srvproduct = 'any', ------------ Ravi at 1/19/01 4:37:39 PM Hi All, I am trying execute the following and getting the below shown error. Can you please advise, how to go about???...thanks EXEC sp_addlinkedserver @server = 'server_name', @provider = 'MSDASQL', @provstr = 'DRIVER={SQL Server};SERVER=dsnname;UID=user_id;PWD=password; 39; GO getting error: Server: Msg 15429, Level 16, State 1, Line 0 '(null)' is an invalid product name. Reply With Quote Quick Navigation MS SQL Server 7/MS SQL Server 2000 Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Database Discussions IBM DB2 Informix Microsoft Access Microsoft SQL Server 2008 Microsoft SQL Server 2005 MDX and Analysis Services Reporting Services MS SQL Server 7/MS SQL Server 2000 MySQL Orac