Error 15429 Sql
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Setup Linked server - 2 installed instances of SQL on the same server.
Null Is An Invalid Product Name Sp Add Linked Server
SQL Server > SQL Server Database Engine Question 0 Sign in to login failed for user linked server vote I have a server setup with 2 separate SQL installs on it. I am trying to setup a linked sp_addlinkedsrvlogin server from one DB to the other, but I cannot get it to work. I have never done this before, plus I am not very good at SQL.. I am strictly
Sp_addlinkedserver
server. I have combed the internet, but I cannot find anything that works. Currently this is what I am doing.. I am right clicking on the Linked server folder and choosing New Linked Server - The default provider is (Microsfot OLE DB Provider for SQL Server. I put the name of the server in the Linked Server area; Product name is SQL server - Data Source is the name of the SQL server as identifed in the services (Is that correct)? I recieve an error when I run it (An exception occured while executoing a Transact-SQL statement or batch, ->(Microsoft.SQLServer.ConnectionInfo)-> (Null) is an invalid product name. (Microsoft SQL Server, Error: 15429). Any help would be appreciated. Thanks, Friday, February 19, 2010 2:12 PM Reply | Quote Answers 0 Sign in to vote Give a try to the link belowhttp://www.sql-articles.com/articles/dba/linked-server-part-1Vidhya Sagar. Mark as Answer if it helps! Marked as answer by TToby123456 Monday, February 22, 2010 12:17 PM Friday, February 19, 2010 7:24 PM Reply | Quote Moderator All replies 0 Sign in to vote Can you right click the linked server in SSMS and script it out and post the code back here. That may help identify the problem.Also, you should select the top radio for "SQL Server". not OLE DB. No other configuration is needed for OLE DB if you are linking to SQL ServerTed Krueger Blog on lessthandot.com @onpnt on twitter Friday, February 19, 2010 2:25 PM Reply | Quote Moderator 0 Sign in to vote Give a try to the li
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 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 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 https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6ad63940-a5e8-4287-b486-c718c9fe759f/setup-linked-server-2-installed-instances-of-sql-on-the-same-server?forum=sqldatabaseengine access 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 http://stackoverflow.com/questions/841339/having-trouble-adding-a-linked-sql-server while 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.7k3199153 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 i
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 http://www.sqlservercentral.com/Forums/Topic658199-146-1.aspx » Administering » SQL Linked server error 17 posts,Page 1 of 212»» SQL Linked server error Rate Topic Display Mode Topic Options Author Message marees.inspiremarees.inspire Posted Monday, February 16, 2009 http://forums.databasejournal.com/showthread.php?19740-linked-server 10:06 PM Valued Member Group: General Forum Members Last Login: Thursday, January 21, 2016 1:45 PM Points: 60, Visits: 247 Hi ALl,I am getting the following error for linked server.Plz help. linked server 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 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 error 15429 sql 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 "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
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 Oracle PostgreSQL Sybase Miscellaneous General Database Discussions Ask an Expert Database Design Database Programming Database News and Announcements Structured Query Language (SQL) SQL Scripts Database Lounge Feedback Related Sites SQL Course SqlCredit « Previous Thread | Next Thread » Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off [VIDEO]