Reporting Services

Authentication via internet explorer fails when connecting to reporting
services from a hostname other then the NETBIOS name.
for example my servers name is BOB
so if i do http://bob/ReportServer it works fine
I have an A record that points reportingservices.mydomain.com to BOB's ip
address
so if i go to http://reportingservices.mydomain.com/ReportServer I get the
user credentials box. How can I fix this?On Mar 2, 9:06 pm, Nick T <N...@.discussions.microsoft.com> wrote:
> Authentication via internet explorer fails when connecting to reporting
> services from a hostname other then the NETBIOS name.
> for example my servers name is BOB
> so if i dohttp://bob/ReportServerit works fine
> I have an A record that points reportingservices.mydomain.com to BOB's ip
> address
> so if i go tohttp://reportingservices.mydomain.com/ReportServerI get the
> user credentials box. How can I fix this?
It seems like you should check the authentication methods of the
virtual directory pointed to in IIS for http://reportingservices.mydomain.com/ReportServer.
Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||The virtual directory is just part of the default web site
"EMartinez" wrote:
> On Mar 2, 9:06 pm, Nick T <N...@.discussions.microsoft.com> wrote:
> > Authentication via internet explorer fails when connecting to reporting
> > services from a hostname other then the NETBIOS name.
> >
> > for example my servers name is BOB
> >
> > so if i dohttp://bob/ReportServerit works fine
> >
> > I have an A record that points reportingservices.mydomain.com to BOB's ip
> > address
> >
> > so if i go tohttp://reportingservices.mydomain.com/ReportServerI get the
> > user credentials box. How can I fix this?
> It seems like you should check the authentication methods of the
> virtual directory pointed to in IIS for http://reportingservices.mydomain.com/ReportServer.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||Hello,
I think this situation depends on security settings in IE.
Try to add http://reportingservices.mydomain.com/ website to your trusted
websites.
If still you 'll be prompted for login and password check security settings
in IE (for trusted sites).
Ensure that you have checked the last option for logging user (logging with
current user name and password).
I hope this will help.
Best regards,
Rados³aw £ebkowski
U¿ytkownik "Nick T" <NickT@.discussions.microsoft.com> napisa³ w wiadomo¶ci
news:2821371F-75FC-4BC7-A0E0-B7B01A512874@.microsoft.com...
> Authentication via internet explorer fails when connecting to reporting
> services from a hostname other then the NETBIOS name.
> for example my servers name is BOB
> so if i do http://bob/ReportServer it works fine
> I have an A record that points reportingservices.mydomain.com to BOB's ip
> address
> so if i go to http://reportingservices.mydomain.com/ReportServer I get the
> user credentials box. How can I fix this?

Reporting Maneger Failed

Hi

When I try to run de ReportManeger in the internet explorer, Show an error:

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

Well, I check and te Report server is running.

When I try to run de ReportServer in the internet explorer, Show an error:

The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)

Access to the path 'c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is denied.

Also when I try to use de Surface Area Configuration for Features, Windows Integrate Security, this errror is showing

TITLE: Surface Area Configuration

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName)
at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)
at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)
at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()
at Microsoft.ReportingServices.WebServer.Global.StartApp()
at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}

</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul>
<li>Access to the path 'c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\RSReportServer.config' is denied.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (System.Web.Services)

Please I Need HELP

Seems that the service account Reporting Server is running under, has not the appropiate permissions to access the directory on the path mentioned. Use an account which has the permissions to read the file, e.g. the local system account.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thank you VERY MUCH, I change to local system and naw de Reporting Service is running. But when i try to run de Report Builder show a next error

System.Web.Serveces.Protocols.SoapException:The Feature:"Report builder and reportmodels" is not supported in this edition of Reporting Service.-->

Microsoft.ReportingServices.Diagnostics.Utilities.OperationNoSopportedException:The Feature: "Reportbuilder and reportmodels" is not supported in this edition of Report Sevices.

I take this programn in Microsoft, and I registrate this copy. But I don′t undertand, because I didn′t see that this version has a limitation. Well I work with VB express edition and SQL express and I try to meke a reports, but it′s incredable, i can do. Anything works.

Please can You help what i can do?

Thank you for your time.

Ruth

|||I guess you have right now the Express Advanced edition, right ? Report Builder is only supported within Workgroup, Standard and Enterprise Edition. Sorry.

HTH; Jens Suessmeyer.

http://www.sqlserver2005.de

Reporting in SQL Server

Hi,
I am developing a Intranet application using the Internet Browser as the cli
ent interface. My client needs various kinds of reports which he has to view
in the Browser. Are there any standard API's that generate the reports in H
TML format in SQL Server. A
ny help would be much appreciated. One more thing, I need to print the repor
ts to a local Dot Matrix printer. Is there any place where I can get some in
formation.
Thanks in advance
Aditya.Seen this? http://www.microsoft.com/sql/reporting/
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Aditya" <anonymous@.discussions.microsoft.com> wrote in message
news:8C056CC2-FAF8-463E-9F40-DA598685D628@.microsoft.com...
Hi,
I am developing a Intranet application using the Internet Browser as the
client interface. My client needs various kinds of reports which he has to
view in the Browser. Are there any standard API's that generate the reports
in HTML format in SQL Server. Any help would be much appreciated. One more
thing, I need to print the reports to a local Dot Matrix printer. Is there
any place where I can get some information.
Thanks in advance
Aditya.|||Hi Narayana Vyas,
Thank you for the reply. I have seen that. Presently I cannot recommend this
for the client for two reasons:
1. The reporting service is still in Beta
2. The application I am developing has been written in ASP and not .Net
I am currently writing server side components that do the complex database
interactions and the ASP that generates the dynamic HTML pages to display
the reports. I find this process too complicated and time consuming and
error prone. I was looking for any other efficient means for doing this
task.
I have another issue in this. I need to send the data (the report which the
user views in the browser) to a dot-matrix printer and it has to print in
text mode. Can you suggest any way for this?
Thanks in advance
Aditya.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:OYXFlFE4DHA.2276@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Seen this? http://www.microsoft.com/sql/reporting/
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Aditya" <anonymous@.discussions.microsoft.com> wrote in message
> news:8C056CC2-FAF8-463E-9F40-DA598685D628@.microsoft.com...
> Hi,
> I am developing a Intranet application using the Internet Browser as the
> client interface. My client needs various kinds of reports which he has to
> view in the Browser. Are there any standard API's that generate the

---

reports

quote:

---

> in HTML format in SQL Server. Any help would be much appreciated. One more
> thing, I need to print the reports to a local Dot Matrix printer. Is there
> any place where I can get some information.
> Thanks in advance
> Aditya.
>

---

|||1) Its release date is less than a week away
2) Its a web service so you can use it from ASP, you don't need the app to
be written in .NET however you'd probably find it a lot easier in .NET even
if you are not that familiar with it. You can also use URL access which may
be simpler in your scenario
Also,it is highly extensible, you can write delivery extensions for
Reporting Services such as Printer Delivery extensions. It in fact includes
a Printer Delivery Extension in the devloper samples with it. I agree its
not ideal if you are not familiar with .NET but it might be well worth
getting to know it :-)
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Aditya" <grafica@.md2.vsnl.net.in> wrote in message
news:%2342SQNE4DHA.2404@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Hi Narayana Vyas,
> Thank you for the reply. I have seen that. Presently I cannot recommend

---

this

quote:

---

> for the client for two reasons:
> 1. The reporting service is still in Beta
> 2. The application I am developing has been written in ASP and not .Net
> I am currently writing server side components that do the complex database
> interactions and the ASP that generates the dynamic HTML pages to display
> the reports. I find this process too complicated and time consuming and
> error prone. I was looking for any other efficient means for doing this
> task.
> I have another issue in this. I need to send the data (the report which

---

the

quote:

---

> user views in the browser) to a dot-matrix printer and it has to print in
> text mode. Can you suggest any way for this?
> Thanks in advance
> Aditya.
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:OYXFlFE4DHA.2276@.TK2MSFTNGP10.phx.gbl...
to[QUOTE]
> reports
more[QUOTE]
there[QUOTE]
>

---

|||Hi Jasper Smith,
Thanks for the information. I will give it a try. Meanwhile, if you get any
other information, please pass them.
Thank you
Aditya.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:#nQ8AFF4DHA.2380@.TK2MSFTNGP09.phx.gbl...

quote:

---

> 1) Its release date is less than a week away
> 2) Its a web service so you can use it from ASP, you don't need the app to
> be written in .NET however you'd probably find it a lot easier in .NET

---

even

quote:

---

> if you are not that familiar with it. You can also use URL access which

---

may

quote:

---

> be simpler in your scenario
> Also,it is highly extensible, you can write delivery extensions for
> Reporting Services such as Printer Delivery extensions. It in fact

---

includes

quote:

---

> a Printer Delivery Extension in the devloper samples with it. I agree its
> not ideal if you are not familiar with .NET but it might be well worth
> getting to know it :-)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Aditya" <grafica@.md2.vsnl.net.in> wrote in message
> news:%2342SQNE4DHA.2404@.TK2MSFTNGP10.phx.gbl...
> this
database[QUOTE]
display[QUOTE]
> the
in[QUOTE]
the[QUOTE]
has[QUOTE]
> to
> more
> there
>

---