cannot log into Reporting Services through the Studio

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SQL Programmer - 02 Jul 2008 21:02 GMT

Hello:

The Initialization button in Report Configuration Manager is grayed out, and
we cannot login to Reporting Services through the SQL 2005 Studio. Upon
trying to do so, we get a very lengthy very crypt error message mentioning
ROBOTS = to this or that and a lot of other language that probably only a
Star Wars robot could in fact interpret. LOL!!!

TCP/IP is on, I'm an administrator, I'm logging in with the right
credentials, yadda, yadda, etc, etc.

Is reinstalling the only option at this point? IIS and SQL are on two
separate boxes. So, if I choose to remove SQL from the IIS box, it's not
going to have an effect on SQL on the SQL box is it?

SQL Programmer (it's just a name)

Reply to this Message

Bruce L-C [MVP] - 02 Jul 2008 22:07 GMT

What machine are you point the Report Configuration Manager? The one with
the SQL Server databases or the one with RS installed on it. Whichever one
you are doing try the other one (both are on the same server for me).

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> Hello:
>
[quoted text clipped - 13 lines]
>
> SQL Programmer (it's just a name)

Reply to this Message

childofthe1980s - 08 Jul 2008 16:26 GMT

No, that did not work either.

> What machine are you point the Report Configuration Manager? The one with
> the SQL Server databases or the one with RS installed on it. Whichever one
[quoted text clipped - 17 lines]
> >
> > SQL Programmer (it's just a name)

Reply to this Message

Bruce L-C [MVP] - 08 Jul 2008 16:52 GMT

You say you are an adminstrator. What are you an administrator on? Are you
an adminstrator on the SQL Server database?

It is not enough to be an administrator on the box running RS. You need
admin rights on SQL Server database.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> No, that did not work either.
>
[quoted text clipped - 25 lines]
>> >
>> > SQL Programmer (it's just a name)

Reply to this Message

childofthe1980s - 08 Jul 2008 20:13 GMT

I'm an admin on both.

> You say you are an adminstrator. What are you an administrator on? Are you
> an adminstrator on the SQL Server database?
[quoted text clipped - 31 lines]
> >> >
> >> > SQL Programmer (it's just a name)

Reply to this Message

Bruce L-C [MVP] - 08 Jul 2008 20:16 GMT

I'm afraid I don't have any ideas for you.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> I'm an admin on both.
>
[quoted text clipped - 38 lines]
>> >> >
>> >> > SQL Programmer (it's just a name)

Reply to this Message