Hello Everyone<\/p>\n
Got a weird one for you.\u00a0 Installed SQL Server Enterprise Edition 2012 from my MSDN account, SP1, running on Windows 8.\u00a0 Using SSRS in NATIVE mode.\u00a0 Configuration wizard works excellent, setup the system.\u00a0 Browse to the URL for the system, I’m presented with a login box, I used my local login account credentials which are in the Administrator group on the box, and I get PERMISSION DENIED on the user account.\u00a0<\/p>\n
I close IE, go to the URL again, presented with the login box, enter ADMINISTRATOR and the administrator account password on the box, and I’m presented with the SSRS home page.\u00a0 From this point I go to site Settings, check the security, see the only group listed is BUILTIN\\ADMINISTRATORS configured as a System Administrator of the SSRS.\u00a0 I add my local user account as a System Administrator, a few of the other groups I’ve created to test some configurations I am working on.\u00a0 Close the browser, login to the site again, this time using my local account, which I’ve just added to the system as a system administrator.\u00a0 I get PERMISSION DENIED on the SSRS site.<\/p>\n
Close IE again, open, and re login as the Administrator to the site…I go to SITE SETTINGS to check security configuration and NOTHING comes up on the screen, just the header for the settings page, but no other content.\u00a0 Can’t change anything can’t update anything…can’t see anything.\u00a0<\/p>\n
I restart the service, restart the computer, check the reporting services configuration from the SQL MANAGEMENT STUDIO nothing changes.<\/p>\n
Login to the site using FIREFOX (newest release..although I don’t think it is a version issue) and I login to the site with my ADMINISTRATOR account, I get the screens I think I should be seeing, all site settings, all report configuration options…everything…as it is supposed to be.\u00a0 I login as my USER account which is still showing designated as an ADMINISTRATOR of the SSRS…and I get PERMISSION DENIED.<\/p>\n
UAC has been turned off…so that it doesn’t notify any more.\u00a0 All updates are installed for SQL server. I’ve uninstalled the reporting services, and re-installed it…deleted the database, and created a new one…all of this is the same.\u00a0 I can use the site once as the ADMINISTRATOR of my workstation, through IE…after that…nothing.\u00a0 Clearing the cache doesn’t work, IISRESET doesn’t work.\u00a0 Not sure what else I should try, other than to completely scrap the SQL 2012 Enterprise SP1 install, and re-install from scratch with the DEVELOPER Edition…<\/p>\n
Any thoughts.<\/p>\n
thanks<\/p>\n
john<\/p>\n
John Wildes | Hitachi Data Systems | Director – Microsoft Technologies | Converged Platforms<\/p>\n","protected":false},"excerpt":{"rendered":"
Hello Everyone Got a weird one for you.\u00a0 Installed SQL Server Enterprise Edition 2012 from my MSDN account, SP1, running on Windows 8.\u00a0 Using SSRS in NATIVE mode.\u00a0 Configuration wizard works excellent, setup the system.\u00a0 Browse to the URL for the system, I’m presented with a login box, I used my local login account credentials […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-6597","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/6597","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=6597"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/6597\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=6597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=6597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=6597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}