I have a report that runs with no problems in visual studio.net with a sql server 2005 database unnamed instance. But when I try to use a named instance (LLCA1-ITE51218\SS2K5) the login fails.
I specify all the parameters to the TableLogOnInfo class, but the logon fails when I set the
Location property of the TableLogonInfo object. I specify the non-named instance, and it runs with no problems.
Does anyone have any experience with this?