Microsoft Sql Error 7301
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: Get Active Directory Users First/Last/Full Name error 7399 linked server sql server thru Linked Server SQL Server > Transact-SQL Question 0 Sign in to sql server error 7399 access denied vote Hi There, I am trying to retrieve first/last/fullname of a login. I have succeeded in retrieving cannot obtain the required interface ( iid_idbschemarowset ) the displayname by means of the loginname, but the other names (first/last/full) a have some troubles with: I have created a linked server: -- Create Linked Server ADSI cannot create an instance of ole db provider oraoledb.oracle for linked server error 7302 USE Master GO EXEC master.dbo.sp_dropserver @server = N'ADSI' GO EXEC master.dbo.sp_addlinkedserver @server = N'ADSI' , @srvproduct = N'Active Directory Services' , @provider = N'ADsDSOObject' , @datasrc = N'einstein.waterland.loc' --AKA the full computer name of the AD server Then I wrote this function: USE [ReportServer] GO ALTER Function [dbo].[AdUsers] ( ) RETURNS Table AS RETURN ( Select [Name] ,
Cannot Obtain The Required Interface ( Iid_idbschemarowset ) From Ole
[DisplayName] From OpenQuery ( ADSI,'SELECT name, displayname FROM ''LDAP://einstein.waterland.loc'' WHERE objectCategory = ''Person'' AND objectClass = ''user''') ) ============================================================================= This function is oké. But if I try to retrieve firstname, lastname or fullname in the function Like: From OpenQuery ( ADSI,'SELECT lastname, displayname FROM ''LDAP://einstein.waterland.loc'' WHERE objectCategory = ''Person'' AND objectClass = ''user''') ) I get the error: Msg 7399, Level 16, State 1, Procedure AdUsers, Line 8 The OLE DB provider "ADsDSOObject" for linked server "ADSI" reported an error. The provider did not give any information about the error. Msg 7350, Level 16, State 2, Procedure AdUsers, Line 8 Cannot get the column information from OLE DB provider "ADsDSOObject" for linked server "ADSI". ============================================================================= Then if I try to open the "Tables" or "Views" tab in the linked server ADSI, Catalogs, Default entry, I get the error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch.
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 Us Learn more about Stack Overflow the company Business Learn
Microsoft Sql Server Error 7399 Invalid Authorization Specification
more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges cannot obtain the required interface iid_idbschemarowset from ole db provider adsdsoobject Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a cannot obtain the required interface iid_idbcreatecommand minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top ADSI Linked Server: Why can I query AD in VBA, but not https://social.msdn.microsoft.com/Forums/sqlserver/en-US/3cc890ec-62f1-4b81-8786-2db31a1615e3/get-active-directory-users-firstlastfull-name-thru-linked-server?forum=transactsql as a Linked Server? up vote 0 down vote favorite After all the reading and research I've done, this seems like the most logical place to post this question: Why can I query Active Directory using VBA, but not a Linked Server in SQL Management Studio 2012? First, I have been able to do this before, but many moons ago with SQL Server 2005. Here is the query I am attempting: SELECT * FROM OpenQuery( ADSI, 'SELECT http://serverfault.com/questions/673390/adsi-linked-server-why-can-i-query-ad-in-vba-but-not-as-a-linked-server displayName, title, department, employeeID, userAccountControl FROM ''LDAP://dc=testdomain'' WHERE objectCategory = ''Person'' AND objectClass = ''user'' AND userAccountControl=512') Here is the error I'm getting: Msg 7321, Level 16, State 2, Line 1 An error occured while preparing the query "SELECT displayName, title, department, employeeID, userAccountControl FROM 'LDAP://dc=testdomain' WHERE objectCategory = 'Person' AND objectClass = 'user' AND userAccountControl=512" for execution against OLE DB provider "ADsDSOObject" for linked server "ADSI". The problem with this error message is that it's very generic and seemingly doesn't yield anything useful. Everything I've read appears to be a permission issue or the syntax of the query, and I assume it's meant in the context to my SQL instance login and how the security is set up in the Linked Server. The VBA code below works and is using a query that's very similar and not even the simplest of queries have worked in the Linked Server. I also have access to the Active Directory I am trying to link to and this is proven by the snippet of VBA code I have at the bottom (only there for reference). Thing is, I believe I have all the right privileges in place to for this to be working. However, a lot of what's being suggested is on different sites involves doing modifications to the SQL instance that are not readily obvious of what the impacts are lo
SQL Server experts to answer whatever question you can come up with. Our new http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6674 SQL Server Forums are live! Come on over! We've restricted the http://www.mssqlforum.com/threads/cannot-obtain-the-required-interface-iid_ibschemarowset.2067/ 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) cannot obtain Linked Server, Error 7301 Reply to Topic Printer Friendly Author Topic AskSQLTeam Ask SQLTeam Question USA 0 Posts Posted-06/04/2001: 00:56:45 sherry writes "Hi, I would like to know how to handle the following error : Error 7301. Could not obtain a required interface from OLE DB provider 'MSIDXS'" graz Chief SQLTeam Crack cannot obtain the Dealer USA 4149 Posts Posted-06/04/2001: 00:56:45 Usually MS Knowledge support is you best bet in questions like this. Especially in this case.http://support.microsoft.com/support/kb/articles/Q248/1/56.ASP 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 Topi
or Login Having an account grants you additional privileges, such as creating and participating in discussions. Cannot obtain the required interface ("IID_IBSchemaRowset") Discussion in 'Business Intelligence' started by Peter Schmitz, Feb 11, 2014. Peter Schmitz Administrator Staff Member I've been attempting to connect my SQL Development box at work to Oracle lately, and it's been a real struggle. I'll see if I can document the process a bit, in case someone else ends up running into issues (Why is it so difficult to set up a connection to Oracle to begin with?). Today, after the so-manieth Oracle client install, and tweaking some settings the Linked Server I originally created (using MSDASQL) suddenly ceased to work with the following error message: Code (text): Cannot obtain the required interface("IID_IDBSchemaRowset") from OLE DB Provider "OraOLEDB.Oracle" for linked server "