Msdasql Reported An Error Authentication
Contents |
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2008 » SQL Server 2008 Administration » Linked Server Fails with the ole db provider sqlncli11 for linked server reported an error. authentication failed SQL Login. Works as... Linked Server Fails with SQL Login. Works as Server Admin microsoft sql server error 7399 invalid authorization specification Rate Topic Display Mode Topic Options Author Message homebrew01homebrew01 Posted Wednesday, November 6, 2013 3:30 PM SSCrazy Group: General Forum Members Last linked server error 7399 Login: Today @ 8:47 AM Points: 2,934, Visits: 9,015 I have a linked server to MySQL on a Windows server 2003 32 bit server. I can run selects & updates against the MySQL database as
Cannot Initialize The Datasource Object Of Ole Db Provider Sqlncli11 For Linked Server
a Windows admin account, but not as a local SQL login, which is what the application will be using. I get the error:OLE DB provider "MSDASQL" for linked server "mysql_cms" returned message "[MySQL][ODBC 3.51 Driver]Access denied for user 'MySQL_Login'@'216.1.1.1' (using password: YES)".Msg 7303, Level 16, State 1, Line 1Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "mysql_cms".I am using an old ver 3.51 MySQL driver because linked server error 7303 the newer ones fail when trying to install.Ideas ?? Post #1512024 spaghettidbaspaghettidba Posted Thursday, November 7, 2013 2:48 PM SSCertifiable Group: General Forum Members Last Login: Yesterday @ 7:04 AM Points: 5,517, Visits: 13,279 Linked servers use OLEDB providers, which are ultimetely DCOM objects. DCOM configuration is really tricky and out of the box everything works with Administrator only.See if some of the steps here can help: http://www.sqlservercentral.com/articles/Linked+Servers/73794/ --Gianluca SartoriHow to post T-SQL questionsspaghettidba.com@spaghettidba Post #1512460 homebrew01homebrew01 Posted Thursday, November 7, 2013 3:22 PM SSCrazy Group: General Forum Members Last Login: Today @ 8:47 AM Points: 2,934, Visits: 9,015 Before I make lots of changes on a production server, do you know which settings might apply to my situation ? That I can access the MySQL data via Linked Server if I use Windows Authentication, but not with a SQL login. Thanks Post #1512469 spaghettidbaspaghettidba Posted Thursday, November 7, 2013 3:26 PM SSCertifiable Group: General Forum Members Last Login: Yesterday @ 7:04 AM Points: 5,517, Visits: 13,279 Probably the SQL Server service account can't instantiate the OLEDB provider.Follow the steps in the "DCOM configuration" section of the article.However, I don't recommend that you troubleshoot in production (some changes actually need rebooting the machine!).Find a test server and fiddle with permissions there instead.Once you
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 the ole db provider sqlncli11 for linked server does not contain the table Hire for a Full Time Job Ways to Get Help Expand Search Submit
The Linked Server Has Been Created But Failed A Connection Test
Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts
Invalid Authorization Specification Sql
Exchange > Questions > SQL Server Agent OLE DB provider 'MSDASQL' reported an error Want to Advertise Here? Solved SQL Server Agent OLE DB provider 'MSDASQL' reported an error Posted on http://www.sqlservercentral.com/Forums/Topic1512024-1550-1.aspx 2006-06-22 MS SQL Server 1 Verified Solution 6 Comments 2,417 Views Last Modified: 2008-01-09 Hi there, I have a DTS package that retrieves data from a Linked server via an Ingres Connection. Ingres is running fine, and the packages tests for the service before running, the DTS package will execute fine manually, and I can run the package from a command line, but https://www.experts-exchange.com/questions/21895171/SQL-Server-Agent-OLE-DB-provider-'MSDASQL'-reported-an-error.html SQL agent won't execute the package, i simply get the following error. Error = -2147217900 (80040E14) Error string: OLE DB provider 'MSDASQL' reported an error. Authentication failed. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147217900 (80040E14); Provider Error: 7399 (1CE7) Error string: OLE DB provider 'MSDASQL' reported an error. Authentication failed. This is driving me mad know ! the server agent uses the same administrator account as the SQL server, and the owner of the Job is the administrator as well. I am at a loss as to why it won't execute, can anyone shed any light on this !! System is running SQL server 2000 sp4, on a Windows 2000 server HELP :( 0 Question by:morrisp6 Facebook Twitter LinkedIn Google LVL 12 Best Solution byill if you can lower security, you can use this utility http://www.commandline.co.uk/sanur/ to run DTS under your account. Go to Solution 6 Comments LVL 3 Overall: Level 3 MS SQL Server 3 Messa
communityThis categoryThis boardKnowledge baseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you http://forums.teradata.com/forum/connectivity/odbc-sql-server-linked-server-connection-problem type. Showing results for Search instead for Did you mean: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37174 Teradata : Product Forums : Connectivity : odbc/ sql server linked server connection problem Options Subscribe to RSS Feed Mark Topic as New Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page Highlighted linked server garrett_s N/A Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email to a Friend Report Inappropriate Content 06-03-2009 02:55 PM 06-03-2009 02:55 PM odbc/ sql server linked server connection problem We are using the SQL Server 2000 linked server functionality (openquery) from stored ole db provider procedures to get data from teradata through the odbc driver 3.06.We tried an upgrade to TTU 12.0 and no relief.We can duplicate this by running stored procedures in rapid succession that access this linked server.We get this error:Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'MSDASQL' reported an error. Authentication failed.[OLE/DB provider returned message: [NCR][ODBC Teradata Driver] Not enough information to log on][OLE/DB provider returned message: [NCR][ODBC Teradata Driver] Cannot find a compatible package match between client and gateway in terasso library.][OLE/DB provider returned message: [NCR][ODBC Teradata Driver] Major Status=0x04b6 Minor Status=000000-The operation completed successfully.][OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Invalid connection string attribute][OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed][OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed][OLE/DB provider returned message: [NCR][ODBC Teradata Driver] Major Status=0x04b6 Minor Status=000000-No Routine error/No calling error]OLE DB error trace [OLE/DB Provide
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 Development (2000) Linked Server to Oracle Reply to Topic Printer Friendly Author Topic WalkerDA Yak Posting Veteran 61 Posts Posted-07/07/2004: 10:00:24 I have created a linked server though when querying a table from the linked server I get the following error:Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'MSDASQL' reported an error. [OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ].Here is the sql that I used for linking:EXEC sp_addlinkedserver @server = 'Tampa_A', @srvproduct = 'Oracle', @provider = 'MSDASQL', @provstr = 'DRIVER={Oracle ODBC Driver};DataSource =igs_tampa_a;UID=my_uid;PWD=my_pswd;' orEXEC sp_addlinkedserver @server = 'Tampa_A', @srvproduct = 'Oracle', @provider = 'MSDASQL', @datasrc = 'igs_tampa_a'Neither seems to work and both yields the exact error message.Derrick WalkerDA Yak Posting Veteran 61 Posts Posted-07/07/2004: 10:44:08 Sorry, I was using the wrong box when I was trying to connect.EXEC sp_addlinkedserver @server = 'Tampa_A', @srvproduct = 'Oracle', @provider = 'MSDAORA', @datasrc = 'igs_test1'Here is the error..it makes since because there is no where that I am familiar with to add login info here...Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'MSDAORA' reported an error. Authentication failed.[OLE/DB provider returned message: ORA-01004: default username feature not supported; logon denied]OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.].Or here where I specify the login info:EXEC sp_addlinkedserver @server = 'Tampa_A', @srvproduct = 'Oracle', @provider = 'MSDASQL', @provstr = 'DRIVER={Oracle ODBC Driver};DataSource =igs_tampa_a;UID=my_uid;PWD=my_pswd;'this yields the following error:Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'MSDASQL' reported an error. [OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver's SQLSet