The report server was unable to validate the integrity of encrypted data
up vote
1
down vote
favorite
The report server was unable to validate the integrity of encrypted data in the database. (rsCannotValidateEncryptedData) .
Could not restore the encryption key, so I deleted the keys and tried to regenerate with rskeymngt with no luck. Getting
'The report server was unable to validate the integrity of encrypted
data in the database. (rsCannotValidateEncryptedData)'
I get that error when accessing http://localhost/ReportServer and when running rskeymgmt -s.
Not sure what next step to take. I have reports that users need to access.
sql-server encryption reporting-services sql-server-2016 edited Sep 13 '17 at 19:23
TT.
12.2k63161
asked Sep 13 '17 at 17:52
sqllearner
6619
add a comment |
up vote
1
down vote
favorite
The report server was unable to validate the integrity of encrypted data in the database. (rsCannotValidateEncryptedData) .
Could not restore the encryption key, so I deleted the keys and tried to regenerate with rskeymngt with no luck. Getting
'The report server was unable to validate the integrity of encrypted
data in the database. (rsCannotValidateEncryptedData)'
I get that error when accessing http://localhost/ReportServer and when running rskeymgmt -s.
Not sure what next step to take. I have reports that users need to access.
sql-server encryption reporting-services sql-server-2016 edited Sep 13 '17 at 19:23
TT.
12.2k63161
asked Sep 13 '17 at 17:52
sqllearner
6619
What version of SQL Server are you suing?
– sadmicrowave
Sep 13 '17 at 18:10
Sql server 2016
– sqllearner
Sep 13 '17 at 18:18
Inside rs configuration manager I changed the Report Server Service account and it asked to generate key. I am now getting HTTP Error 503. The service is unavailable.
– sqllearner
Sep 13 '17 at 18:29
I restarted the services and no longer getting the 503 error. I can see the reports but it is asking for data source creds. I enter them and get The ConnectionString property has not been initialized.
– sqllearner
Sep 13 '17 at 18:50
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
The report server was unable to validate the integrity of encrypted data in the database. (rsCannotValidateEncryptedData) .
Could not restore the encryption key, so I deleted the keys and tried to regenerate with rskeymngt with no luck. Getting
'The report server was unable to validate the integrity of encrypted
data in the database. (rsCannotValidateEncryptedData)'
I get that error when accessing http://localhost/ReportServer and when running rskeymgmt -s.
Not sure what next step to take. I have reports that users need to access.
sql-server encryption reporting-services sql-server-2016 edited Sep 13 '17 at 19:23
TT.
12.2k63161
asked Sep 13 '17 at 17:52
sqllearner
6619
The report server was unable to validate the integrity of encrypted data in the database. (rsCannotValidateEncryptedData) .
Could not restore the encryption key, so I deleted the keys and tried to regenerate with rskeymngt with no luck. Getting
'The report server was unable to validate the integrity of encrypted
data in the database. (rsCannotValidateEncryptedData)'
I get that error when accessing http://localhost/ReportServer and when running rskeymgmt -s.
Not sure what next step to take. I have reports that users need to access.
sql-server encryption reporting-services sql-server-2016 sql-server encryption reporting-services sql-server-2016 edited Sep 13 '17 at 19:23
TT.
12.2k63161
asked Sep 13 '17 at 17:52
sqllearner
6619
edited Sep 13 '17 at 19:23
TT.
12.2k63161
asked Sep 13 '17 at 17:52
sqllearner
6619
edited Sep 13 '17 at 19:23
TT.
12.2k63161
edited Sep 13 '17 at 19:23
TT.
12.2k63161
edited Sep 13 '17 at 19:23
TT.
12.2k63161
12.2k63161
asked Sep 13 '17 at 17:52
sqllearner
6619
asked Sep 13 '17 at 17:52
sqllearner
6619
asked Sep 13 '17 at 17:52
sqllearner
6619
6619
What version of SQL Server are you suing?
– sadmicrowave
Sep 13 '17 at 18:10
Sql server 2016
– sqllearner
Sep 13 '17 at 18:18
Inside rs configuration manager I changed the Report Server Service account and it asked to generate key. I am now getting HTTP Error 503. The service is unavailable.
– sqllearner
Sep 13 '17 at 18:29
I restarted the services and no longer getting the 503 error. I can see the reports but it is asking for data source creds. I enter them and get The ConnectionString property has not been initialized.
– sqllearner
Sep 13 '17 at 18:50
add a comment |
What version of SQL Server are you suing?
– sadmicrowave
Sep 13 '17 at 18:10
Sql server 2016
– sqllearner
Sep 13 '17 at 18:18
Inside rs configuration manager I changed the Report Server Service account and it asked to generate key. I am now getting HTTP Error 503. The service is unavailable.
– sqllearner
Sep 13 '17 at 18:29
I restarted the services and no longer getting the 503 error. I can see the reports but it is asking for data source creds. I enter them and get The ConnectionString property has not been initialized.
– sqllearner
Sep 13 '17 at 18:50
What version of SQL Server are you suing?
– sadmicrowave
Sep 13 '17 at 18:10
What version of SQL Server are you suing?
– sadmicrowave
Sep 13 '17 at 18:10
Sql server 2016
– sqllearner
Sep 13 '17 at 18:18
Sql server 2016
– sqllearner
Sep 13 '17 at 18:18
Inside rs configuration manager I changed the Report Server Service account and it asked to generate key. I am now getting HTTP Error 503. The service is unavailable.
– sqllearner
Sep 13 '17 at 18:29
Inside rs configuration manager I changed the Report Server Service account and it asked to generate key. I am now getting HTTP Error 503. The service is unavailable.
– sqllearner
Sep 13 '17 at 18:29
I restarted the services and no longer getting the 503 error. I can see the reports but it is asking for data source creds. I enter them and get The ConnectionString property has not been initialized.
– sqllearner
Sep 13 '17 at 18:50
I restarted the services and no longer getting the 503 error. I can see the reports but it is asking for data source creds. I enter them and get The ConnectionString property has not been initialized.
– sqllearner
Sep 13 '17 at 18:50
add a comment |
3 Answers
3
active
oldest
votes
up vote
4
down vote
Restarted the services and now everything is working.
So it looks like in order to generate a new key I need to update the Report Server Service account. After that restart the sql server reporting services.
I no longer have the encryption error, but now I am asked for a log in to the data source after clicking on the report. I enter the creds again but get 'The ConnectionString property has not been initialized.'
answered Sep 13 '17 at 18:44
sqllearner
6619
add a comment |
up vote
1
down vote
You just need to change database again if you already created then your problem will be solved.
edited Aug 28 at 9:14
Uwe Keim
27.3k30128210
answered Jul 16 at 14:27
Rohit Dodiya
13113
add a comment |
up vote
0
down vote
I went into SSRS Configuration Manager > Encryption Keys > click Delete.
When I did that I got an error
Failed to delete the encryption conent in the report server database. Please exexcute the "DeleteEncryptedContent" stored procedre o nthe database manually.
Opened SQL Serrver Mgmt Studio > Report Server > new query:
exec DeleteEncryptedContent
Restart the service and its working.
answered Nov 19 at 0:21
Jeremy Thompson
39k13102198
add a comment |
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
4
down vote
Restarted the services and now everything is working.
So it looks like in order to generate a new key I need to update the Report Server Service account. After that restart the sql server reporting services.
I no longer have the encryption error, but now I am asked for a log in to the data source after clicking on the report. I enter the creds again but get 'The ConnectionString property has not been initialized.'
answered Sep 13 '17 at 18:44
sqllearner
6619
add a comment |
up vote
4
down vote
Restarted the services and now everything is working.
So it looks like in order to generate a new key I need to update the Report Server Service account. After that restart the sql server reporting services.
I no longer have the encryption error, but now I am asked for a log in to the data source after clicking on the report. I enter the creds again but get 'The ConnectionString property has not been initialized.'
answered Sep 13 '17 at 18:44
sqllearner
6619
add a comment |
up vote
4
down vote
up vote
4
down vote
Restarted the services and now everything is working.
So it looks like in order to generate a new key I need to update the Report Server Service account. After that restart the sql server reporting services.
I no longer have the encryption error, but now I am asked for a log in to the data source after clicking on the report. I enter the creds again but get 'The ConnectionString property has not been initialized.'
answered Sep 13 '17 at 18:44
sqllearner
6619
Restarted the services and now everything is working.
So it looks like in order to generate a new key I need to update the Report Server Service account. After that restart the sql server reporting services.
I no longer have the encryption error, but now I am asked for a log in to the data source after clicking on the report. I enter the creds again but get 'The ConnectionString property has not been initialized.'
answered Sep 13 '17 at 18:44
sqllearner
6619
edited Sep 13 '17 at 20:16
answered Sep 13 '17 at 18:44
sqllearner
6619
answered Sep 13 '17 at 18:44
sqllearner
6619
answered Sep 13 '17 at 18:44
sqllearner
6619
6619
add a comment |
add a comment |
up vote
1
down vote
You just need to change database again if you already created then your problem will be solved.
edited Aug 28 at 9:14
Uwe Keim
27.3k30128210
answered Jul 16 at 14:27
Rohit Dodiya
13113
add a comment |
up vote
1
down vote
You just need to change database again if you already created then your problem will be solved.
edited Aug 28 at 9:14
Uwe Keim
27.3k30128210
answered Jul 16 at 14:27
Rohit Dodiya
13113
add a comment |
up vote
1
down vote
up vote
1
down vote
You just need to change database again if you already created then your problem will be solved.
edited Aug 28 at 9:14
Uwe Keim
27.3k30128210
answered Jul 16 at 14:27
Rohit Dodiya
13113
You just need to change database again if you already created then your problem will be solved.
edited Aug 28 at 9:14
Uwe Keim
27.3k30128210
answered Jul 16 at 14:27
Rohit Dodiya
13113
edited Aug 28 at 9:14
Uwe Keim
27.3k30128210
edited Aug 28 at 9:14
Uwe Keim
27.3k30128210
edited Aug 28 at 9:14
Uwe Keim
27.3k30128210
27.3k30128210
answered Jul 16 at 14:27
Rohit Dodiya
13113
answered Jul 16 at 14:27
Rohit Dodiya
13113
answered Jul 16 at 14:27
Rohit Dodiya
13113
13113
add a comment |
add a comment |
up vote
0
down vote
I went into SSRS Configuration Manager > Encryption Keys > click Delete.
When I did that I got an error
Failed to delete the encryption conent in the report server database. Please exexcute the "DeleteEncryptedContent" stored procedre o nthe database manually.
Opened SQL Serrver Mgmt Studio > Report Server > new query:
exec DeleteEncryptedContent
Restart the service and its working.
answered Nov 19 at 0:21
Jeremy Thompson
39k13102198
add a comment |
up vote
0
down vote
I went into SSRS Configuration Manager > Encryption Keys > click Delete.
When I did that I got an error
Failed to delete the encryption conent in the report server database. Please exexcute the "DeleteEncryptedContent" stored procedre o nthe database manually.
Opened SQL Serrver Mgmt Studio > Report Server > new query:
exec DeleteEncryptedContent
Restart the service and its working.
answered Nov 19 at 0:21
Jeremy Thompson
39k13102198
add a comment |
up vote
0
down vote
up vote
0
down vote
I went into SSRS Configuration Manager > Encryption Keys > click Delete.
When I did that I got an error
Failed to delete the encryption conent in the report server database. Please exexcute the "DeleteEncryptedContent" stored procedre o nthe database manually.
Opened SQL Serrver Mgmt Studio > Report Server > new query:
exec DeleteEncryptedContent
Restart the service and its working.
answered Nov 19 at 0:21
Jeremy Thompson
39k13102198
I went into SSRS Configuration Manager > Encryption Keys > click Delete.
When I did that I got an error
Failed to delete the encryption conent in the report server database. Please exexcute the "DeleteEncryptedContent" stored procedre o nthe database manually.
Opened SQL Serrver Mgmt Studio > Report Server > new query:
exec DeleteEncryptedContent
Restart the service and its working.
answered Nov 19 at 0:21
Jeremy Thompson
39k13102198
answered Nov 19 at 0:21
Jeremy Thompson
39k13102198
answered Nov 19 at 0:21
Jeremy Thompson
39k13102198
answered Nov 19 at 0:21
Jeremy Thompson
39k13102198
39k13102198
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f46203955%2fthe-report-server-was-unable-to-validate-the-integrity-of-encrypted-data%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
What version of SQL Server are you suing?
– sadmicrowave
Sep 13 '17 at 18:10
Sql server 2016
– sqllearner
Sep 13 '17 at 18:18
Inside rs configuration manager I changed the Report Server Service account and it asked to generate key. I am now getting HTTP Error 503. The service is unavailable.
– sqllearner
Sep 13 '17 at 18:29
I restarted the services and no longer getting the 503 error. I can see the reports but it is asking for data source creds. I enter them and get The ConnectionString property has not been initialized.
– sqllearner
Sep 13 '17 at 18:50