Link to home
Start Free TrialLog in
Avatar of doughorning
doughorning

asked on

SSRS - "Keyword not supported (rsInternalError)"

Hello,

When we are trying to access our report server at http://localhost/ReportServer it results in an error:  Keyword not supported 'pwd=password!;application name'

When I look in the log it says "Error while initializating configuration from the database: <same message as above>"



Note: The password is actually a mix of uppercase and lowercase and has a ! at the end. When it appears here it shows as all lowercase.

Any ideas on how to resolve this?

Thanks
SOLUTION
Avatar of TempDBA
TempDBA
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of doughorning
doughorning

ASKER

Hi,

I changed the Service Account to NetworkService, restarted, and tried again. Same results.

Note: The password in the error statement is for the Database Account.
Avatar of Nico Bontenbal
When you use this connection string from another application, does it also return an error?

And maybe putting double quotes around the password (or maybe other values in the connection string) might help.
I'm entering the password in the Report Server Configuration. Which config file is it saving the connection string? perhaps i can manually edit it.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Good idea, i'll try that.
I couldn't change the password to an invalid one because it tests the connection in the wizard. However, i discovered that the password actually had a '=' in it. When the user was telling me the the password =password! i thought they were saying "The password is equal to password!". I removed the = and it got rid of that error. So it appears to be a bug in Report Server with how it stores passwords in its config file. Thanks for your help everyone.
Its a nice scenario... Good that you have figured it out. Good luck with your further projects.