SQL Server Reports Connection Password Problem

  • Morning!

    I've currently created a large number of reports, all of which use the same Shared Data Source.  Everything worked fine until the password for the logon was changed so that it contained a speech mark ( " ) and now an invalid connecton string occurs! I've managed to overcome the problem by creating a custom data source for each report via the web based admin tool, but does anyone know if the problem can be sorted within the report design environment \ Shared Data Source??  I know the best thing to do would be to change the password, but this is not as easy as it sounds due to the same logon being used by a number of systems, and there is a reluctance to create a new logon for Reporting Purposes .

    Thanks in advance

    Mike

  • This was removed by the editor as SPAM

  • MY guess is that the connection string defined for the shared data source is wrapped in double quotes (") when passed to the web service so having the double quote in the password is terminating it early.  So you would get something like "Server=test;Database=test;user name=user;pwd=use"r" so you are missing the end of the password.  Maybe you could try escaping the ".  I don't know if it will work, but it seems to be logical.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply