can't open Report Manager

Greetings,
I can't open Report Manager (sql Server 2000, win 2003 server). I log into
our server as SA where Reporting Services is/was installed (I did not perform
the install). I go to start/Programs/Microsoft Sql Server/Reporting
Services/Report Manager. This brings up a page that has an http error of
403. It says that IE can connect to the website but that IE doesn't have the
permission to access the webpage (http://myserver/Reports).
I looked at IIS and see the Reports virtual directory under Default
Websites (and the pages virtual dir, Folder.aspx...). The directory security
is set for Integrated Windows Security.
What can I do or what do I need to do so that I can access the Report
Manager webpage? Do I need to configure something in IE or IIS? Or is it
possible that the page isn't really there (bad install)?
Thanks
RichFirst off. Win 2003 server has extra security as far as IE is concerned.
This can make it problematic to connect via IE to the report server when you
are physically on the server. You are better off to do the following.
1. Add your account to the local administrator group
2. From your computer use http://yourserver.blah.com/reports and see what
comes up.
RS is an asp.net application. That is what you are logging into, NOT SQL
Server. So logging in with SA only works if the local administrator group on
the server has a user called SA. Otherwise, it knows nothing about SA. If
your local group has that in it then the issue is the added IE security. You
need to add the computer to the list of safe groups (I haven't done this for
awhile). You really are better off to not do this from the server. It is
better and easier to do it from your own PC.
RS uses Role based security. Initially you have a single role of which the
local administrator group is in it (the administrator group).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
> Greetings,
> I can't open Report Manager (sql Server 2000, win 2003 server). I log
> into
> our server as SA where Reporting Services is/was installed (I did not
> perform
> the install). I go to start/Programs/Microsoft Sql Server/Reporting
> Services/Report Manager. This brings up a page that has an http error of
> 403. It says that IE can connect to the website but that IE doesn't have
> the
> permission to access the webpage (http://myserver/Reports).
> I looked at IIS and see the Reports virtual directory under Default
> Websites (and the pages virtual dir, Folder.aspx...). The directory
> security
> is set for Integrated Windows Security.
> What can I do or what do I need to do so that I can access the Report
> Manager webpage? Do I need to configure something in IE or IIS? Or is it
> possible that the page isn't really there (bad install)?
> Thanks
> Rich|||Thank you very much for getting back to me on this. I am just a little
confused though. Last week, I posted a question about caching and execution,
and I was directed to the Report Manager (which - up to that time I knew
nothing about). The instructions were
http://myserver/Reports/Pages/Folder.aspx
Now, you are suggesting that I add my account to the local administrator
group. By my account do you mean my login account that I log into my
workstation or server with - my network account? My account for loging into
the workstation is in the administrator group on the server. Say my network
login is joe123. May I request if you could specify what I have to do to
joe123 so that I can use him as you suggest?
http://joe123.../reports
I appologize in advance for my lack of intuition on this and am very
thankful for your reply and suggestions.
Thanks,
Rich
"Bruce L-C [MVP]" wrote:
> First off. Win 2003 server has extra security as far as IE is concerned.
> This can make it problematic to connect via IE to the report server when you
> are physically on the server. You are better off to do the following.
> 1. Add your account to the local administrator group
> 2. From your computer use http://yourserver.blah.com/reports and see what
> comes up.
> RS is an asp.net application. That is what you are logging into, NOT SQL
> Server. So logging in with SA only works if the local administrator group on
> the server has a user called SA. Otherwise, it knows nothing about SA. If
> your local group has that in it then the issue is the added IE security. You
> need to add the computer to the list of safe groups (I haven't done this for
> awhile). You really are better off to not do this from the server. It is
> better and easier to do it from your own PC.
> RS uses Role based security. Initially you have a single role of which the
> local administrator group is in it (the administrator group).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
> > Greetings,
> >
> > I can't open Report Manager (sql Server 2000, win 2003 server). I log
> > into
> > our server as SA where Reporting Services is/was installed (I did not
> > perform
> > the install). I go to start/Programs/Microsoft Sql Server/Reporting
> > Services/Report Manager. This brings up a page that has an http error of
> > 403. It says that IE can connect to the website but that IE doesn't have
> > the
> > permission to access the webpage (http://myserver/Reports).
> >
> > I looked at IIS and see the Reports virtual directory under Default
> > Websites (and the pages virtual dir, Folder.aspx...). The directory
> > security
> > is set for Integrated Windows Security.
> >
> > What can I do or what do I need to do so that I can access the Report
> > Manager webpage? Do I need to configure something in IE or IIS? Or is it
> > possible that the page isn't really there (bad install)?
> >
> > Thanks
> > Rich
>
>|||Yes you need to use Report Manager but Report Manager is just a asp.net
application that is available from any PC. You do not need to be on the
server itself.
I do mean your login account that you use to log into your server. If your
account is already in the adminstrator group then you are good to go. From
your PC just put this into the URL
http://myserver/Reports/Pages/Folder.aspx
Note, depending on your network you might need to fully qualify the server
as myserver.whatever.com, you can also put the IP address directly like this
http://IPAddress/Pages/Folder.aspx
I very seldom login to my server directly. Either I am deploying reports
from my PC to the server or I am using Report Manager from my PC.
If you login to your server using your network login you can use IE there to
get to report manager but the enhanced security with 2003 server could cause
issues and you need to add the server (yes it is itself but the added
security doesn't know this) to approved security list. That is why I suggest
just doing this from your PC, not from the server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
> Thank you very much for getting back to me on this. I am just a little
> confused though. Last week, I posted a question about caching and
> execution,
> and I was directed to the Report Manager (which - up to that time I knew
> nothing about). The instructions were
> http://myserver/Reports/Pages/Folder.aspx
> Now, you are suggesting that I add my account to the local administrator
> group. By my account do you mean my login account that I log into my
> workstation or server with - my network account? My account for loging
> into
> the workstation is in the administrator group on the server. Say my
> network
> login is joe123. May I request if you could specify what I have to do to
> joe123 so that I can use him as you suggest?
> http://joe123.../reports
> I appologize in advance for my lack of intuition on this and am very
> thankful for your reply and suggestions.
> Thanks,
> Rich
> "Bruce L-C [MVP]" wrote:
>> First off. Win 2003 server has extra security as far as IE is concerned.
>> This can make it problematic to connect via IE to the report server when
>> you
>> are physically on the server. You are better off to do the following.
>> 1. Add your account to the local administrator group
>> 2. From your computer use http://yourserver.blah.com/reports and see what
>> comes up.
>> RS is an asp.net application. That is what you are logging into, NOT SQL
>> Server. So logging in with SA only works if the local administrator group
>> on
>> the server has a user called SA. Otherwise, it knows nothing about SA. If
>> your local group has that in it then the issue is the added IE security.
>> You
>> need to add the computer to the list of safe groups (I haven't done this
>> for
>> awhile). You really are better off to not do this from the server. It is
>> better and easier to do it from your own PC.
>> RS uses Role based security. Initially you have a single role of which
>> the
>> local administrator group is in it (the administrator group).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
>> > Greetings,
>> >
>> > I can't open Report Manager (sql Server 2000, win 2003 server). I log
>> > into
>> > our server as SA where Reporting Services is/was installed (I did not
>> > perform
>> > the install). I go to start/Programs/Microsoft Sql Server/Reporting
>> > Services/Report Manager. This brings up a page that has an http error
>> > of
>> > 403. It says that IE can connect to the website but that IE doesn't
>> > have
>> > the
>> > permission to access the webpage (http://myserver/Reports).
>> >
>> > I looked at IIS and see the Reports virtual directory under Default
>> > Websites (and the pages virtual dir, Folder.aspx...). The directory
>> > security
>> > is set for Integrated Windows Security.
>> >
>> > What can I do or what do I need to do so that I can access the Report
>> > Manager webpage? Do I need to configure something in IE or IIS? Or is
>> > it
>> > possible that the page isn't really there (bad install)?
>> >
>> > Thanks
>> > Rich
>>|||Well, I tried
http://myservername/Reports/Pages/Folder.aspx and got the http 401 error -
unauthorized
I also tried the qualified server name
http://myqualifiedserver.net/Reports/Pages/Folder.aspx
and
http://myqualifiedserver.net/Pages/Folder.aspx
with the same 401 error code
If people are able to get into Report Manager, then I should be able to get
in also. But what is the trick for me? Well, I thank you again for getting
back to me and with your suggestions. Just What is the trick?
Rich
"Bruce L-C [MVP]" wrote:
> Yes you need to use Report Manager but Report Manager is just a asp.net
> application that is available from any PC. You do not need to be on the
> server itself.
> I do mean your login account that you use to log into your server. If your
> account is already in the adminstrator group then you are good to go. From
> your PC just put this into the URL
> http://myserver/Reports/Pages/Folder.aspx
> Note, depending on your network you might need to fully qualify the server
> as myserver.whatever.com, you can also put the IP address directly like this
> http://IPAddress/Pages/Folder.aspx
> I very seldom login to my server directly. Either I am deploying reports
> from my PC to the server or I am using Report Manager from my PC.
> If you login to your server using your network login you can use IE there to
> get to report manager but the enhanced security with 2003 server could cause
> issues and you need to add the server (yes it is itself but the added
> security doesn't know this) to approved security list. That is why I suggest
> just doing this from your PC, not from the server.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
> > Thank you very much for getting back to me on this. I am just a little
> > confused though. Last week, I posted a question about caching and
> > execution,
> > and I was directed to the Report Manager (which - up to that time I knew
> > nothing about). The instructions were
> >
> > http://myserver/Reports/Pages/Folder.aspx
> >
> > Now, you are suggesting that I add my account to the local administrator
> > group. By my account do you mean my login account that I log into my
> > workstation or server with - my network account? My account for loging
> > into
> > the workstation is in the administrator group on the server. Say my
> > network
> > login is joe123. May I request if you could specify what I have to do to
> > joe123 so that I can use him as you suggest?
> >
> > http://joe123.../reports
> >
> > I appologize in advance for my lack of intuition on this and am very
> > thankful for your reply and suggestions.
> >
> > Thanks,
> > Rich
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> First off. Win 2003 server has extra security as far as IE is concerned.
> >> This can make it problematic to connect via IE to the report server when
> >> you
> >> are physically on the server. You are better off to do the following.
> >> 1. Add your account to the local administrator group
> >> 2. From your computer use http://yourserver.blah.com/reports and see what
> >> comes up.
> >>
> >> RS is an asp.net application. That is what you are logging into, NOT SQL
> >> Server. So logging in with SA only works if the local administrator group
> >> on
> >> the server has a user called SA. Otherwise, it knows nothing about SA. If
> >> your local group has that in it then the issue is the added IE security.
> >> You
> >> need to add the computer to the list of safe groups (I haven't done this
> >> for
> >> awhile). You really are better off to not do this from the server. It is
> >> better and easier to do it from your own PC.
> >>
> >> RS uses Role based security. Initially you have a single role of which
> >> the
> >> local administrator group is in it (the administrator group).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
> >> > Greetings,
> >> >
> >> > I can't open Report Manager (sql Server 2000, win 2003 server). I log
> >> > into
> >> > our server as SA where Reporting Services is/was installed (I did not
> >> > perform
> >> > the install). I go to start/Programs/Microsoft Sql Server/Reporting
> >> > Services/Report Manager. This brings up a page that has an http error
> >> > of
> >> > 403. It says that IE can connect to the website but that IE doesn't
> >> > have
> >> > the
> >> > permission to access the webpage (http://myserver/Reports).
> >> >
> >> > I looked at IIS and see the Reports virtual directory under Default
> >> > Websites (and the pages virtual dir, Folder.aspx...). The directory
> >> > security
> >> > is set for Integrated Windows Security.
> >> >
> >> > What can I do or what do I need to do so that I can access the Report
> >> > Manager webpage? Do I need to configure something in IE or IIS? Or is
> >> > it
> >> > possible that the page isn't really there (bad install)?
> >> >
> >> > Thanks
> >> > Rich
> >>
> >>
> >>
>
>|||My guess is that you might be in a administrators group but that group has
not been give administrative rights on the server. Login to that server as
you, check out the local administrators group. If it doesn't let you in to
view it or add to it then you do not have rights on that server. Get someone
who does to either add your specific domain\username to the local
administrator group or add the network administrator group to the local
administrator group.
I bet you don't have the rights to the server that you think you do. By
default, anyone in the local administrators group is in the RS administrator
role.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:80CF0AE5-2E85-4709-93A5-6CAE65398E1A@.microsoft.com...
> Well, I tried
> http://myservername/Reports/Pages/Folder.aspx and got the http 401 error -
> unauthorized
> I also tried the qualified server name
> http://myqualifiedserver.net/Reports/Pages/Folder.aspx
> and
> http://myqualifiedserver.net/Pages/Folder.aspx
> with the same 401 error code
> If people are able to get into Report Manager, then I should be able to
> get
> in also. But what is the trick for me? Well, I thank you again for
> getting
> back to me and with your suggestions. Just What is the trick?
> Rich
> "Bruce L-C [MVP]" wrote:
>> Yes you need to use Report Manager but Report Manager is just a asp.net
>> application that is available from any PC. You do not need to be on the
>> server itself.
>> I do mean your login account that you use to log into your server. If
>> your
>> account is already in the adminstrator group then you are good to go.
>> From
>> your PC just put this into the URL
>> http://myserver/Reports/Pages/Folder.aspx
>> Note, depending on your network you might need to fully qualify the
>> server
>> as myserver.whatever.com, you can also put the IP address directly like
>> this
>> http://IPAddress/Pages/Folder.aspx
>> I very seldom login to my server directly. Either I am deploying reports
>> from my PC to the server or I am using Report Manager from my PC.
>> If you login to your server using your network login you can use IE there
>> to
>> get to report manager but the enhanced security with 2003 server could
>> cause
>> issues and you need to add the server (yes it is itself but the added
>> security doesn't know this) to approved security list. That is why I
>> suggest
>> just doing this from your PC, not from the server.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>>
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
>> > Thank you very much for getting back to me on this. I am just a little
>> > confused though. Last week, I posted a question about caching and
>> > execution,
>> > and I was directed to the Report Manager (which - up to that time I
>> > knew
>> > nothing about). The instructions were
>> >
>> > http://myserver/Reports/Pages/Folder.aspx
>> >
>> > Now, you are suggesting that I add my account to the local
>> > administrator
>> > group. By my account do you mean my login account that I log into my
>> > workstation or server with - my network account? My account for loging
>> > into
>> > the workstation is in the administrator group on the server. Say my
>> > network
>> > login is joe123. May I request if you could specify what I have to do
>> > to
>> > joe123 so that I can use him as you suggest?
>> >
>> > http://joe123.../reports
>> >
>> > I appologize in advance for my lack of intuition on this and am very
>> > thankful for your reply and suggestions.
>> >
>> > Thanks,
>> > Rich
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> First off. Win 2003 server has extra security as far as IE is
>> >> concerned.
>> >> This can make it problematic to connect via IE to the report server
>> >> when
>> >> you
>> >> are physically on the server. You are better off to do the following.
>> >> 1. Add your account to the local administrator group
>> >> 2. From your computer use http://yourserver.blah.com/reports and see
>> >> what
>> >> comes up.
>> >>
>> >> RS is an asp.net application. That is what you are logging into, NOT
>> >> SQL
>> >> Server. So logging in with SA only works if the local administrator
>> >> group
>> >> on
>> >> the server has a user called SA. Otherwise, it knows nothing about SA.
>> >> If
>> >> your local group has that in it then the issue is the added IE
>> >> security.
>> >> You
>> >> need to add the computer to the list of safe groups (I haven't done
>> >> this
>> >> for
>> >> awhile). You really are better off to not do this from the server. It
>> >> is
>> >> better and easier to do it from your own PC.
>> >>
>> >> RS uses Role based security. Initially you have a single role of which
>> >> the
>> >> local administrator group is in it (the administrator group).
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
>> >> > Greetings,
>> >> >
>> >> > I can't open Report Manager (sql Server 2000, win 2003 server). I
>> >> > log
>> >> > into
>> >> > our server as SA where Reporting Services is/was installed (I did
>> >> > not
>> >> > perform
>> >> > the install). I go to start/Programs/Microsoft Sql Server/Reporting
>> >> > Services/Report Manager. This brings up a page that has an http
>> >> > error
>> >> > of
>> >> > 403. It says that IE can connect to the website but that IE doesn't
>> >> > have
>> >> > the
>> >> > permission to access the webpage (http://myserver/Reports).
>> >> >
>> >> > I looked at IIS and see the Reports virtual directory under Default
>> >> > Websites (and the pages virtual dir, Folder.aspx...). The directory
>> >> > security
>> >> > is set for Integrated Windows Security.
>> >> >
>> >> > What can I do or what do I need to do so that I can access the
>> >> > Report
>> >> > Manager webpage? Do I need to configure something in IE or IIS? Or
>> >> > is
>> >> > it
>> >> > possible that the page isn't really there (bad install)?
>> >> >
>> >> > Thanks
>> >> > Rich
>> >>
>> >>
>> >>
>>|||Man, I sure hope that is it. The guy that owns the network, of course, is
not available right now. So when I see him, I will ask him to access report
manager from his workstation using his logon and not SA.
Rich
"Bruce L-C [MVP]" wrote:
> My guess is that you might be in a administrators group but that group has
> not been give administrative rights on the server. Login to that server as
> you, check out the local administrators group. If it doesn't let you in to
> view it or add to it then you do not have rights on that server. Get someone
> who does to either add your specific domain\username to the local
> administrator group or add the network administrator group to the local
> administrator group.
> I bet you don't have the rights to the server that you think you do. By
> default, anyone in the local administrators group is in the RS administrator
> role.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:80CF0AE5-2E85-4709-93A5-6CAE65398E1A@.microsoft.com...
> > Well, I tried
> >
> > http://myservername/Reports/Pages/Folder.aspx and got the http 401 error -
> > unauthorized
> >
> > I also tried the qualified server name
> >
> > http://myqualifiedserver.net/Reports/Pages/Folder.aspx
> > and
> > http://myqualifiedserver.net/Pages/Folder.aspx
> >
> > with the same 401 error code
> >
> > If people are able to get into Report Manager, then I should be able to
> > get
> > in also. But what is the trick for me? Well, I thank you again for
> > getting
> > back to me and with your suggestions. Just What is the trick?
> >
> > Rich
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Yes you need to use Report Manager but Report Manager is just a asp.net
> >> application that is available from any PC. You do not need to be on the
> >> server itself.
> >>
> >> I do mean your login account that you use to log into your server. If
> >> your
> >> account is already in the adminstrator group then you are good to go.
> >> From
> >> your PC just put this into the URL
> >> http://myserver/Reports/Pages/Folder.aspx
> >>
> >> Note, depending on your network you might need to fully qualify the
> >> server
> >> as myserver.whatever.com, you can also put the IP address directly like
> >> this
> >> http://IPAddress/Pages/Folder.aspx
> >>
> >> I very seldom login to my server directly. Either I am deploying reports
> >> from my PC to the server or I am using Report Manager from my PC.
> >>
> >> If you login to your server using your network login you can use IE there
> >> to
> >> get to report manager but the enhanced security with 2003 server could
> >> cause
> >> issues and you need to add the server (yes it is itself but the added
> >> security doesn't know this) to approved security list. That is why I
> >> suggest
> >> just doing this from your PC, not from the server.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >>
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
> >> > Thank you very much for getting back to me on this. I am just a little
> >> > confused though. Last week, I posted a question about caching and
> >> > execution,
> >> > and I was directed to the Report Manager (which - up to that time I
> >> > knew
> >> > nothing about). The instructions were
> >> >
> >> > http://myserver/Reports/Pages/Folder.aspx
> >> >
> >> > Now, you are suggesting that I add my account to the local
> >> > administrator
> >> > group. By my account do you mean my login account that I log into my
> >> > workstation or server with - my network account? My account for loging
> >> > into
> >> > the workstation is in the administrator group on the server. Say my
> >> > network
> >> > login is joe123. May I request if you could specify what I have to do
> >> > to
> >> > joe123 so that I can use him as you suggest?
> >> >
> >> > http://joe123.../reports
> >> >
> >> > I appologize in advance for my lack of intuition on this and am very
> >> > thankful for your reply and suggestions.
> >> >
> >> > Thanks,
> >> > Rich
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> First off. Win 2003 server has extra security as far as IE is
> >> >> concerned.
> >> >> This can make it problematic to connect via IE to the report server
> >> >> when
> >> >> you
> >> >> are physically on the server. You are better off to do the following.
> >> >> 1. Add your account to the local administrator group
> >> >> 2. From your computer use http://yourserver.blah.com/reports and see
> >> >> what
> >> >> comes up.
> >> >>
> >> >> RS is an asp.net application. That is what you are logging into, NOT
> >> >> SQL
> >> >> Server. So logging in with SA only works if the local administrator
> >> >> group
> >> >> on
> >> >> the server has a user called SA. Otherwise, it knows nothing about SA.
> >> >> If
> >> >> your local group has that in it then the issue is the added IE
> >> >> security.
> >> >> You
> >> >> need to add the computer to the list of safe groups (I haven't done
> >> >> this
> >> >> for
> >> >> awhile). You really are better off to not do this from the server. It
> >> >> is
> >> >> better and easier to do it from your own PC.
> >> >>
> >> >> RS uses Role based security. Initially you have a single role of which
> >> >> the
> >> >> local administrator group is in it (the administrator group).
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >>
> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
> >> >> > Greetings,
> >> >> >
> >> >> > I can't open Report Manager (sql Server 2000, win 2003 server). I
> >> >> > log
> >> >> > into
> >> >> > our server as SA where Reporting Services is/was installed (I did
> >> >> > not
> >> >> > perform
> >> >> > the install). I go to start/Programs/Microsoft Sql Server/Reporting
> >> >> > Services/Report Manager. This brings up a page that has an http
> >> >> > error
> >> >> > of
> >> >> > 403. It says that IE can connect to the website but that IE doesn't
> >> >> > have
> >> >> > the
> >> >> > permission to access the webpage (http://myserver/Reports).
> >> >> >
> >> >> > I looked at IIS and see the Reports virtual directory under Default
> >> >> > Websites (and the pages virtual dir, Folder.aspx...). The directory
> >> >> > security
> >> >> > is set for Integrated Windows Security.
> >> >> >
> >> >> > What can I do or what do I need to do so that I can access the
> >> >> > Report
> >> >> > Manager webpage? Do I need to configure something in IE or IIS? Or
> >> >> > is
> >> >> > it
> >> >> > possible that the page isn't really there (bad install)?
> >> >> >
> >> >> > Thanks
> >> >> > Rich
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||The owner got back and tried opening Report manager with no success except
for one interesting error message - the message said something about looking
for .Net Framework 1.1.
We used to be on 1.1 but upgraded to .Net Framework 2.0 so we could use
Visual Studio 2005. Would this be an issue for Report Manager for RS2003?
We are still using Sql Server 2000.
"Bruce L-C [MVP]" wrote:
> My guess is that you might be in a administrators group but that group has
> not been give administrative rights on the server. Login to that server as
> you, check out the local administrators group. If it doesn't let you in to
> view it or add to it then you do not have rights on that server. Get someone
> who does to either add your specific domain\username to the local
> administrator group or add the network administrator group to the local
> administrator group.
> I bet you don't have the rights to the server that you think you do. By
> default, anyone in the local administrators group is in the RS administrator
> role.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:80CF0AE5-2E85-4709-93A5-6CAE65398E1A@.microsoft.com...
> > Well, I tried
> >
> > http://myservername/Reports/Pages/Folder.aspx and got the http 401 error -
> > unauthorized
> >
> > I also tried the qualified server name
> >
> > http://myqualifiedserver.net/Reports/Pages/Folder.aspx
> > and
> > http://myqualifiedserver.net/Pages/Folder.aspx
> >
> > with the same 401 error code
> >
> > If people are able to get into Report Manager, then I should be able to
> > get
> > in also. But what is the trick for me? Well, I thank you again for
> > getting
> > back to me and with your suggestions. Just What is the trick?
> >
> > Rich
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Yes you need to use Report Manager but Report Manager is just a asp.net
> >> application that is available from any PC. You do not need to be on the
> >> server itself.
> >>
> >> I do mean your login account that you use to log into your server. If
> >> your
> >> account is already in the adminstrator group then you are good to go.
> >> From
> >> your PC just put this into the URL
> >> http://myserver/Reports/Pages/Folder.aspx
> >>
> >> Note, depending on your network you might need to fully qualify the
> >> server
> >> as myserver.whatever.com, you can also put the IP address directly like
> >> this
> >> http://IPAddress/Pages/Folder.aspx
> >>
> >> I very seldom login to my server directly. Either I am deploying reports
> >> from my PC to the server or I am using Report Manager from my PC.
> >>
> >> If you login to your server using your network login you can use IE there
> >> to
> >> get to report manager but the enhanced security with 2003 server could
> >> cause
> >> issues and you need to add the server (yes it is itself but the added
> >> security doesn't know this) to approved security list. That is why I
> >> suggest
> >> just doing this from your PC, not from the server.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >>
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
> >> > Thank you very much for getting back to me on this. I am just a little
> >> > confused though. Last week, I posted a question about caching and
> >> > execution,
> >> > and I was directed to the Report Manager (which - up to that time I
> >> > knew
> >> > nothing about). The instructions were
> >> >
> >> > http://myserver/Reports/Pages/Folder.aspx
> >> >
> >> > Now, you are suggesting that I add my account to the local
> >> > administrator
> >> > group. By my account do you mean my login account that I log into my
> >> > workstation or server with - my network account? My account for loging
> >> > into
> >> > the workstation is in the administrator group on the server. Say my
> >> > network
> >> > login is joe123. May I request if you could specify what I have to do
> >> > to
> >> > joe123 so that I can use him as you suggest?
> >> >
> >> > http://joe123.../reports
> >> >
> >> > I appologize in advance for my lack of intuition on this and am very
> >> > thankful for your reply and suggestions.
> >> >
> >> > Thanks,
> >> > Rich
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> First off. Win 2003 server has extra security as far as IE is
> >> >> concerned.
> >> >> This can make it problematic to connect via IE to the report server
> >> >> when
> >> >> you
> >> >> are physically on the server. You are better off to do the following.
> >> >> 1. Add your account to the local administrator group
> >> >> 2. From your computer use http://yourserver.blah.com/reports and see
> >> >> what
> >> >> comes up.
> >> >>
> >> >> RS is an asp.net application. That is what you are logging into, NOT
> >> >> SQL
> >> >> Server. So logging in with SA only works if the local administrator
> >> >> group
> >> >> on
> >> >> the server has a user called SA. Otherwise, it knows nothing about SA.
> >> >> If
> >> >> your local group has that in it then the issue is the added IE
> >> >> security.
> >> >> You
> >> >> need to add the computer to the list of safe groups (I haven't done
> >> >> this
> >> >> for
> >> >> awhile). You really are better off to not do this from the server. It
> >> >> is
> >> >> better and easier to do it from your own PC.
> >> >>
> >> >> RS uses Role based security. Initially you have a single role of which
> >> >> the
> >> >> local administrator group is in it (the administrator group).
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >>
> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
> >> >> > Greetings,
> >> >> >
> >> >> > I can't open Report Manager (sql Server 2000, win 2003 server). I
> >> >> > log
> >> >> > into
> >> >> > our server as SA where Reporting Services is/was installed (I did
> >> >> > not
> >> >> > perform
> >> >> > the install). I go to start/Programs/Microsoft Sql Server/Reporting
> >> >> > Services/Report Manager. This brings up a page that has an http
> >> >> > error
> >> >> > of
> >> >> > 403. It says that IE can connect to the website but that IE doesn't
> >> >> > have
> >> >> > the
> >> >> > permission to access the webpage (http://myserver/Reports).
> >> >> >
> >> >> > I looked at IIS and see the Reports virtual directory under Default
> >> >> > Websites (and the pages virtual dir, Folder.aspx...). The directory
> >> >> > security
> >> >> > is set for Integrated Windows Security.
> >> >> >
> >> >> > What can I do or what do I need to do so that I can access the
> >> >> > Report
> >> >> > Manager webpage? Do I need to configure something in IE or IIS? Or
> >> >> > is
> >> >> > it
> >> >> > possible that the page isn't really there (bad install)?
> >> >> >
> >> >> > Thanks
> >> >> > Rich
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Yes.
RS 2000 is a 1.1 framework app. RS 2005 is a 2.0 framework app. It is fine
that you upgraded to 2.0 BUT you have to have Reports and ReportServer webs
be at 1.1 (IIS will support both but you have to configure the sites to be
1.1).
Not sure if this is all the reason but it is definitely a problem. Get the
owner to work first and then get back to your problem. You might have more
than one problem going on.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:FA0B37D6-B5D1-4C13-B0F4-8AAF9D39974D@.microsoft.com...
> The owner got back and tried opening Report manager with no success except
> for one interesting error message - the message said something about
> looking
> for .Net Framework 1.1.
> We used to be on 1.1 but upgraded to .Net Framework 2.0 so we could use
> Visual Studio 2005. Would this be an issue for Report Manager for
> RS2003?
> We are still using Sql Server 2000.
> "Bruce L-C [MVP]" wrote:
>> My guess is that you might be in a administrators group but that group
>> has
>> not been give administrative rights on the server. Login to that server
>> as
>> you, check out the local administrators group. If it doesn't let you in
>> to
>> view it or add to it then you do not have rights on that server. Get
>> someone
>> who does to either add your specific domain\username to the local
>> administrator group or add the network administrator group to the local
>> administrator group.
>> I bet you don't have the rights to the server that you think you do. By
>> default, anyone in the local administrators group is in the RS
>> administrator
>> role.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:80CF0AE5-2E85-4709-93A5-6CAE65398E1A@.microsoft.com...
>> > Well, I tried
>> >
>> > http://myservername/Reports/Pages/Folder.aspx and got the http 401
>> > error -
>> > unauthorized
>> >
>> > I also tried the qualified server name
>> >
>> > http://myqualifiedserver.net/Reports/Pages/Folder.aspx
>> > and
>> > http://myqualifiedserver.net/Pages/Folder.aspx
>> >
>> > with the same 401 error code
>> >
>> > If people are able to get into Report Manager, then I should be able to
>> > get
>> > in also. But what is the trick for me? Well, I thank you again for
>> > getting
>> > back to me and with your suggestions. Just What is the trick?
>> >
>> > Rich
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Yes you need to use Report Manager but Report Manager is just a
>> >> asp.net
>> >> application that is available from any PC. You do not need to be on
>> >> the
>> >> server itself.
>> >>
>> >> I do mean your login account that you use to log into your server. If
>> >> your
>> >> account is already in the adminstrator group then you are good to go.
>> >> From
>> >> your PC just put this into the URL
>> >> http://myserver/Reports/Pages/Folder.aspx
>> >>
>> >> Note, depending on your network you might need to fully qualify the
>> >> server
>> >> as myserver.whatever.com, you can also put the IP address directly
>> >> like
>> >> this
>> >> http://IPAddress/Pages/Folder.aspx
>> >>
>> >> I very seldom login to my server directly. Either I am deploying
>> >> reports
>> >> from my PC to the server or I am using Report Manager from my PC.
>> >>
>> >> If you login to your server using your network login you can use IE
>> >> there
>> >> to
>> >> get to report manager but the enhanced security with 2003 server could
>> >> cause
>> >> issues and you need to add the server (yes it is itself but the added
>> >> security doesn't know this) to approved security list. That is why I
>> >> suggest
>> >> just doing this from your PC, not from the server.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >>
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
>> >> > Thank you very much for getting back to me on this. I am just a
>> >> > little
>> >> > confused though. Last week, I posted a question about caching and
>> >> > execution,
>> >> > and I was directed to the Report Manager (which - up to that time I
>> >> > knew
>> >> > nothing about). The instructions were
>> >> >
>> >> > http://myserver/Reports/Pages/Folder.aspx
>> >> >
>> >> > Now, you are suggesting that I add my account to the local
>> >> > administrator
>> >> > group. By my account do you mean my login account that I log into
>> >> > my
>> >> > workstation or server with - my network account? My account for
>> >> > loging
>> >> > into
>> >> > the workstation is in the administrator group on the server. Say my
>> >> > network
>> >> > login is joe123. May I request if you could specify what I have to
>> >> > do
>> >> > to
>> >> > joe123 so that I can use him as you suggest?
>> >> >
>> >> > http://joe123.../reports
>> >> >
>> >> > I appologize in advance for my lack of intuition on this and am very
>> >> > thankful for your reply and suggestions.
>> >> >
>> >> > Thanks,
>> >> > Rich
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> First off. Win 2003 server has extra security as far as IE is
>> >> >> concerned.
>> >> >> This can make it problematic to connect via IE to the report server
>> >> >> when
>> >> >> you
>> >> >> are physically on the server. You are better off to do the
>> >> >> following.
>> >> >> 1. Add your account to the local administrator group
>> >> >> 2. From your computer use http://yourserver.blah.com/reports and
>> >> >> see
>> >> >> what
>> >> >> comes up.
>> >> >>
>> >> >> RS is an asp.net application. That is what you are logging into,
>> >> >> NOT
>> >> >> SQL
>> >> >> Server. So logging in with SA only works if the local administrator
>> >> >> group
>> >> >> on
>> >> >> the server has a user called SA. Otherwise, it knows nothing about
>> >> >> SA.
>> >> >> If
>> >> >> your local group has that in it then the issue is the added IE
>> >> >> security.
>> >> >> You
>> >> >> need to add the computer to the list of safe groups (I haven't done
>> >> >> this
>> >> >> for
>> >> >> awhile). You really are better off to not do this from the server.
>> >> >> It
>> >> >> is
>> >> >> better and easier to do it from your own PC.
>> >> >>
>> >> >> RS uses Role based security. Initially you have a single role of
>> >> >> which
>> >> >> the
>> >> >> local administrator group is in it (the administrator group).
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >>
>> >> >>
>> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
>> >> >> > Greetings,
>> >> >> >
>> >> >> > I can't open Report Manager (sql Server 2000, win 2003 server).
>> >> >> > I
>> >> >> > log
>> >> >> > into
>> >> >> > our server as SA where Reporting Services is/was installed (I did
>> >> >> > not
>> >> >> > perform
>> >> >> > the install). I go to start/Programs/Microsoft Sql
>> >> >> > Server/Reporting
>> >> >> > Services/Report Manager. This brings up a page that has an http
>> >> >> > error
>> >> >> > of
>> >> >> > 403. It says that IE can connect to the website but that IE
>> >> >> > doesn't
>> >> >> > have
>> >> >> > the
>> >> >> > permission to access the webpage (http://myserver/Reports).
>> >> >> >
>> >> >> > I looked at IIS and see the Reports virtual directory under
>> >> >> > Default
>> >> >> > Websites (and the pages virtual dir, Folder.aspx...). The
>> >> >> > directory
>> >> >> > security
>> >> >> > is set for Integrated Windows Security.
>> >> >> >
>> >> >> > What can I do or what do I need to do so that I can access the
>> >> >> > Report
>> >> >> > Manager webpage? Do I need to configure something in IE or IIS?
>> >> >> > Or
>> >> >> > is
>> >> >> > it
>> >> >> > possible that the page isn't really there (bad install)?
>> >> >> >
>> >> >> > Thanks
>> >> >> > Rich
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Thanks. We have a web guy at my place that I have apprised about the
situation. Hopefully, he can figure out how to configure the sites for .net
framework 1.1.
Note: I can deploy reports with my current setup and things work OK except
for the caching thing - which is why I need to get into Report Manager in the
first place.
Rich
"Bruce L-C [MVP]" wrote:
> Yes.
> RS 2000 is a 1.1 framework app. RS 2005 is a 2.0 framework app. It is fine
> that you upgraded to 2.0 BUT you have to have Reports and ReportServer webs
> be at 1.1 (IIS will support both but you have to configure the sites to be
> 1.1).
> Not sure if this is all the reason but it is definitely a problem. Get the
> owner to work first and then get back to your problem. You might have more
> than one problem going on.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:FA0B37D6-B5D1-4C13-B0F4-8AAF9D39974D@.microsoft.com...
> > The owner got back and tried opening Report manager with no success except
> > for one interesting error message - the message said something about
> > looking
> > for .Net Framework 1.1.
> >
> > We used to be on 1.1 but upgraded to .Net Framework 2.0 so we could use
> > Visual Studio 2005. Would this be an issue for Report Manager for
> > RS2003?
> > We are still using Sql Server 2000.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> My guess is that you might be in a administrators group but that group
> >> has
> >> not been give administrative rights on the server. Login to that server
> >> as
> >> you, check out the local administrators group. If it doesn't let you in
> >> to
> >> view it or add to it then you do not have rights on that server. Get
> >> someone
> >> who does to either add your specific domain\username to the local
> >> administrator group or add the network administrator group to the local
> >> administrator group.
> >>
> >> I bet you don't have the rights to the server that you think you do. By
> >> default, anyone in the local administrators group is in the RS
> >> administrator
> >> role.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:80CF0AE5-2E85-4709-93A5-6CAE65398E1A@.microsoft.com...
> >> > Well, I tried
> >> >
> >> > http://myservername/Reports/Pages/Folder.aspx and got the http 401
> >> > error -
> >> > unauthorized
> >> >
> >> > I also tried the qualified server name
> >> >
> >> > http://myqualifiedserver.net/Reports/Pages/Folder.aspx
> >> > and
> >> > http://myqualifiedserver.net/Pages/Folder.aspx
> >> >
> >> > with the same 401 error code
> >> >
> >> > If people are able to get into Report Manager, then I should be able to
> >> > get
> >> > in also. But what is the trick for me? Well, I thank you again for
> >> > getting
> >> > back to me and with your suggestions. Just What is the trick?
> >> >
> >> > Rich
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Yes you need to use Report Manager but Report Manager is just a
> >> >> asp.net
> >> >> application that is available from any PC. You do not need to be on
> >> >> the
> >> >> server itself.
> >> >>
> >> >> I do mean your login account that you use to log into your server. If
> >> >> your
> >> >> account is already in the adminstrator group then you are good to go.
> >> >> From
> >> >> your PC just put this into the URL
> >> >> http://myserver/Reports/Pages/Folder.aspx
> >> >>
> >> >> Note, depending on your network you might need to fully qualify the
> >> >> server
> >> >> as myserver.whatever.com, you can also put the IP address directly
> >> >> like
> >> >> this
> >> >> http://IPAddress/Pages/Folder.aspx
> >> >>
> >> >> I very seldom login to my server directly. Either I am deploying
> >> >> reports
> >> >> from my PC to the server or I am using Report Manager from my PC.
> >> >>
> >> >> If you login to your server using your network login you can use IE
> >> >> there
> >> >> to
> >> >> get to report manager but the enhanced security with 2003 server could
> >> >> cause
> >> >> issues and you need to add the server (yes it is itself but the added
> >> >> security doesn't know this) to approved security list. That is why I
> >> >> suggest
> >> >> just doing this from your PC, not from the server.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
> >> >> > Thank you very much for getting back to me on this. I am just a
> >> >> > little
> >> >> > confused though. Last week, I posted a question about caching and
> >> >> > execution,
> >> >> > and I was directed to the Report Manager (which - up to that time I
> >> >> > knew
> >> >> > nothing about). The instructions were
> >> >> >
> >> >> > http://myserver/Reports/Pages/Folder.aspx
> >> >> >
> >> >> > Now, you are suggesting that I add my account to the local
> >> >> > administrator
> >> >> > group. By my account do you mean my login account that I log into
> >> >> > my
> >> >> > workstation or server with - my network account? My account for
> >> >> > loging
> >> >> > into
> >> >> > the workstation is in the administrator group on the server. Say my
> >> >> > network
> >> >> > login is joe123. May I request if you could specify what I have to
> >> >> > do
> >> >> > to
> >> >> > joe123 so that I can use him as you suggest?
> >> >> >
> >> >> > http://joe123.../reports
> >> >> >
> >> >> > I appologize in advance for my lack of intuition on this and am very
> >> >> > thankful for your reply and suggestions.
> >> >> >
> >> >> > Thanks,
> >> >> > Rich
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> First off. Win 2003 server has extra security as far as IE is
> >> >> >> concerned.
> >> >> >> This can make it problematic to connect via IE to the report server
> >> >> >> when
> >> >> >> you
> >> >> >> are physically on the server. You are better off to do the
> >> >> >> following.
> >> >> >> 1. Add your account to the local administrator group
> >> >> >> 2. From your computer use http://yourserver.blah.com/reports and
> >> >> >> see
> >> >> >> what
> >> >> >> comes up.
> >> >> >>
> >> >> >> RS is an asp.net application. That is what you are logging into,
> >> >> >> NOT
> >> >> >> SQL
> >> >> >> Server. So logging in with SA only works if the local administrator
> >> >> >> group
> >> >> >> on
> >> >> >> the server has a user called SA. Otherwise, it knows nothing about
> >> >> >> SA.
> >> >> >> If
> >> >> >> your local group has that in it then the issue is the added IE
> >> >> >> security.
> >> >> >> You
> >> >> >> need to add the computer to the list of safe groups (I haven't done
> >> >> >> this
> >> >> >> for
> >> >> >> awhile). You really are better off to not do this from the server.
> >> >> >> It
> >> >> >> is
> >> >> >> better and easier to do it from your own PC.
> >> >> >>
> >> >> >> RS uses Role based security. Initially you have a single role of
> >> >> >> which
> >> >> >> the
> >> >> >> local administrator group is in it (the administrator group).
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
> >> >> >> > Greetings,
> >> >> >> >
> >> >> >> > I can't open Report Manager (sql Server 2000, win 2003 server).
> >> >> >> > I
> >> >> >> > log
> >> >> >> > into
> >> >> >> > our server as SA where Reporting Services is/was installed (I did
> >> >> >> > not
> >> >> >> > perform
> >> >> >> > the install). I go to start/Programs/Microsoft Sql
> >> >> >> > Server/Reporting
> >> >> >> > Services/Report Manager. This brings up a page that has an http
> >> >> >> > error
> >> >> >> > of
> >> >> >> > 403. It says that IE can connect to the website but that IE
> >> >> >> > doesn't
> >> >> >> > have
> >> >> >> > the
> >> >> >> > permission to access the webpage (http://myserver/Reports).
> >> >> >> >
> >> >> >> > I looked at IIS and see the Reports virtual directory under
> >> >> >> > Default
> >> >> >> > Websites (and the pages virtual dir, Folder.aspx...). The
> >> >> >> > directory
> >> >> >> > security
> >> >> >> > is set for Integrated Windows Security.
> >> >> >> >
> >> >> >> > What can I do or what do I need to do so that I can access the
> >> >> >> > Report
> >> >> >> > Manager webpage? Do I need to configure something in IE or IIS?
> >> >> >> > Or
> >> >> >> > is
> >> >> >> > it
> >> >> >> > possible that the page isn't really there (bad install)?
> >> >> >> >
> >> >> >> > Thanks
> >> >> >> > Rich
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I'm surprised you can deploy. It could be that reportserver website is still
1.1 and reports website (which is the report manager app) was set to 2.0
(but needs to be 1.1).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:1F8AC4CC-86E0-4124-8C8A-84FA8D25744D@.microsoft.com...
> Thanks. We have a web guy at my place that I have apprised about the
> situation. Hopefully, he can figure out how to configure the sites for
> .net
> framework 1.1.
> Note: I can deploy reports with my current setup and things work OK
> except
> for the caching thing - which is why I need to get into Report Manager in
> the
> first place.
> Rich
> "Bruce L-C [MVP]" wrote:
>> Yes.
>> RS 2000 is a 1.1 framework app. RS 2005 is a 2.0 framework app. It is
>> fine
>> that you upgraded to 2.0 BUT you have to have Reports and ReportServer
>> webs
>> be at 1.1 (IIS will support both but you have to configure the sites to
>> be
>> 1.1).
>> Not sure if this is all the reason but it is definitely a problem. Get
>> the
>> owner to work first and then get back to your problem. You might have
>> more
>> than one problem going on.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:FA0B37D6-B5D1-4C13-B0F4-8AAF9D39974D@.microsoft.com...
>> > The owner got back and tried opening Report manager with no success
>> > except
>> > for one interesting error message - the message said something about
>> > looking
>> > for .Net Framework 1.1.
>> >
>> > We used to be on 1.1 but upgraded to .Net Framework 2.0 so we could use
>> > Visual Studio 2005. Would this be an issue for Report Manager for
>> > RS2003?
>> > We are still using Sql Server 2000.
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> My guess is that you might be in a administrators group but that group
>> >> has
>> >> not been give administrative rights on the server. Login to that
>> >> server
>> >> as
>> >> you, check out the local administrators group. If it doesn't let you
>> >> in
>> >> to
>> >> view it or add to it then you do not have rights on that server. Get
>> >> someone
>> >> who does to either add your specific domain\username to the local
>> >> administrator group or add the network administrator group to the
>> >> local
>> >> administrator group.
>> >>
>> >> I bet you don't have the rights to the server that you think you do.
>> >> By
>> >> default, anyone in the local administrators group is in the RS
>> >> administrator
>> >> role.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:80CF0AE5-2E85-4709-93A5-6CAE65398E1A@.microsoft.com...
>> >> > Well, I tried
>> >> >
>> >> > http://myservername/Reports/Pages/Folder.aspx and got the http 401
>> >> > error -
>> >> > unauthorized
>> >> >
>> >> > I also tried the qualified server name
>> >> >
>> >> > http://myqualifiedserver.net/Reports/Pages/Folder.aspx
>> >> > and
>> >> > http://myqualifiedserver.net/Pages/Folder.aspx
>> >> >
>> >> > with the same 401 error code
>> >> >
>> >> > If people are able to get into Report Manager, then I should be able
>> >> > to
>> >> > get
>> >> > in also. But what is the trick for me? Well, I thank you again for
>> >> > getting
>> >> > back to me and with your suggestions. Just What is the trick?
>> >> >
>> >> > Rich
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> Yes you need to use Report Manager but Report Manager is just a
>> >> >> asp.net
>> >> >> application that is available from any PC. You do not need to be on
>> >> >> the
>> >> >> server itself.
>> >> >>
>> >> >> I do mean your login account that you use to log into your server.
>> >> >> If
>> >> >> your
>> >> >> account is already in the adminstrator group then you are good to
>> >> >> go.
>> >> >> From
>> >> >> your PC just put this into the URL
>> >> >> http://myserver/Reports/Pages/Folder.aspx
>> >> >>
>> >> >> Note, depending on your network you might need to fully qualify the
>> >> >> server
>> >> >> as myserver.whatever.com, you can also put the IP address directly
>> >> >> like
>> >> >> this
>> >> >> http://IPAddress/Pages/Folder.aspx
>> >> >>
>> >> >> I very seldom login to my server directly. Either I am deploying
>> >> >> reports
>> >> >> from my PC to the server or I am using Report Manager from my PC.
>> >> >>
>> >> >> If you login to your server using your network login you can use IE
>> >> >> there
>> >> >> to
>> >> >> get to report manager but the enhanced security with 2003 server
>> >> >> could
>> >> >> cause
>> >> >> issues and you need to add the server (yes it is itself but the
>> >> >> added
>> >> >> security doesn't know this) to approved security list. That is why
>> >> >> I
>> >> >> suggest
>> >> >> just doing this from your PC, not from the server.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> >> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
>> >> >> > Thank you very much for getting back to me on this. I am just a
>> >> >> > little
>> >> >> > confused though. Last week, I posted a question about caching
>> >> >> > and
>> >> >> > execution,
>> >> >> > and I was directed to the Report Manager (which - up to that time
>> >> >> > I
>> >> >> > knew
>> >> >> > nothing about). The instructions were
>> >> >> >
>> >> >> > http://myserver/Reports/Pages/Folder.aspx
>> >> >> >
>> >> >> > Now, you are suggesting that I add my account to the local
>> >> >> > administrator
>> >> >> > group. By my account do you mean my login account that I log
>> >> >> > into
>> >> >> > my
>> >> >> > workstation or server with - my network account? My account for
>> >> >> > loging
>> >> >> > into
>> >> >> > the workstation is in the administrator group on the server. Say
>> >> >> > my
>> >> >> > network
>> >> >> > login is joe123. May I request if you could specify what I have
>> >> >> > to
>> >> >> > do
>> >> >> > to
>> >> >> > joe123 so that I can use him as you suggest?
>> >> >> >
>> >> >> > http://joe123.../reports
>> >> >> >
>> >> >> > I appologize in advance for my lack of intuition on this and am
>> >> >> > very
>> >> >> > thankful for your reply and suggestions.
>> >> >> >
>> >> >> > Thanks,
>> >> >> > Rich
>> >> >> >
>> >> >> > "Bruce L-C [MVP]" wrote:
>> >> >> >
>> >> >> >> First off. Win 2003 server has extra security as far as IE is
>> >> >> >> concerned.
>> >> >> >> This can make it problematic to connect via IE to the report
>> >> >> >> server
>> >> >> >> when
>> >> >> >> you
>> >> >> >> are physically on the server. You are better off to do the
>> >> >> >> following.
>> >> >> >> 1. Add your account to the local administrator group
>> >> >> >> 2. From your computer use http://yourserver.blah.com/reports and
>> >> >> >> see
>> >> >> >> what
>> >> >> >> comes up.
>> >> >> >>
>> >> >> >> RS is an asp.net application. That is what you are logging into,
>> >> >> >> NOT
>> >> >> >> SQL
>> >> >> >> Server. So logging in with SA only works if the local
>> >> >> >> administrator
>> >> >> >> group
>> >> >> >> on
>> >> >> >> the server has a user called SA. Otherwise, it knows nothing
>> >> >> >> about
>> >> >> >> SA.
>> >> >> >> If
>> >> >> >> your local group has that in it then the issue is the added IE
>> >> >> >> security.
>> >> >> >> You
>> >> >> >> need to add the computer to the list of safe groups (I haven't
>> >> >> >> done
>> >> >> >> this
>> >> >> >> for
>> >> >> >> awhile). You really are better off to not do this from the
>> >> >> >> server.
>> >> >> >> It
>> >> >> >> is
>> >> >> >> better and easier to do it from your own PC.
>> >> >> >>
>> >> >> >> RS uses Role based security. Initially you have a single role of
>> >> >> >> which
>> >> >> >> the
>> >> >> >> local administrator group is in it (the administrator group).
>> >> >> >>
>> >> >> >>
>> >> >> >> --
>> >> >> >> Bruce Loehle-Conger
>> >> >> >> MVP SQL Server Reporting Services
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> >> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
>> >> >> >> > Greetings,
>> >> >> >> >
>> >> >> >> > I can't open Report Manager (sql Server 2000, win 2003
>> >> >> >> > server).
>> >> >> >> > I
>> >> >> >> > log
>> >> >> >> > into
>> >> >> >> > our server as SA where Reporting Services is/was installed (I
>> >> >> >> > did
>> >> >> >> > not
>> >> >> >> > perform
>> >> >> >> > the install). I go to start/Programs/Microsoft Sql
>> >> >> >> > Server/Reporting
>> >> >> >> > Services/Report Manager. This brings up a page that has an
>> >> >> >> > http
>> >> >> >> > error
>> >> >> >> > of
>> >> >> >> > 403. It says that IE can connect to the website but that IE
>> >> >> >> > doesn't
>> >> >> >> > have
>> >> >> >> > the
>> >> >> >> > permission to access the webpage (http://myserver/Reports).
>> >> >> >> >
>> >> >> >> > I looked at IIS and see the Reports virtual directory under
>> >> >> >> > Default
>> >> >> >> > Websites (and the pages virtual dir, Folder.aspx...). The
>> >> >> >> > directory
>> >> >> >> > security
>> >> >> >> > is set for Integrated Windows Security.
>> >> >> >> >
>> >> >> >> > What can I do or what do I need to do so that I can access the
>> >> >> >> > Report
>> >> >> >> > Manager webpage? Do I need to configure something in IE or
>> >> >> >> > IIS?
>> >> >> >> > Or
>> >> >> >> > is
>> >> >> >> > it
>> >> >> >> > possible that the page isn't really there (bad install)?
>> >> >> >> >
>> >> >> >> > Thanks
>> >> >> >> > Rich
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>