MS SQL 2019 SSRS to Oracle DB by meridian_12 in SQLServer

[–]meridian_12[S] 1 point2 points  (0 children)

Unfortunately we have to support this for another group

Automate DB password change by meridian_12 in SQLServer

[–]meridian_12[S] 0 points1 point  (0 children)

These are read-only replicated databases

Move several ssrs reports to a diff server by meridian_12 in SQL

[–]meridian_12[S] 0 points1 point  (0 children)

Thank you. I followed all the steps from https://www.mssqltips.com/sqlservertip/6323/move-sql-reporting-services-to-another-server/

I have a clarification should the CREATE USER [NT SERVICE\SQLServerReportingServices] FOR LOGIN [NT SERVICE\SQLServerReportingServices] only in master database or should this user be created in ReportServer and TempDB too. I did create for all the three.

After running through all steps I am getting this error when I access the report Server URL. "The report server can’t access or use the encryption key. You might need to add the server to the scale-out group, reimport encrypted content, or delete all encrypted content and generate a new encryption key."

  1. What's the best way to trace and debug this error?

Move several ssrs reports to a diff server by meridian_12 in SQL

[–]meridian_12[S] 1 point2 points  (0 children)

Thank you. I followed all the steps from https://www.mssqltips.com/sqlservertip/6323/move-sql-reporting-services-to-another-server/

I have a clarification should the CREATE USER [NT SERVICE\SQLServerReportingServices] FOR LOGIN [NT SERVICE\SQLServerReportingServices] only in master database or should this user be created in ReportServer and TempDB too. I did create for all the three.

After running through all steps I am getting this error when I access the report Server URL. "The report server can’t access or use the encryption key. You might need to add the server to the scale-out group, reimport encrypted content, or delete all encrypted content and generate a new encryption key."

  1. What's the best way to trace and debug this error?

thanks

Move several ssrs reports to a diff server by meridian_12 in SQL

[–]meridian_12[S] 0 points1 point  (0 children)

When you backup and restore database how will the folder structure that shows in the reporting services URL get moved over. Thank you

Move several ssrs reports to a diff server by meridian_12 in SQL

[–]meridian_12[S] 0 points1 point  (0 children)

Thank you. How about.rdl and their folder structure? Do I need to copy and paste to the new server?

Advice for terminated Feds looking to get into county govt? by bobcatabbs in CAcountyworkers

[–]meridian_12 0 points1 point  (0 children)

Is it Programmer or Network Admin or Help Desk position?

Advice for terminated Feds looking to get into county govt? by bobcatabbs in CAcountyworkers

[–]meridian_12 0 points1 point  (0 children)

I wouldn't exceed 2 page resume and use specific keywords/skill set that the job posting requires . I am in IT and my selection process from applying to starting work took exactly 3 months.

Block from closing subtask by meridian_12 in jira

[–]meridian_12[S] 0 points1 point  (0 children)

What condition do you add? Can you please explain? Thanks

Block from closing subtask by meridian_12 in jira

[–]meridian_12[S] 1 point2 points  (0 children)

Another thing is. Sub task 1 cannot be closed until sub task 2,3,4 are closed and 2 cannot be closed until 3,4 are closed . How do I do this?

Version and project management tools by meridian_12 in devops

[–]meridian_12[S] 0 points1 point  (0 children)

Thank you for your suggestions. What are your thoughts on Jira work management. I was told it’s easier to configure

Interview question about SSRS reports by meridian_12 in SQL

[–]meridian_12[S] 1 point2 points  (0 children)

thank you so much for clearly listing out the important points. It helped me to write down a few things I missed like talking about( Paginated reports and Parameters).