locked
Add SQL Server login to SSRS publisher role? RRS feed

  • Question

  • I created a sql server login (Not domain account) in SQL Server 2008 R2. Is it possible to assign this login, SSRS publisher role? Or is it only possible to give domain logins this permission?

    thanks in Advance!

    Monday, April 8, 2013 9:14 PM

Answers

  • Hello,

    SQL Server Reporting Services uses role-based authorization and an authentication subsystem to determine who can perform operations and access items on a report server. Authentication is based on built-in Windows Authentication by default and the predefined roles can be only assigned to local or domain account.

    You can also use a  custom authentication module with custom forms-based authentication extension that you provide.
    For more information, please see:Authentication with the Report Server

    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    • Proposed as answer by Olaf HelperMVP Wednesday, April 10, 2013 5:25 AM
    • Marked as answer by Fanny Liu Monday, April 15, 2013 1:16 AM
    Wednesday, April 10, 2013 2:05 AM

All replies

  • Hi,

    Role can be assigned only with domain or local account.

    Why do you need this? maybe we will be able to help you if you explain little bit more.

    Zdenek


    Please mark as helpful and propose as answer if you find this as correct. nosekz.eu

    Monday, April 8, 2013 11:05 PM
  • Hello,

    SQL Server Reporting Services uses role-based authorization and an authentication subsystem to determine who can perform operations and access items on a report server. Authentication is based on built-in Windows Authentication by default and the predefined roles can be only assigned to local or domain account.

    You can also use a  custom authentication module with custom forms-based authentication extension that you provide.
    For more information, please see:Authentication with the Report Server

    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    • Proposed as answer by Olaf HelperMVP Wednesday, April 10, 2013 5:25 AM
    • Marked as answer by Fanny Liu Monday, April 15, 2013 1:16 AM
    Wednesday, April 10, 2013 2:05 AM