Lynn Pettis (4/29/2013)
The proper connection string was:
Data Source=SQL04\SS2008R2;Initial Catalog=MYTESTDB
Thanks to those who replied.
So the fix was removing the spaces in your original connection string?
Actually it was more embarrising then that. The orginal example provded was :
Data Source=localhost\MSSQL10_50.InstanceName; Initial Catalog= AdventureWorks
I subsititied each piece for what I thought needed to be subsitiuted and so I had this:
Data Source=SQL04\MSSQL10_50.SS2008R2; Initial Catalog= MYTESTDB
It was only after I removed the 'MSSQL10_50.' piece that it finally worked. In my opinion that piece did not look like it was part of the instance name exxample but a fixed piece to perhaps designate SQL version or something.
All in all the whole SSRS thing is very confusing as I come from a CRYSTAL REPORTS & MS ACCESS Report writing back ground . I want very much to embrace the use of SSRS but each time I try its more and more frustration from how difficult it is to make a simple report to how it all fits togethere. Its almost as bad as trying to learn SSIS after having used DTS. GRRRRHHH.
Kindest Regards,Just say No to Facebook!