Linked Server Error Invalid Connection String Attribute
Contents |
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » Administering » linked server error invalid connection string attribute sql server 2012 - "Invalid connection... linked server error - "Invalid connection string attribute"?? Rate Topic Display
Cannot Initialize The Data Source Object Of Ole Db Provider "sqlncli11" For Linked Server
Mode Topic Options Author Message Vivien XingVivien Xing Posted Tuesday, August 12, 2008 3:08 PM Ten Centuries Group: General Forum Members sp_addlinkedsrvlogin Last Login: Friday, October 10, 2014 8:13 AM Points: 1,278, Visits: 2,204 I am following this link to create a linked server from SQL2005 (64-bit/sp2) to SQL2000 (32 bit/sp4)http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspxand get this error when I tested create linked server on sql2005 server/box using "select * from [mysql2000svr].master.dbo.sysdatabases"OLE DB provider "SQLNCLI" for linked server "mysql2000svr" returned message "Invalid connection string attribute".Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "mysql2000svr".The script for creating the linked server is:EXEC sp_addlinkedserver @server= 'mysql2000svr', @srvproduct='', @provider='SQLNCLI', @datasrc='mysql2000svr',--the data source @provstr="Integrated Security=SSPI; "Anything wrong? or what the problem here? Post #551452 Brandon LillyBrandon
Sp_addlinkedserver
Lilly Posted Thursday, August 21, 2008 9:16 AM SSC Journeyman Group: General Forum Members Last Login: Wednesday, October 12, 2016 9:57 AM Points: 84, Visits: 205 I am having the same issue. What is crazy, is that the linked server WAS working fine. Spent a few days on the phone with Microsoft a couple months ago getting the double-hop authentication to work (client -> sql server -> linked sql server). Originally, the primary issue was a DNS issue where the servers were not showing the same FQN depending on where you pinged it from.It's been working for several weeks until yesterday, one of the developers noticed that queries to the linked servers (via the client) were bring back strange results. What is happening, is that the query is executing, but instead of executing on the linked server, it is bringing back local server results.For example, if I have the following servers: CERT and PROD. On CERT, there is a database called TEST, but it does not exist on PROD. On the server "PROD", I have a linked server to "CERT" and execute the following query:SELECT * FROM CERT.Test.dbo.SomeTableI get the following error:Msg 7314, Level 16, State 1, Line 1The OLE DB provider "SQLNCLI" for linked server "CERT" does
Start 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 login failed for user nt authority anonymous logon Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are http://www.sqlservercentral.com/Forums/Topic551452-146-1.aspx voted up and rise to the top SQL Server to sql server linked server setup up vote 24 down vote favorite 3 Please explain what is required to set up a SQL Server linked server. Server A is SQL 2005 windows logins only Server B is the same (SQL 2005 windows logins only) Server A runs windows XP Server B runs Windows Server 2003 Both SQL Server services http://serverfault.com/questions/88962/sql-server-to-sql-server-linked-server-setup are running under the same domain account. I am logged into my workstation with a domain account that has administrative rights on both SQL Servers. Note these are both SQL Server 2005 SP2 - I've had old hotfixes pointed out to me, but those are already applied. The issue I am having is this error: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Microsoft SQL Server, Error: 18456)" sql-server share|improve this question edited Nov 4 '12 at 3:44 MDMarra 87k23149291 asked Aug 28 '08 at 19:13 ScottStonehouse 53941123 migrated from stackoverflow.com Nov 28 '09 at 4:15 This question came from our site for professional and enthusiast programmers. add a comment| 9 Answers 9 active oldest votes up vote 18 down vote From My understanding of this issue it's a "HOP" issue. i.e. you are trying to use server A to relay your login details (with SSPI) to Server B. In SQL Server 2005 they have added a whole load of security issues that make this harder than it should be. The words "Kerberos Authentication" will become the bain of most sys-admins/DBA's lives. It effectively is used for pass-through authentication. Here are the basics of what you need. 1) The servers
Web Platform Installer Get Help: Ask a Question in our Forums More Help Resources Blogs https://forums.iis.net/t/1200810.aspx?Invalid+connection+string+attribute+SQL Forums Home IIS.NET Forums IIS 7 and Above Classic ASP Invalid connection string attribute - SQL Invalid connection string attribute - SQL RSS 9 http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/comment-page-3/ replies Last post Aug 12, 2013 10:39 AM by Dr.Crow ‹ Previous Thread|Next Thread › Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered linked server Threads Unresolved Threads Advanced Search Reply Dr.Crow 5 Posts Invalid connection string attribute - SQL Jul 31, 2013 11:59 AM|Dr.Crow|LINK I want to connect to my (My)SQL database using Classic ASP. This is my code: Function GetDatabase() Dim Connection Set Connection = Server.CreateObject("ADODB.Connection") Connection.Open = "Provider=SQLNCLI11;DRIVER={SQL Server};SERVER=127.0.0.1;Database=cms;Uid=root;Pwd=123456789zZ;Trusted_Connection=yes;" If invalid connection string Connection.errors.count = 0 Then Repsonse.Write("OK") End If End Function MyConnection = GetDatabase() But that doesn't work. It gives me this error: Microsoft SQL Server Native Client 11.0 error'80004005' Invalid connection string attribute /asp/conn.asp, row 8 Any ideas on how to fix that? I've googled for hours... and I couldn't find any answers, Thanks! connection sql Reply peterviola 735 Posts Re: Invalid connection string attribute - SQL Jul 31, 2013 12:17 PM|peterviola|LINK Hi, Your connection string is referencing SQL Server which is why you're getting the error. Try using: DRIVER={MySQL ODBC 5.1 Driver}; You can see the full syntax here: http://www.connectionstrings.com/mysql-connector-odbc-5-1/ connection sql Peter Viola MCTIP SA, EST, DBA 2008 MCSA Windows Server 2012 Please 'Mark as Answer' if this post helps you. www.peterviola.com Reply Dr.Crow 5 Posts Re: Invalid connection string attribute - SQL Jul 31, 2013 12:30 PM|Dr.Crow|LINK peterviola Hi, Your connect
being completely proprietary, one of the nice connectivity features offered in SQL Server is the ability to query other servers through a Linked Server. Essentially, a linked server is a method of directly querying another RDBMS; this often happens through the use of an ODBC driver installed on the server. Fortunately, many popular databases provide this ODBC driver, giving SQL Server the ability to connect to a wide range of other systems. I've already written about how to connect Oracle and SQL Server. In this post, I'm going to go through the steps necessary to connect SQL Server and MySQL. The first step is to fetch an appropriate MySQL Connector/ODBC 5.1 download. Drivers are available for a variety of OS‘s, but we're obviously focused on Windows or Window x64, which should correspond to the version of SQL Server installed. After you've downloaded and installed the driver, we have a few things to configure, so let's get started: Configure a MySQL DSN The first step is to configure a MySQL data source by running the ODBC Data Source Administrator. This step is technically entirely optional, but allows a simpler configuration in the SQL Server Linked Server settings. Instead of composing a complicated MySQL connection string, we can use a simple GUI application. Run odbcad32 If you're using Windows Server 2003, bring up a Run dialog box with Start→Run or WinKey+R. If you're using Windows Server 2008, use the Start Menu search box directly. In either OS, type in "odbcad32" and hit Enter. System DSN Select the System DSN tab to configure a data source for the entire system. If you only want to create the DSN for a specific user (such as your service account), use the User DSN tab. In either scenario, select the "Add…" button. Create New Data Source Scroll down in the Create New Data Source window and select "MySQL ODBC 3.51 Driver" and click "Finish". MySQL Connector Login Settings Once added, clicking