RE: cannot log into Reporting Services from SMSS

When you say in SMSS select Server name...Server roles, there are seven
logins listed. One of them is sa, which is what I assume you were talking
about. "sysadmin" role was already checked for that login.

I don't know how to "add a domain user". I've tried to add a new login, but
was unsuccessful mostly because I'm not familiar with the process.

In Reporting Services Configuration Manager, when I change Credentials Type
to Windows Credentials, I leave the Account Name and Password blank. It
responds:

Number of errors: 0
* There was a failure applying your change.
You need to specify the database name and the server name to run the
selected task(s).

I've left the server name as before (ASUS2), and the database name is
ReportServer.

I installed the ReportServer as part of a full installation of SQL Server
2005--I'm sure I did not ask for a named instance --I generally used the
defaults during installation.
--
Ed


""Peter Yang[MSFT]"" wrote:

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: SBS 3003 Premium - 2 NIC w/ Hardware Firewall
    ... I understand that opening ports to allow external login access also allows ... I've been looking to tighten up our installation to keep them out, ... the physical server hardware - hence the original post here. ... I never realized I had ISA 2000 as part of my SBS 2003 Premium ...
    (microsoft.public.windows.server.sbs)
  • help needed in processing Remote OS installation operation ...
    ... i posted a question on computer.net...it's about "remote OS ... client computer is able to link up to the server(win2k adv server) and ... the problem is that i jus couldn't login using the accounts that i ...
    (microsoft.public.win2000.setup)
  • Re: A novice having trouble with X window on install
    ... > I'm in the midst of my first ever installation of Debian and I'm having ... > can login OK, both as the normal user I created and as root. ... > I cannot start the X server. ... > I pick Yes and give the root password. ...
    (Debian-User)
  • Re: Cant install sqlserver 2000
    ... However, when I view server explorer, ... after a bunch of databases I get servers. ... Login dennist685 ... >>installation. ...
    (microsoft.public.sqlserver.server)
  • Re: Access 2007 and ADP to SQL Server 2005 in Vista
    ... If you try to connect to the server as "SA" or a different login with ... sysadmin role as Sylvain mentioned, ... If you create a new database other than connect to a existing database, ...
    (microsoft.public.access.adp.sqlserver)