Post reply

Server Type in SMS?

  • January 21, 2011 at 8:41 am

    #230704

    I am trying to set permissions on the reporting server but this server type is not available in the Server Management Studio.

    What should I do?

  • January 21, 2011 at 8:49 am

    #1276605

    Ask your DBA.

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • January 21, 2011 at 8:56 am

    #1276610

    I am the DBA 😀

  • January 21, 2011 at 9:11 am

    #1276620

    Is this SSRS 2008, SSRS 2005, IIS, or something else that you are trying to set permissions on?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • January 21, 2011 at 9:36 am

    #1276635

    SSRS 2008.

    Also, I think all of the server instances share the same instance ID, would that be a problem and can I change that if it is or do I have to reset?

  • January 21, 2011 at 9:45 am

    #1276644

    Multiple SQL instances don't share the same id. One SSRS instance per server is allowed.

    Perms for SSRS 2008 are not performed through SSMS. You have to connect to the SSRS site as an admin and then configure perms.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • January 21, 2011 at 9:54 am

    #1276656

    In the books online it says that the perms are performed through ssms. That you can change the server type to reporting server 🙁

  • January 21, 2011 at 10:02 am

    #1276662

    Are you looking at the correct reference?

    You can look at the SSRS instance by clicking the connect tab in the object explorer and selecting reporting services. Then you can connect to an SSRS instance.

    As for perms to see reports in SSRS 2008 you have to set those through the SSRS admin site. You can add users in SSMS to have database permissions on the reporting databases but not to manage reporting permissions.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • January 21, 2011 at 10:29 am

    #1276673

    That's exactly what I am saying, the 'reporting service' is not in the connect list. 🙁

    I don't know what's wrong or if I set it up wrong.

  • January 21, 2011 at 10:33 am

    #1276680

    Did you install reporting services and the business intelligence stuff when you installed?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • January 21, 2011 at 10:49 am

    #1276689

    I'm pretty sure you don't even need to install BIDS to be able to connect to reporting services via SSMS.

    That said, what permissions exactly are you trying to set? You can't do very much through SSMS for SSRS 2008+..it's almost exclusively through the web console now (moving to sharepoint-style administration).

  • January 21, 2011 at 1:08 pm

    #1276757

    Yes, I installed everything. SQL Server 2008 R2 Express with Advanced Settings.

  • January 21, 2011 at 1:10 pm

    #1276759

    Derrick Smith (1/21/2011)

    I'm pretty sure you don't even need to install BIDS to be able to connect to reporting services via SSMS.

    That said, what permissions exactly are you trying to set? You can't do very much through SSMS for SSRS 2008+..it's almost exclusively through the web console now (moving to sharepoint-style administration).

    I tried the web settings and added myself as a sysadmin and user and I can't access the reports outside of firefox, not even in IE 8.0.

  • January 21, 2011 at 1:13 pm

    #1276760

    K. Express is a different beast. Try this resource and see if it has something of use for you.

    http://technet.microsoft.com/en-us/library/ms365166.aspx">

    http://technet.microsoft.com/en-us/library/ms365166.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • January 21, 2011 at 2:05 pm

    #1276793

    CirquedeSQLeil (1/21/2011)

    K. Express is a different beast. Try this resource and see if it has something of use for you.

    http://technet.microsoft.com/en-us/library/ms365166.aspx">

    http://technet.microsoft.com/en-us/library/ms365166.aspx

    Dude! Thanks a million! That helped so much 🙂

    Now all I have to do is learn how to give access reporting server to my co-workers on the same domain. :crazy:

    C.

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply