Its not just quering AD though, I am getting "Protocol error in TDS Stream" if I use the import wizard to copy tables from another server.

People are reporting errors when...

I can drill down until I hit the tables, when I click the plus on tables I get this:

TITLE: Microsoft SQL Server Management Studio

------------------------------

Failed to retrieve data for this request....

No change, same error message.

EXEC MASTER.sys.sp_testlinkedserver ADSI

SELECT sn, givenname, sAMAccountName, mail, displayName

FROM openquery(ADSI,'

select givenName, sn, employeeID, mail, sAMAccountName, displayName from ''LDAP://OU=CanaanCampus,DC=berkshire,DC=loc''

where objectCategory = ''Person'' and objectClass =...

I don't recall at this time, that was setup well over a year ago.

How would I test this?

HanShi (8/23/2013)

I went in on my sql server today to manually copy some tables to get me by.

I was using the import & export data tool.

I could select my source server(another...

I figured it out. My query on the parameter list dataset was returning a NULL value in the list. This is not supported. After I added the...

How/where in MOSS did you go to edit the parameter option.

I have having the same issues where my default values are setup the same as my available values,...

I am looking to place an image for every record. I did get this solved.

Turns out Report Builder is Case Sensative.

image1.value = "File:" + fields!PhotoPath.value

the field PhotoPath had capital...

Thank you. I will definately read up on this.

That worked beautifully - Thank you.

Now let me see if I understand what you did.

Is the Outer Apply creating a temp table called ds?

Thank you again,

Steve

I am still basic newbie to sql(1 year) how can I create accounts and permissions on a db from dos batch file? If you have a basic example...