Is Licence copy of Sql Server needed even for localhost\report

Question

Is Licence copy of Sql Server needed even for localhost\report

indhu06

Grasshopper

Points: 12
More actions
December 10, 2007 at 5:17 am

#377442

hi,
I'm a newbie to reporting services.
I created a report using business intelligence prjt and i'm not able to deploy it.
its giving the following error
"A connection could not be made to the report server http://localhost/ReportServer%5B/color%5D"
I only hv the sql client running in my lcoal machine. Do i need a licensed copy(in my local machine) to deploy the report in my own local server...
....in the process of learning reporting services
any help is appreciated.
Thank you

Viewing 10 posts - 1 through 9 (of 9 total)

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

mdaniel SSCarpal Tunnel Points: 4616 More actions · Answer 1

Check on the Configuration Manager that both SQL Server and Reporting Services are started. Also check that IIS is started.

Can you see the main directory when you browse to http://localhost/reportserver with Internet Explorer?

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 2

The error you're getting assumes that you're trying to publish to a local IIS installation. In order to do that you'd need SSRS installed on that machine. You can configure SSRS to use a remote database engine however.

Regardless of how you configure it - the machine running SSRS would have to be licensed for SQL Server (so - with the remote database server, that's 2 licenses + however many CAL's you need for the report users+however many CAL's are required to connect to DB).

Here's the BOL on the installation piece: http://msdn2.microsoft.com/en-us/library/ms143703.aspx%5B/url%5D

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

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

As Matt said you need SQL Server running to run the BID developed reports however there is free alternative that comes with the SQL Server Express Advanced Tool Kit version it is a limited features reporting services you can use with both Winform and Webform applications. Try the link below for details.

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

Kind regards,
Gift Peddie

indhu06 Grasshopper Points: 12 More actions · Answer 4

Thank you for your replies..

i followed "http://msdn2.microsoft.com/en-us/library/ms143703.aspx" link and got til here..

I'm getting the following error in "http://localhost/Reportserver/

Reporting Services 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.5\Reporting Services\ReportServer\RSReportServer.config' is denied.

--------------------------------------------------------------------------------

SQL Server Reporting Services

and

Error

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

Home

in "http://localhost/Reports" page..

my windows service is running..

and the sql server instance is also running in Reporting Services Configuration..

please help..

indhu06 Grasshopper Points: 12 More actions · Answer 5

i solved the issue

Followed "http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=184301&SiteID=1" post

Gave read permission to the rsreportserver.config file to /aspnet user..

thank u all..

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

That version of SQL Server is for development only you cannot deploy that code, when it comes time to run that code in production you will need the option Matt offered you. The reason the developer edition is under $40 on the web full the Enterprise edition cost many thousand dollars. Hope this helps.

Kind regards,
Gift Peddie

indhu06 Grasshopper Points: 12 More actions · Answer 7

Thanks Gift.

This is wat i hv understood

I dont need licenced copy of sql server to deploy reports in my local machine(for development purpose), but i need licensed copy of sql server to deploy in a remote server(production).

plz correct me if i'm wrong..

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

Remote is not the operative word because you can connect to the developer edition in a remote box if you are developing. You cannot use it for production local or remote.

Kind regards,
Gift Peddie

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 9

indhu06 (12/11/2007)
Thanks Gift.
This is wat i hv understood
I dont need licenced copy of sql server to deploy reports in my local machine(for development purpose), but i need licensed copy of sql server to deploy in a remote server(production).
plz correct me if i'm wrong..

No - you get to use the developer licensing (again - about 40$ per copy) for your development needs, and you get to use "real" licensing for production, (unless you manage to be able to run your reporting from the crippled Reporting Services in a SQLExpress installation). Like gift pointed out - doesn't matter WHERE you or the server are.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?