Reporting services error

Question

Reporting services error

AAkula

SSCertifiable

Points: 5394
More actions
February 6, 2009 at 12:21 pm

#130609

Hello,
I installed the reporting services and configured through Report server configuration manager. Now Iam trying to connect Reporting services through management studio Iam getting the below error.
TITLE: Connect to Server
------------------------------
Cannot connect to ABC\INS1.
------------------------------
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
System.Web.HttpException: The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files'.
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
[HttpException (0x80004005): The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files'.]
System.Web.HttpRuntime.SetUpCodegenDirectory(CompilationSection compilationSection) +2734342
System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags) +393
[HttpException (0x80004005): The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files'.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +2739623
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +2739533
Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

--. (Microsoft.SqlServer.Management.UI.RSClient)
And when Iam trying to connect in internet explorer http://abc/reportserver$ins1 iam getting page can not found.
plz suggest me what have to do to resolve this issue
Thanks

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

Your error tells me you are in x64 operating system so you have to tell me what version of SQL Server you are running x64 which 64bits or x86 which 32bits and I will show you how to configure IIS 6 correctly and apply the relevant permissions.

Kind regards,
Gift Peddie

Ahmad Osama SSCertifiable Points: 7676 More actions · Answer 2

Add user network services to the temporary aspnet folder and give full control....hope it helps

Regards,
[font="Verdana"]Sqlfrenzy[/font]

AAkula SSCertifiable Points: 5394 More actions · Answer 3

Thanks Peddie,

We are using Sql server 2005 Developer edition x64 on Windows 2003 R2 EE. Could you please tell me how can I configure Reporting services with out any errors

Thanks

AAkula SSCertifiable Points: 5394 More actions · Answer 4

Hi,

We have a separate Reporting server(serverA)and we have another server(serverB) in which we are going to store report server database and report servertempdb.In this case do we need to install reporting services in serverB?

Because when configuring reporitng services from ServerA,via report configuration manager, when I connected the instance in server2 and click start it is trying to start reporting services in server2.But we did not installed reporting services in server2

So my question is do we need to install reporting services in server2 also?

We just installed the reporting services in serverA.

plz explain me

Thanks

Ahmad Osama SSCertifiable Points: 7676 More actions · Answer 5

kotlas7 (2/7/2009)
Hi,
We have a separate Reporting server(serverA)and we have another server(serverB) in which we are going to store report server database and report servertempdb.In this case do we need to install reporting services in serverB?

why do u want to have report server database on a different server

Regards,
[font="Verdana"]Sqlfrenzy[/font]

AAkula SSCertifiable Points: 5394 More actions · Answer 6

thats our management decision...for better performance

We have 2 servers, ServerA is a separate reporting server and ServerB has a named instance ins1, which should store report server and report servertempdb

We installed reporting services in ServerA.Now I went to Reportserver configuration and seleted the machine name as serverB and instance ins1 and went through all the steps and report server and report servertempdb.

So far everything is fine. when I went to IIS manager in serverA, I did not see any websites but I can see the websites reports and report server in ServerB iis.

So iam confused here..because the websites should be created in serverA right?

Plz advice me...

Gift Peddie SSC Guru Points: 73570 More actions · Answer 7

You actually have a better set up that is scalable you just need to make sure you use a shared datasource to make sure all your reports run. You may need to add the permissions back in the designer because Reporting Services sometimes drop the permissions, when that happens open the connection property anywhere in the designer it will be empty add it again.

IIS 6 comes locked down to render only static html so if you don't have another application remove it and add it again this time click on details and all the components needed to run Asp.net. Then go to the location below in your C drive and run aspnet_regiis the switches are in the first link below and make sure Windows authentication is enabled because it is required for SSRS. The last two links show all the folder permissions relevant to IIS6 apply as needed.

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

http://msdn.microsoft.com/en-us/library/k6h9cz8h(VS.80).aspx

http://support.microsoft.com/kb/812614

http://msdn.microsoft.com/en-us/library/kwzs111e.aspx

(Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.)

You need to change the above code because SQL Server uses UCS-2 so you need to use collation in your code to get language specific text and you can save your .sql files with the langauge you need when you click save as in SMS you click on the arrow for all the langauges you can use.

Hey this post is kind of long so let me know if you need any more I can explain.

Kind regards,
Gift Peddie

Ahmad Osama SSCertifiable Points: 7676 More actions · Answer 8

thats our management decision...for better performance

do u mind telling us that how this will better the performance.

Regards,
[font="Verdana"]Sqlfrenzy[/font]

AAkula SSCertifiable Points: 5394 More actions · Answer 9

thank you..

I resolved the issue and I configured the repoting services in serverA and created report server database and report servertempdb in serverB in ins1.

Now went to IIS manager->default websites->reports->browse Iam able to get reporting services Home page(see the attached screen shot).But when open the internet explorer and give the url as

http://serverA/reports$instancename Iam getting page not found error.

when I entered http://serverA/reports Iam able to see the reporting services home page.

But from the link http://msdn.microsoft.com/en-us/library/ms403426(SQL.90).aspx if we have a named instance we need to give http://server01/reportserver$instance right?

and from above do I need to give the instance name from serverA(I installed the reporting services as named instance ssrs in ServerA) or do I need to give the instance name from serverB(where the report server database is created)?

and if everything works fine, and developers wants to deploy their RDL files in serverA how and where should I give the permissions?

do I need to creste the logins in serverB instance and give them read permissions to report server?

or do I need to do anything any serverA?

Plz clarify me..

Thanks in advance for your help

Gift Peddie SSC Guru Points: 73570 More actions · Answer 10

The only thing you need from server B where your Datasource Database is the connection string to create your shared datasource.

When the reports are developed you need to give your developers deployment permissions which is higher than read only because we once got read permissions and we could not access Report Manager to upload the RDL and solution files needed to run the reports. If you don't want to give that permissions then you can take the deployment but some times SSRS will drop the connection information and it must be added back and the developers can take care of that.

Kind regards,
Gift Peddie

AAkula SSCertifiable Points: 5394 More actions · Answer 11

Thank you.

you mean I need to create logins for developers in ServerB to access report server database?

If they deploy rdls in serverB, what will be the process go in serverA?

and also please clarify me that in the internet explorer what will be the URL I need give?

http://serverA/reportserver or

http://serverA/reportserver$ssrs(instance name in serverA) or

http://serverA/reportserver$ins1(instance name in serverB, which has reportserver database)

Thanks for your help

Gift Peddie SSC Guru Points: 73570 More actions · Answer 12

Your developers need to access the server with reporting services so they can upload the RDL and Solution files and images if your reports used images. Here are the configurations including the report manager. If you don't give them the permissions you have to do the work.

http://msdn.microsoft.com/en-us/library/ms159261(SQL.90).aspx

Kind regards,
Gift Peddie

AAkula SSCertifiable Points: 5394 More actions · Answer 13

Hi Osama,

From BOL..

The databases can run on a local or remote SQL Server instance. Choosing a local instance is useful if you have sufficient system resources or want to conserve software licenses, but running the databases on a remote computer can improve performance.

I did not go through indetail, but definately this approach improves performance.

AAkula SSCertifiable Points: 5394 More actions · Answer 14

Hi Peddie,

Using the deploy option in visual studio or BIDS allows the developer to deploy rdl files to SSRS(ServerA).I went through the system level and item level roles in Report manager. So inorder to deploy the rdls from visual studio to SSRS server which role and permission I should give

Thanks

Kotla