New answers tagged ssrs
Your server has to be a member of the SharePoint farm before it will allow you to install SSRS in integrated mode. Refer to this article for more information.
When adding the parameter from SQL Server data tools 2012, experiment with the parameter visibility in the report parameter properties dialog (see screen shot below) - Visible | Hidden | Internal. Once deployed, you can also set report parameter visibility from Report Manager. To change the visibility, view the report properties, select parameters and set ...
I solved my own problem. I needed to grant data reader rights to that database for the user. I do that by right clicking the user name under Security\Logins and choosing properties. In there I go to User Mapping. Make sure the user is mapped to the database being queried and under the Database Role Membership make sure db_datareader is checked.
I would go back to testing and find out why the SID migration did not work. It is a migration Microsoft supports with Active Directory. I would suggest engaging the support for the Data Center you are moving to for assistance. (or even Microsoft...) If the SIDs cannot be fixed your only option is going to be recreating the accounts and permissions. Thinking ...
The issue had to due with Windows GPO it was unknown to me at the time http://technet.microsoft.com/en-us/library/bb326317%28v=sql.90%29.aspx
Top 50 recent answers are included