August 5, 2013 at 4:30 pm
Hi all.
We have a requirement to query our Active Directory for description fields from SQL server.
We of course get the same error as a multitude of other people who have posted across the internet.
"Could not convert the data value due to reasons other than sign mismatch or overflow."
I have read this was "fixed" from 2003 onwards.
I have read there are hot fixes for Windows 2003 and 2000
I cannot find any KB articles for later versions like 2008.
We can happily query single valued attributes but not description.
Can anyone answer definitively if this can be achieved or not?
Query:
SELECT [Description]
FROM openquery
(ADSI,'SELECT description
FROM ''LDAP://DC=OurDomain,DC=x,DC=y,DC=z''
WHERE objectCategory = ''Computer'''
)
I have domain admin rights across all servers to am able to make changes to settings if required or can escalate a change to associated admin.
I notice there is a service pack 2 for 2008 R2 but can see no mention of any related fixes there.
SQL Server Specks:
@@version
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2550.0 (X64) Jun 11 2012 16:41:53 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy