IIS and Internet Access

Hi All,
I have the following going on: A win 2k3 server running sql server and
reporting services. I have IIS configured on it and can run reports
internally on my network but when I try to access a report from the web I get
nothing back. I can access my web projects but cant access and display
reports from web. I am using a static ip address to access the website for
now. I don't have a domain name setup for this box yet if that makes a
difference. and internally when I refer to the box in the website I use the
boxs computer name. Any ideas on what could be wrong here?
Thanks,
JJThis topic might help:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"JJ" <JJ@.discussions.microsoft.com> wrote in message
news:9B7DEDB4-0940-4FED-B6C9-0F05CCDBEF43@.microsoft.com...
> Hi All,
> I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I
> get
> nothing back. I can access my web projects but cant access and display
> reports from web. I am using a static ip address to access the website for
> now. I don't have a domain name setup for this box yet if that makes a
> difference. and internally when I refer to the box in the website I use
> the
> boxs computer name. Any ideas on what could be wrong here?
> Thanks,
> JJ|||Hi,
Did you arrange security settings for the browsing reports?
You should grant "Browser" Role to Guests or everyone from the Report
Manager to the folder where your reports are.
Eralper
http://www.kodyaz.com
"JJ" wrote:
> Hi All,
> I have the following going on: A win 2k3 server running sql server and
> reporting services. I have IIS configured on it and can run reports
> internally on my network but when I try to access a report from the web I get
> nothing back. I can access my web projects but cant access and display
> reports from web. I am using a static ip address to access the website for
> now. I don't have a domain name setup for this box yet if that makes a
> difference. and internally when I refer to the box in the website I use the
> boxs computer name. Any ideas on what could be wrong here?
> Thanks,
> JJ|||Hi eralper,
Man I am so feed up trying to get Reporting Services to be accessed from
the web. I have windows 2003 server running Sql Server 2000 with Reporting
Services sp2 installed. I can see and execute the reports through Report
Manager with no problem internally. But when I have a buddy check out the
website using an IP address. He gets nothing. I have setup roles for
IUSR_Account as browser role and assigned the report trying to access to the
security property under report. In the datasource for report I have included
the user name and password that matchs a windows account mapped to a Sql
server user account. No problem there. How do you have IIS setup under
Directory securities for Report and Report Manager set?
I don't have a domain name setup for this server yet. I am using Static IP
address for the moment. Are you using SSL for Reporting Services? What else
should I check?
Thanks,
JJ
"eralper" wrote:
> Hi,
> Did you arrange security settings for the browsing reports?
> You should grant "Browser" Role to Guests or everyone from the Report
> Manager to the folder where your reports are.
> Eralper
> http://www.kodyaz.com
> "JJ" wrote:
> > Hi All,
> >
> > I have the following going on: A win 2k3 server running sql server and
> > reporting services. I have IIS configured on it and can run reports
> > internally on my network but when I try to access a report from the web I get
> > nothing back. I can access my web projects but cant access and display
> > reports from web. I am using a static ip address to access the website for
> > now. I don't have a domain name setup for this box yet if that makes a
> > difference. and internally when I refer to the box in the website I use the
> > boxs computer name. Any ideas on what could be wrong here?
> >
> > Thanks,
> >
> > JJ|||Hi JJ,
I tried to give a detailed answer on
http://www.kodyaz.com/ShowPost.aspx?PostID=19
I hope it helps.
Eralper
http://www.kodyaz.com
"JJ" wrote:
> Hi eralper,
> Man I am so feed up trying to get Reporting Services to be accessed from
> the web. I have windows 2003 server running Sql Server 2000 with Reporting
> Services sp2 installed. I can see and execute the reports through Report
> Manager with no problem internally. But when I have a buddy check out the
> website using an IP address. He gets nothing. I have setup roles for
> IUSR_Account as browser role and assigned the report trying to access to the
> security property under report. In the datasource for report I have included
> the user name and password that matchs a windows account mapped to a Sql
> server user account. No problem there. How do you have IIS setup under
> Directory securities for Report and Report Manager set?
> I don't have a domain name setup for this server yet. I am using Static IP
> address for the moment. Are you using SSL for Reporting Services? What else
> should I check?
> Thanks,
> JJ
>
> "eralper" wrote:
> >
> > Hi,
> >
> > Did you arrange security settings for the browsing reports?
> >
> > You should grant "Browser" Role to Guests or everyone from the Report
> > Manager to the folder where your reports are.
> >
> > Eralper
> > http://www.kodyaz.com
> >
> > "JJ" wrote:
> >
> > > Hi All,
> > >
> > > I have the following going on: A win 2k3 server running sql server and
> > > reporting services. I have IIS configured on it and can run reports
> > > internally on my network but when I try to access a report from the web I get
> > > nothing back. I can access my web projects but cant access and display
> > > reports from web. I am using a static ip address to access the website for
> > > now. I don't have a domain name setup for this box yet if that makes a
> > > difference. and internally when I refer to the box in the website I use the
> > > boxs computer name. Any ideas on what could be wrong here?
> > >
> > > Thanks,
> > >
> > > JJ|||Hi Eralper,
I tried to access your website but I keep on getting Obj ref not set
error. This is happening even when I enter www. kodyak.com.
Thanks,
JJ
"eralper" wrote:
> Hi JJ,
> I tried to give a detailed answer on
> http://www.kodyaz.com/ShowPost.aspx?PostID=19
> I hope it helps.
> Eralper
> http://www.kodyaz.com
>
> "JJ" wrote:
> > Hi eralper,
> >
> > Man I am so feed up trying to get Reporting Services to be accessed from
> > the web. I have windows 2003 server running Sql Server 2000 with Reporting
> > Services sp2 installed. I can see and execute the reports through Report
> > Manager with no problem internally. But when I have a buddy check out the
> > website using an IP address. He gets nothing. I have setup roles for
> > IUSR_Account as browser role and assigned the report trying to access to the
> > security property under report. In the datasource for report I have included
> > the user name and password that matchs a windows account mapped to a Sql
> > server user account. No problem there. How do you have IIS setup under
> > Directory securities for Report and Report Manager set?
> >
> > I don't have a domain name setup for this server yet. I am using Static IP
> > address for the moment. Are you using SSL for Reporting Services? What else
> > should I check?
> >
> > Thanks,
> >
> > JJ
> >
> >
> > "eralper" wrote:
> >
> > >
> > > Hi,
> > >
> > > Did you arrange security settings for the browsing reports?
> > >
> > > You should grant "Browser" Role to Guests or everyone from the Report
> > > Manager to the folder where your reports are.
> > >
> > > Eralper
> > > http://www.kodyaz.com
> > >
> > > "JJ" wrote:
> > >
> > > > Hi All,
> > > >
> > > > I have the following going on: A win 2k3 server running sql server and
> > > > reporting services. I have IIS configured on it and can run reports
> > > > internally on my network but when I try to access a report from the web I get
> > > > nothing back. I can access my web projects but cant access and display
> > > > reports from web. I am using a static ip address to access the website for
> > > > now. I don't have a domain name setup for this box yet if that makes a
> > > > difference. and internally when I refer to the box in the website I use the
> > > > boxs computer name. Any ideas on what could be wrong here?
> > > >
> > > > Thanks,
> > > >
> > > > JJ|||Hi,
Actually my configuration differs from yours with my web server is IIS5
working on Win2k. But I believe this will not cause a problem for anonymous
access to reports after the steps I'll try to summarize below.
Considering the site security, I'm not sure this is the best practice for
reporting services application but it seems working.
First you can view and run reports without problem because default
authentication method for virtual directories "Reports" and "ReportServer" is
window authentication. And I think you browse the reports with an admin group
user.
With these default configurations of the setup of Reporting Services, your
buddy should be able to get the username and password screen for windows
authentication when he calls http://YourIPComesHere/Reports
If you change IIS permissions for these two virtual directories (Reports &
ReportServer), your buddy should see an empty page because the internet guest
account has no browser role permission on none of the folders below home
(pointing VS.Net Reporting Services projects) or the individual reports in
those folders.
So before switching to anonymous access on these virtual directories, you
should grant Browser role permission to "everyone" in approtiate folders and
reports.
I used "everyone", I do not know if it makes sense for IUSR_ComputerName
So first go to Home directory (http://YourServer/Reports). Select Properties
tab for Home and hit the "New Role Assignment" button to add "everyone" as
Browser. By doing this, anonymous users will be able to list contents of the
Reports folder.
Second, select "Detailed View" and "Edit" the report folder where your
reports are deployed. Go to Security tab and add "everyone" as Browser.
I'm not sure but you may need to repeat a similar step (adding everyone as
Browser) for the reports.
You should hide the datasources in the list by editing their properties.
Check the "hide in list view" option in General tab.
One important note: you must edit RSWebApplication config file in
"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager" folder (default place for this configuration file)
Update ReportServerURL by changing the computer name with your IP. Otherwise
users will be able reach the report but will not be able to see it processing.
Now is time for changing the permissions of the two virtual directories
Reports and ReportServer via IIS Manager. Go to properties of the virtual
directories then select directory security tab. And allow anonymous access.
This configuration works for me. I hope you may find something useful within
my notes.
Eralper
http://www.kodyaz.com
"JJ" wrote:
> Hi Eralper,
> I tried to access your website but I keep on getting Obj ref not set
> error. This is happening even when I enter www. kodyak.com.
> Thanks,
> JJ
> "eralper" wrote:
> > Hi JJ,
> >
> > I tried to give a detailed answer on
> > http://www.kodyaz.com/ShowPost.aspx?PostID=19
> >
> > I hope it helps.
> >
> > Eralper
> > http://www.kodyaz.com
> >
> >
> > "JJ" wrote:
> >
> > > Hi eralper,
> > >
> > > Man I am so feed up trying to get Reporting Services to be accessed from
> > > the web. I have windows 2003 server running Sql Server 2000 with Reporting
> > > Services sp2 installed. I can see and execute the reports through Report
> > > Manager with no problem internally. But when I have a buddy check out the
> > > website using an IP address. He gets nothing. I have setup roles for
> > > IUSR_Account as browser role and assigned the report trying to access to the
> > > security property under report. In the datasource for report I have included
> > > the user name and password that matchs a windows account mapped to a Sql
> > > server user account. No problem there. How do you have IIS setup under
> > > Directory securities for Report and Report Manager set?
> > >
> > > I don't have a domain name setup for this server yet. I am using Static IP
> > > address for the moment. Are you using SSL for Reporting Services? What else
> > > should I check?
> > >
> > > Thanks,
> > >
> > > JJ
> > >
> > >
> > > "eralper" wrote:
> > >
> > > >
> > > > Hi,
> > > >
> > > > Did you arrange security settings for the browsing reports?
> > > >
> > > > You should grant "Browser" Role to Guests or everyone from the Report
> > > > Manager to the folder where your reports are.
> > > >
> > > > Eralper
> > > > http://www.kodyaz.com
> > > >
> > > > "JJ" wrote:
> > > >
> > > > > Hi All,
> > > > >
> > > > > I have the following going on: A win 2k3 server running sql server and
> > > > > reporting services. I have IIS configured on it and can run reports
> > > > > internally on my network but when I try to access a report from the web I get
> > > > > nothing back. I can access my web projects but cant access and display
> > > > > reports from web. I am using a static ip address to access the website for
> > > > > now. I don't have a domain name setup for this box yet if that makes a
> > > > > difference. and internally when I refer to the box in the website I use the
> > > > > boxs computer name. Any ideas on what could be wrong here?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > JJ|||When you mean grant access to everyone do you mean use IUSR_Compname account
and assign to folders.
By the way I really like your website! Any ideas on what's causing the
error? Would like to access it again. Did you build it yourself?
Thanks,
JJ
"eralper" wrote:
> Hi,
> Actually my configuration differs from yours with my web server is IIS5
> working on Win2k. But I believe this will not cause a problem for anonymous
> access to reports after the steps I'll try to summarize below.
> Considering the site security, I'm not sure this is the best practice for
> reporting services application but it seems working.
> First you can view and run reports without problem because default
> authentication method for virtual directories "Reports" and "ReportServer" is
> window authentication. And I think you browse the reports with an admin group
> user.
> With these default configurations of the setup of Reporting Services, your
> buddy should be able to get the username and password screen for windows
> authentication when he calls http://YourIPComesHere/Reports
> If you change IIS permissions for these two virtual directories (Reports &
> ReportServer), your buddy should see an empty page because the internet guest
> account has no browser role permission on none of the folders below home
> (pointing VS.Net Reporting Services projects) or the individual reports in
> those folders.
> So before switching to anonymous access on these virtual directories, you
> should grant Browser role permission to "everyone" in approtiate folders and
> reports.
> I used "everyone", I do not know if it makes sense for IUSR_ComputerName
> So first go to Home directory (http://YourServer/Reports). Select Properties
> tab for Home and hit the "New Role Assignment" button to add "everyone" as
> Browser. By doing this, anonymous users will be able to list contents of the
> Reports folder.
> Second, select "Detailed View" and "Edit" the report folder where your
> reports are deployed. Go to Security tab and add "everyone" as Browser.
> I'm not sure but you may need to repeat a similar step (adding everyone as
> Browser) for the reports.
> You should hide the datasources in the list by editing their properties.
> Check the "hide in list view" option in General tab.
> One important note: you must edit RSWebApplication config file in
> "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager" folder (default place for this configuration file)
> Update ReportServerURL by changing the computer name with your IP. Otherwise
> users will be able reach the report but will not be able to see it processing.
> Now is time for changing the permissions of the two virtual directories
> Reports and ReportServer via IIS Manager. Go to properties of the virtual
> directories then select directory security tab. And allow anonymous access.
>
> This configuration works for me. I hope you may find something useful within
> my notes.
> Eralper
> http://www.kodyaz.com
> "JJ" wrote:
> > Hi Eralper,
> >
> > I tried to access your website but I keep on getting Obj ref not set
> > error. This is happening even when I enter www. kodyak.com.
> >
> > Thanks,
> >
> > JJ
> >
> > "eralper" wrote:
> >
> > > Hi JJ,
> > >
> > > I tried to give a detailed answer on
> > > http://www.kodyaz.com/ShowPost.aspx?PostID=19
> > >
> > > I hope it helps.
> > >
> > > Eralper
> > > http://www.kodyaz.com
> > >
> > >
> > > "JJ" wrote:
> > >
> > > > Hi eralper,
> > > >
> > > > Man I am so feed up trying to get Reporting Services to be accessed from
> > > > the web. I have windows 2003 server running Sql Server 2000 with Reporting
> > > > Services sp2 installed. I can see and execute the reports through Report
> > > > Manager with no problem internally. But when I have a buddy check out the
> > > > website using an IP address. He gets nothing. I have setup roles for
> > > > IUSR_Account as browser role and assigned the report trying to access to the
> > > > security property under report. In the datasource for report I have included
> > > > the user name and password that matchs a windows account mapped to a Sql
> > > > server user account. No problem there. How do you have IIS setup under
> > > > Directory securities for Report and Report Manager set?
> > > >
> > > > I don't have a domain name setup for this server yet. I am using Static IP
> > > > address for the moment. Are you using SSL for Reporting Services? What else
> > > > should I check?
> > > >
> > > > Thanks,
> > > >
> > > > JJ
> > > >
> > > >
> > > > "eralper" wrote:
> > > >
> > > > >
> > > > > Hi,
> > > > >
> > > > > Did you arrange security settings for the browsing reports?
> > > > >
> > > > > You should grant "Browser" Role to Guests or everyone from the Report
> > > > > Manager to the folder where your reports are.
> > > > >
> > > > > Eralper
> > > > > http://www.kodyaz.com
> > > > >
> > > > > "JJ" wrote:
> > > > >
> > > > > > Hi All,
> > > > > >
> > > > > > I have the following going on: A win 2k3 server running sql server and
> > > > > > reporting services. I have IIS configured on it and can run reports
> > > > > > internally on my network but when I try to access a report from the web I get
> > > > > > nothing back. I can access my web projects but cant access and display
> > > > > > reports from web. I am using a static ip address to access the website for
> > > > > > now. I don't have a domain name setup for this box yet if that makes a
> > > > > > difference. and internally when I refer to the box in the website I use the
> > > > > > boxs computer name. Any ideas on what could be wrong here?
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > JJ|||Hi,
I wrote "everyone" which will include "IUSR_Compname" also in the textbox
while defining a new role for folders. But I believe "IUSR_Compname" will
also work.
Thanks for your appreciation. One of my friends also said he had a problem
after the first use of the site. I will be checking what is going on and
inform you :)
"JJ" wrote:
> When you mean grant access to everyone do you mean use IUSR_Compname account
> and assign to folders.
> By the way I really like your website! Any ideas on what's causing the
> error? Would like to access it again. Did you build it yourself?
> Thanks,
> JJ
> "eralper" wrote:
> > Hi,
> >
> > Actually my configuration differs from yours with my web server is IIS5
> > working on Win2k. But I believe this will not cause a problem for anonymous
> > access to reports after the steps I'll try to summarize below.
> >
> > Considering the site security, I'm not sure this is the best practice for
> > reporting services application but it seems working.
> >
> > First you can view and run reports without problem because default
> > authentication method for virtual directories "Reports" and "ReportServer" is
> > window authentication. And I think you browse the reports with an admin group
> > user.
> >
> > With these default configurations of the setup of Reporting Services, your
> > buddy should be able to get the username and password screen for windows
> > authentication when he calls http://YourIPComesHere/Reports
> >
> > If you change IIS permissions for these two virtual directories (Reports &
> > ReportServer), your buddy should see an empty page because the internet guest
> > account has no browser role permission on none of the folders below home
> > (pointing VS.Net Reporting Services projects) or the individual reports in
> > those folders.
> >
> > So before switching to anonymous access on these virtual directories, you
> > should grant Browser role permission to "everyone" in approtiate folders and
> > reports.
> > I used "everyone", I do not know if it makes sense for IUSR_ComputerName
> >
> > So first go to Home directory (http://YourServer/Reports). Select Properties
> > tab for Home and hit the "New Role Assignment" button to add "everyone" as
> > Browser. By doing this, anonymous users will be able to list contents of the
> > Reports folder.
> >
> > Second, select "Detailed View" and "Edit" the report folder where your
> > reports are deployed. Go to Security tab and add "everyone" as Browser.
> >
> > I'm not sure but you may need to repeat a similar step (adding everyone as
> > Browser) for the reports.
> >
> > You should hide the datasources in the list by editing their properties.
> > Check the "hide in list view" option in General tab.
> >
> > One important note: you must edit RSWebApplication config file in
> > "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\ReportManager" folder (default place for this configuration file)
> > Update ReportServerURL by changing the computer name with your IP. Otherwise
> > users will be able reach the report but will not be able to see it processing.
> >
> > Now is time for changing the permissions of the two virtual directories
> > Reports and ReportServer via IIS Manager. Go to properties of the virtual
> > directories then select directory security tab. And allow anonymous access.
> >
> >
> > This configuration works for me. I hope you may find something useful within
> > my notes.
> >
> > Eralper
> > http://www.kodyaz.com
> >
> > "JJ" wrote:
> >
> > > Hi Eralper,
> > >
> > > I tried to access your website but I keep on getting Obj ref not set
> > > error. This is happening even when I enter www. kodyak.com.
> > >
> > > Thanks,
> > >
> > > JJ
> > >
> > > "eralper" wrote:
> > >
> > > > Hi JJ,
> > > >
> > > > I tried to give a detailed answer on
> > > > http://www.kodyaz.com/ShowPost.aspx?PostID=19
> > > >
> > > > I hope it helps.
> > > >
> > > > Eralper
> > > > http://www.kodyaz.com
> > > >
> > > >
> > > > "JJ" wrote:
> > > >
> > > > > Hi eralper,
> > > > >
> > > > > Man I am so feed up trying to get Reporting Services to be accessed from
> > > > > the web. I have windows 2003 server running Sql Server 2000 with Reporting
> > > > > Services sp2 installed. I can see and execute the reports through Report
> > > > > Manager with no problem internally. But when I have a buddy check out the
> > > > > website using an IP address. He gets nothing. I have setup roles for
> > > > > IUSR_Account as browser role and assigned the report trying to access to the
> > > > > security property under report. In the datasource for report I have included
> > > > > the user name and password that matchs a windows account mapped to a Sql
> > > > > server user account. No problem there. How do you have IIS setup under
> > > > > Directory securities for Report and Report Manager set?
> > > > >
> > > > > I don't have a domain name setup for this server yet. I am using Static IP
> > > > > address for the moment. Are you using SSL for Reporting Services? What else
> > > > > should I check?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > JJ
> > > > >
> > > > >
> > > > > "eralper" wrote:
> > > > >
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > > Did you arrange security settings for the browsing reports?
> > > > > >
> > > > > > You should grant "Browser" Role to Guests or everyone from the Report
> > > > > > Manager to the folder where your reports are.
> > > > > >
> > > > > > Eralper
> > > > > > http://www.kodyaz.com
> > > > > >
> > > > > > "JJ" wrote:
> > > > > >
> > > > > > > Hi All,
> > > > > > >
> > > > > > > I have the following going on: A win 2k3 server running sql server and
> > > > > > > reporting services. I have IIS configured on it and can run reports
> > > > > > > internally on my network but when I try to access a report from the web I get
> > > > > > > nothing back. I can access my web projects but cant access and display
> > > > > > > reports from web. I am using a static ip address to access the website for
> > > > > > > now. I don't have a domain name setup for this box yet if that makes a
> > > > > > > difference. and internally when I refer to the box in the website I use the
> > > > > > > boxs computer name. Any ideas on what could be wrong here?
> > > > > > >
> > > > > > > Thanks,
> > > > > > >
> > > > > > > JJ