Error 15429 Sql Server 2008
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. SQL Server > SQL Server Database Engine Question 0
Null Is An Invalid Product Name Sp Add Linked Server
Sign in to vote I have a server setup with 2 separate SQL installs on login failed for user linked server it. I am trying to setup a linked server from one DB to the other, but I cannot get it to work.
Sp_addlinkedsrvlogin
I have never done this before, plus I am not very good at SQL.. I am strictly server. I have combed the internet, but I cannot find anything that works. Currently this is what I am sp_addlinkedserver 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 sp_addlinkedserver example 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 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 Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to
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 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 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 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 http://stackoverflow.com/questions/841339/having-trouble-adding-a-linked-sql-server '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 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.7k319
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified http://www.tek-tips.com/viewthread.cfm?qid=828658 Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by linked server Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft SQL Server: Programming Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft SQL Server: Programming Forum Adding Linked Servers thread183-828658 Forum Search FAQs Links MVPs Adding Linked Servers Adding Linked error 15429 sql Servers aco636 (IS/IT--Management) (OP) 26 Apr 04 12:13 Anyone see why this wont work? Always returns "@svrproduct is not a parameter for procedure sp_addlinkedserver."Remove @svrproduct and returns error "'(null)' is an invalid product name."Now close to suicide. Any help gratefully received.EXEC sp_addlinkedserver@server='ValueOfRemoteAlias',@provider='Advantage OLE DB Provider',@datasrc='\\SERVER\SHARE\data',@location='\\SERVER\SHARE\data',@provstr='Provider=Advantage.OLEDB.1;Data Source=\\SERVER\SHARE\Data;Persist Security Info=False',@svrproduct='Advantage.OLEDB.1'GO RE: Adding Linked Servers vongrunt (Programmer) 26 Apr 04 12:22 Typo... should be @srvproduct RE: Adding Linked Servers TJRTech (Programmer) 26 Apr 04 12:23 Did you try rearranging the order of the parameters to exactly match that of the BOL documentation?Also, are you sure that all the param names match those specified by BOL?It seems that they do.Lastly, does the product name you are specifying "exactly" match that as shown by ODBCAD32.exe when selecting the "Advantage" driver from the list?Though I doubt this is it because it seems that BOL is stating that this name can be "Any" value.TR RE: Adding Linked Servers TJRTech (Programmer) 26 Apr 04 12:24 Yup...typo.Didn't catch that, but I have a mild case of dyslexia.TR RE: Adding Linked Servers aco636 (IS/IT--Management) (OP) 2