Could try embedding the username and password into the connection string? Another thing to try might be the SQLXML web service.