June 18, 2012 at 10:06 am
Hi everyone,
I am quite knew to reporting services. I want to connect to Reporting Services in SQL Server Management Studio but I can't find the rigth credentials to do this.
Is there an equivalence to the sa user in reporting services? How can I find the admin to use to connect to reporting services and be able to do everything?
I am a litle bit confuse.
Best regards.
Carl
June 18, 2012 at 11:29 am
Solved! I finally found that launching SSIS with the RUN AS ADMINISTRATOR enabled me to connect with the rigth credentials.
Weird that this behavior of SSRS is different from the one of SQL Server.
Best regards.
Carl
June 20, 2012 at 2:28 am
SSRS is Windows only authentication, if you dont have System Administrator access to the reporting services webpage then you cant login via SSMS to Reporting Services.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply