Your point is well taken. I happen to have a sandbox to change the web.config on the fly to generate the mapping. I would not consider multiple connection...

Thank you very much for the useful pointer. I never looked up nor knew that the connection string could have a keyword "Application Name". I will certainly code...

Craig,

Cool! That works. Thank you!

Thank you very much for your guidance and assistance. It works perfectly.

As for the way I ask questions, I was once kindly and gently trained by this forum to...

Thank you, Paul. Your solution is neat and easier to read.

Thanks!

Thanks, that was exactly what we were contemplating.

By looking at your Excel worksheet as sample, I think the matrix(ssrs2005) is more suitable to what you are trying to achieve.

http://www.simple-talk.com/sql/sql-server-2005/advanced-matrix-reporting-techniques/

There is a tablix in SSRS...

Jeff,

I don't know how to get an ascii dump of a string from a particular column so I can't accurately say what characters they are.

Visually, it has spacing wider than...

The concatenated string is a comment. The comment is about machines. There is already a machine table and each machine has its machine id. The machine comment...

Thanks, GSquared. It seems to add some extra characters when concatenating. I only want a white space between the lines but it appears that it adds something else.

Thanks to everyone for the help. It turned out to be a mutiple hops issue and my company does not use Kerberos. Thanks!

SSMS for the ADsDSOObject exists on the list of providers.

security set on the ADSI linked server is use identity

where the identity is a domain service account that can read Active...

Is there a way to find out if Active Directory provider is installed on the SQL server box? (find out if Adsldp.dll, Adsldpc.dll, Adsmsext.dll, and Activeds.dll exist?)

Also our group has...