RE: cannot log into Reporting Services from SMSS

Hello Ed,

You could try the following steps to grant a login in SQL Server with
sysadmin role:

In SQL Management studio, select Server name->Security->Logins, and right
click the login->Properties->Server roles

Check "sysadmin" role.

Please add a domain user as a new login and grant it sysadmin role.

I'd like to know in database setup if you change the type to Windows
credential, and use the domain user you configure in above step, what's the
exact error message you encounter?

Also, you may want to temporiarily grant "Nt authority/network service"
account with sysadmin role, can you see any difference if you access
http://servername/reportserver?

Please confirm you installed default instance of RS, if it's a named
instance, you need to connect to

http://servername/reportserver$instancename as mentioned by william.

Please let's know if you have any update, please feel free to let's know.
Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


=====================================================

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • Re: dbackupoperators
    ... > You could create a user in master for the login and grant EXEC permissions ... >> I found that I might need to grant sysadmin role to the user profile. ...
    (microsoft.public.sqlserver.server)
  • Re: Other way of Changing Password if does not have Server Role
    ... A user can change his password without being a member of the sysadmin role. ... You just have to login as the user and then omit the 3rd parameter ... Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • RE: cannot log into Reporting Services from SMSS
    ... When you say in SMSS select Server name...Server roles, ... "sysadmin" role was already checked for that login. ... I installed the ReportServer as part of a full installation of SQL Server ... Please add a domain user as a new login and grant it sysadmin role. ...
    (microsoft.public.sqlserver.connect)
  • Re: losing sysadmin (Thanks)
    ... >login as SA. ... >> 1)My SQL Server is in Mixed Authentication Mode. ... >> 4)Now I changed the Mixed Authentication Mode to Windows ... >> now I don't have a sysadmin role. ...
    (microsoft.public.sqlserver.security)
  • Re: losing sysadmin
    ... >login as SA. ... >> 1)My SQL Server is in Mixed Authentication Mode. ... >> 4)Now I changed the Mixed Authentication Mode to Windows ... >> now I don't have a sysadmin role. ...
    (microsoft.public.sqlserver.security)
Loading