What is the best way to give the sql login REPORTUser_Accounting permissions to grant execute permissions to stored procedures and select permissions on views? I think the db_securityadmin database role...

Thanks Sue. Your response helped. I may be making this too confusing but just trying to trace the SSRS Report Manager datasource login during report execution.

Sue: Data source credentials are...

Luis Cazares (6/14/2016)

---

The developer should be able to read, at least in non-production environments to create stored procedures which would be deployed to production to apply a more strict...

Windows authentication.

Spiff,

Thanks for the excellent responses.

Kevin

Two other items, I am researching:

I read that Report Manager has a quirk and you should run it in administrator mode for all the features to work. To do this...

Thanks Sean. Yes, I am going to do my own research. Maybe I should have worded it "Does anyone have any experience with such tools? Would you be willing to...

I went through the process of installing SQL Server 2014 EE, SQL Server 2014 SP1, SSAS Multi-Dimensional Mode (Default Instance), SSAS TABULAR (Named Instance) and Data Quality Services. I DID...

Thanks Phil for being so thorough with your responses. Btw, question 4 was listed at the end of question 3.

Thanks Phil. Just want to make sure I understand this redeployment of projects using Project Deployment. This is new to me. I have also added two Project Versioning question.

For example,...

Thanks Perry. To your question, "Do you only want certain tables copied, not the whole database?" Yea, there maybe 50 tables on FG A and 10 Tables on FG B.

FYI - I have found the solution.

Go into Integration Services Dashboard. In the 'Other Integration Services Reports' Box, click All Executions, click Filter, under Start Time Range Label, click inside...

Just looking for some more information on my original post. It does look like if I just add the developer's windows group to the SSISDB without giving them any permissions,...

Thanks Martin for clearing this up for me. I am new to the SSAS scene.

I am going to make another post regarding "separation of duties between DBAs and Developers when...

Sorry, meant to state that we are running SQL Server 2014 EE SP1.