Showing posts with label SQL 2016. Show all posts
Showing posts with label SQL 2016. Show all posts

Tuesday, July 04, 2017

SSRS list view bug in Internet Explorer 11 with SQL 2016 SP1 CU3 update

Issue: 
If you happen use SSRS with IE 11 and you have SQL 2016 SP1 with CU3 installed and then try to switch to 'list view' you'll get an error message about could not load folder contents


Workaround:
Go back and just use 'Tile View' or  switch to Chrome (doesn't seem to be affected) or Uninstall CU3 and go back to CU2.

I have reported this to Microsoft but no response yet.

More info:
https://social.technet.microsoft.com/

https://connect.microsoft.com

If you find this article useful please leave me a comment.

Thursday, December 01, 2016

Unable to delete Publication in SQL - Principal dbo does not exist

I found that I couldn't delete a publication in SQL this morning.  Turns out the database needed to have an owner before you can delete a publication.

Sure enough, specifying an owner to the database then allows me to remove publications.

Source:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/44144690-d47b-43a3-b460-cee1f71279a3/could-not-delete-publication?forum=sqlreplication

If you find this article useful please leave me a comment.

Tuesday, November 22, 2016