Install RS in one machine

I have installed Reporting Services in two systems, server-client, without any problem.

Then I tried to add in the client the server part just to be able to work as standalone system.

The client is one W2003 with IIS and SQLServer, similar to the server machine.

I can built and generate a report with VStudio, but when I tried to implement in localhost it gives me error: a trust conection with the "remote" server" is not possible.
I can see in the Reports page that the folder for the report is created, but it is empty.
If I try the implementation in the smae project just changing the TargetUrl to the real remote server, it is working.

I have compared nearly all the security conditions in the localhost an remote servres, mainly the ones related to security, without finding any difference.

Has anyone installed Reporting Services in one system?Hi Robert,

I am developing all on one system. You might check that your Shared Datasource is
using "Use a specific and password" for Credentials and not "Use Windows Authentication".

Best Regards, Jane

Install RS 2000 with SQL 2005

Hello,
i want to install Reporting Services 2000 with SQL 2005 Express Edition. Is
this possible? Any problems?
THX
Andre ScheiberleBooks On LIne says that this functionality will be added to SQL Express soon
( the doc was dated Nov 7 2005.) However, if it is on your CD already - go
for it...I don't think you'll get Report Builder however
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Andre Scheiberle" wrote:
> Hello,
> i want to install Reporting Services 2000 with SQL 2005 Express Edition. Is
> this possible? Any problems?
> THX
> Andre Scheiberle
>|||"=?Utf-8?B?QW5kcmUgU2NoZWliZXJsZQ==?="
<AndreScheiberle@.discussions.microsoft.com> wrote in
news:469351AA-80FB-4AAF-B62E-FC4D7049E3EC@.microsoft.com:
> Hello,
> i want to install Reporting Services 2000 with SQL 2005 Express
> Edition. Is this possible? Any problems?
> THX
> Andre Scheiberle
>
WHY'?|||Maybe because no license needs to be paid?
Jan D''Hondt
Jade bvba
Belgium
Database and .NET development
<Toto, I''ve got a feeling we''re not in Kansas anymore.>
"Asher_N" wrote:
> "=?Utf-8?B?QW5kcmUgU2NoZWliZXJsZQ==?="
> <AndreScheiberle@.discussions.microsoft.com> wrote in
> news:469351AA-80FB-4AAF-B62E-FC4D7049E3EC@.microsoft.com:
> > Hello,
> > i want to install Reporting Services 2000 with SQL 2005 Express
> > Edition. Is this possible? Any problems?
> > THX
> > Andre Scheiberle
> >
> WHY'?
>|||You need a SQL 2000 license to install RS2000.
"=?Utf-8?B?SmFuIERIb25kdA==?=" <JanDHondt@.discussions.microsoft.com> wrote
in news:F6120D99-D7B8-4EB0-8E83-11FBF1827B66@.microsoft.com:
> Maybe because no license needs to be paid?
>
> --
> Jan D''Hondt
> Jade bvba
> Belgium
> Database and .NET development
> <Toto, I''ve got a feeling we''re not in Kansas anymore.>
>
>
> "Asher_N" wrote:
>> "=?Utf-8?B?QW5kcmUgU2NoZWliZXJsZQ==?="
>> <AndreScheiberle@.discussions.microsoft.com> wrote in
>> news:469351AA-80FB-4AAF-B62E-FC4D7049E3EC@.microsoft.com:
>> > Hello,
>> > i want to install Reporting Services 2000 with SQL 2005 Express
>> > Edition. Is this possible? Any problems?
>> > THX
>> > Andre Scheiberle
>> >
>> WHY'?
>|||Do you know a date when this functionality will be a added?
The installation and configuration works (tricky), but now I have a
Web-Application developed in .Net 2.0. Is it possible to configure RS 2000 to
run with .Net 2.0?
THX
Andre Scheiberle
"Wayne Snyder" wrote:
> Books On LIne says that this functionality will be added to SQL Express soon
> ( the doc was dated Nov 7 2005.) However, if it is on your CD already - go
> for it...I don't think you'll get Report Builder however
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Andre Scheiberle" wrote:
> > Hello,
> > i want to install Reporting Services 2000 with SQL 2005 Express Edition. Is
> > this possible? Any problems?
> > THX
> > Andre Scheiberle
> >|||We have a free SQL 2000 license and can use that. The installation with SQL
Express works (tricky) but now I have a Web-Application developed in .Net
2.0. Is there a way to configure RS 2000 to run with .Net 2.0?
THX
Andre Scheiberle
"Asher_N" wrote:
> You need a SQL 2000 license to install RS2000.
>
> "=?Utf-8?B?SmFuIERIb25kdA==?=" <JanDHondt@.discussions.microsoft.com> wrote
> in news:F6120D99-D7B8-4EB0-8E83-11FBF1827B66@.microsoft.com:
> > Maybe because no license needs to be paid?
> >
> >
> > --
> > Jan D''Hondt
> > Jade bvba
> > Belgium
> > Database and .NET development
> >
> > <Toto, I''ve got a feeling we''re not in Kansas anymore.>
> >
> >
> >
> >
> > "Asher_N" wrote:
> >
> >> "=?Utf-8?B?QW5kcmUgU2NoZWliZXJsZQ==?="
> >> <AndreScheiberle@.discussions.microsoft.com> wrote in
> >> news:469351AA-80FB-4AAF-B62E-FC4D7049E3EC@.microsoft.com:
> >>
> >> > Hello,
> >> > i want to install Reporting Services 2000 with SQL 2005 Express
> >> > Edition. Is this possible? Any problems?
> >> > THX
> >> > Andre Scheiberle
> >> >
> >>
> >> WHY'?
> >>
> >
> >
>|||I don'r believe it is possible.
"=?Utf-8?B?QW5kcmUgU2NoZWliZXJsZQ==?="
<AndreScheiberle@.discussions.microsoft.com> wrote in
news:67FB0B63-622B-4791-969C-E1F9117526C1@.microsoft.com:
> We have a free SQL 2000 license and can use that. The installation
> with SQL Express works (tricky) but now I have a Web-Application
> developed in .Net 2.0. Is there a way to configure RS 2000 to run with
> .Net 2.0?
> THX
> Andre Scheiberle
> "Asher_N" wrote:
>> You need a SQL 2000 license to install RS2000.
>>
>> "=?Utf-8?B?SmFuIERIb25kdA==?=" <JanDHondt@.discussions.microsoft.com>
>> wrote in news:F6120D99-D7B8-4EB0-8E83-11FBF1827B66@.microsoft.com:
>> > Maybe because no license needs to be paid?
>> >
>> >
>> > --
>> > Jan D''Hondt
>> > Jade bvba
>> > Belgium
>> > Database and .NET development
>> >
>> > <Toto, I''ve got a feeling we''re not in Kansas anymore.>
>> >
>> >
>> >
>> >
>> > "Asher_N" wrote:
>> >
>> >> "=?Utf-8?B?QW5kcmUgU2NoZWliZXJsZQ==?="
>> >> <AndreScheiberle@.discussions.microsoft.com> wrote in
>> >> news:469351AA-80FB-4AAF-B62E-FC4D7049E3EC@.microsoft.com:
>> >>
>> >> > Hello,
>> >> > i want to install Reporting Services 2000 with SQL 2005 Express
>> >> > Edition. Is this possible? Any problems?
>> >> > THX
>> >> > Andre Scheiberle
>> >> >
>> >>
>> >> WHY'?
>> >>
>> >
>> >
>>
>|||You will not be able to make RS2000 run under .NET 2.0, however you can
run .NET 2.0 websites side-by-side with .NET 1.1 or 1.0 websites
without any problem. To do this, you can use the "aspnet_regiis.exe"
utility to switch the sites to the correct .NET version of ASP.NET.
For example, if you have both v1.1 and v2.0 installed on your server,
but all websites are setup as v2.0 (since its installation updates the
ASP.NET settings)
You could do the following to reset the SRS websites to the v1.1
version of ASP.NET:
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -s
W3SVC/1/ROOT/ReportServer
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -s
W3SVC/1/ROOT/Reports
I hope this helps,
Lance Hunt
http://www.lance-hunt.net/

Install RS - Separate DB from Web

I am trying to install reporting services on a web server, which will connect
to an existing instance of the RS Sql Server backend on another machine.
This backend server already has SP2 installed - so when I install RS on the
web server machine and try to point to the existing backend during
installation, it tells me that it is not compatible.
What would be the correct steps to take in order to install on a web server
and connect to an existing RS backend DB? Any relevant articles will help...
Enjoy!
mikeFirst, are you implementing a web farm?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
news:9F638932-02F0-48DF-8EF9-A54EF42AF0FA@.microsoft.com...
>I am trying to install reporting services on a web server, which will
>connect
> to an existing instance of the RS Sql Server backend on another machine.
> This backend server already has SP2 installed - so when I install RS on
> the
> web server machine and try to point to the existing backend during
> installation, it tells me that it is not compatible.
> What would be the correct steps to take in order to install on a web
> server
> and connect to an existing RS backend DB? Any relevant articles will
> help...
> Enjoy!
> mike|||Not in the sense that I will have multiple ReportServer databases. I will
have a one to one relationship: 1 web server and 1 server with the
ReportServer database.
It was recommended that I do this by the server admins, in order to take the
load off of IIS.
"Bruce L-C [MVP]" wrote:
> First, are you implementing a web farm?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Michael R" <MichaelR@.discussions.microsoft.com> wrote in message
> news:9F638932-02F0-48DF-8EF9-A54EF42AF0FA@.microsoft.com...
> >I am trying to install reporting services on a web server, which will
> >connect
> > to an existing instance of the RS Sql Server backend on another machine.
> > This backend server already has SP2 installed - so when I install RS on
> > the
> > web server machine and try to point to the existing backend during
> > installation, it tells me that it is not compatible.
> >
> > What would be the correct steps to take in order to install on a web
> > server
> > and connect to an existing RS backend DB? Any relevant articles will
> > help...
> >
> > Enjoy!
> >
> > mike
>
>|||I would try this:
1) install SQL RS on the web server, and during the install, create new
SQL RS database(s) for it to point to / use (doesn't matter where you
put the DB, you'll end up dropping them soon). At the end of the
install, you'll have a new SQL RS web app, pointing to a new SQL RS db.
2) Apply SP1 to the SQL RS instance (web & new database).
3) Apply SP2 to the SQL RS instance (web & new database).
4) Now that you're web app is up to SP2, you can point it to your
original database using the 'rsconfig' command line utility (see SQL RS
Books Online for details of usage & syntax). After using 'rsconfig' to
point your app to the original database, you'll need to run the
'rskeymgmt' command line utility to initialize / activate your Report
Server for use with the original database (allows it to read the
original database) -- see Books Online for details of syntax and usage.
5) Drop the new SQL RS databases that were created in Step #1, since
you're not going to use them, now that your web app is pointing to the
'original' SP2 database.

Install Reporting Services on another IIS website

I am using IIS6 and installed Reporting Services on http://myWebsite in IIS.
This works fine and I can access http://myWebsite/ReportServer and http://myWebsite/Reports

My problem is that I also need Reporting Services on another website in IIS6.
I have a website http://www.myothersite.com which I also need Reporting Services on. I created two virtual directories (Reports,ReportServer) that point to the same directories as which the original Reporting Services site does, but it doesn't work. I get "You are not authorized to view this page message in IE." when I view http://www.myothersite.com/ReportViewer in my browser

Any suggestions?i dont think you would need to report managers. you would only need one report manager and create your folders in it and use the appropriate paths in various websites on the server.

hthsql

Install reporting services after SQL sp2

Hello,
our customer tried to update his existing SQL Server 64 Bit Enterprise
Edition with reporting services to SP2. During Setup there was an error with
the reporting services. So the customer decided to uninstall the reporting
services and applied SP2 successfully after that.
Now he needs the reporting services for a new application. Can i install the
reporting services from the original media and then upgrade that reporting
services installation to sp2?What do i have to take care of?
My plan was to install reporting services via software. Change SQL Server
Installation and add reporting services.
I tried that but the setup then comes up with the warning that there is a
version change. I think that is because the sql server has another
patchlevel than the original installation media. Can i ignore that?
thanks in advance
thomasHi Thomas
Although I haven't tried what you are doing, there is not really any
alternative as there is no slipstreamed releases of SQL Server that will go
straight in as SP2, so I guess you have to ignore the error and continue. It
is probably better to install this by hand!
John
"Thomas Oeser" wrote:
> Hello,
> our customer tried to update his existing SQL Server 64 Bit Enterprise
> Edition with reporting services to SP2. During Setup there was an error with
> the reporting services. So the customer decided to uninstall the reporting
> services and applied SP2 successfully after that.
> Now he needs the reporting services for a new application. Can i install the
> reporting services from the original media and then upgrade that reporting
> services installation to sp2?What do i have to take care of?
> My plan was to install reporting services via software. Change SQL Server
> Installation and add reporting services.
> I tried that but the setup then comes up with the warning that there is a
> version change. I think that is because the sql server has another
> patchlevel than the original installation media. Can i ignore that?
> thanks in advance
> thomas
>

install reporting services 2005

Do you or do you not need (have to have) an instance of sql server 2005
installed somewhere (the same machine, on the network, anywhere) in order to
install reporting services 2005?Yes, you DO need to have a SQL Server database engine available
somewhere, however it does not need to be 2005 (although, MS does not
recommend using 2000 db w/ RS 2005, because of limiting new feature
set).
The ReportServer piece uses (2) SQL Server databases, named
ReportServerDB and ReportServerTempDB, to store catalog information
(e.g., folders, report RDL, security info, settings, etc.).
Reporting Services, itself, is composed of 3 pieces: a windows
service, a web service application and a asp.net web application. All
of those must connect to a database somewhere so it can get the reports
you have stored, etc.
If you choose to use a remote database engine, you will need 2 licenses
of SQL Server:
- one for where you install the ReportingServices instance, and
- one for where the database engine is installed
You can also scale-out the Report Server to a web farm, so you would
have n number of IIS Web servers, each running their own license of SQL
Server, with only the Reporting Services installed, and configured in a
scale-out (web farm/files only) setup. You would then need a DB server
running its own license of SQL Server with the database engine.
I hope that answers your question and clears up any doubts.
Regards,
Thiago Silva|||One clarification. There is absolutely NO problem using a 2000 DB as the
metadata/cache for RS 2005. All features are available. This is both
supported and expected configuration. I am running that way. This is
separate from licensing. If you have everything on one box and you leave the
DB as 2000 and install/upgrade to RS 2005 then you need a SQL Server 2005
license.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"tafs7" <tsilva7@.gmail.com> wrote in message
news:1145312024.732011.199790@.z34g2000cwc.googlegroups.com...
> Yes, you DO need to have a SQL Server database engine available
> somewhere, however it does not need to be 2005 (although, MS does not
> recommend using 2000 db w/ RS 2005, because of limiting new feature
> set).
> The ReportServer piece uses (2) SQL Server databases, named
> ReportServerDB and ReportServerTempDB, to store catalog information
> (e.g., folders, report RDL, security info, settings, etc.).
> Reporting Services, itself, is composed of 3 pieces: a windows
> service, a web service application and a asp.net web application. All
> of those must connect to a database somewhere so it can get the reports
> you have stored, etc.
> If you choose to use a remote database engine, you will need 2 licenses
> of SQL Server:
> - one for where you install the ReportingServices instance, and
> - one for where the database engine is installed
> You can also scale-out the Report Server to a web farm, so you would
> have n number of IIS Web servers, each running their own license of SQL
> Server, with only the Reporting Services installed, and configured in a
> scale-out (web farm/files only) setup. You would then need a DB server
> running its own license of SQL Server with the database engine.
> I hope that answers your question and clears up any doubts.
> Regards,
> Thiago Silva
>|||Bruce is absolutely correct. I hope I didn't confuse you.
I am running, in production at a client, a scale out deployment of 2 RS
2005 servers, which uses a separate SQL 2000 db for storing the
catalog.
There are no known issues, and this is definetely supported. However,
what I meant is that you will find more MS documentation using all 2005
servers, because they would prefer you to license it that way, in order
to get the new features and benefits of the SQL 2005 database engine.
Regards,
Thiago Silva

Install reporting services (not DB) on 2003 Web Edition?

I am looking to deploy reporting services on two serves, one already running
SQL2000 plus an exisitng IIS Server.
The IIS server is running Windows 2003 Web Edition - is installing the
non-DB components of this edition of windows supported - cannot find the
into in the deployment guide!
Any thanks much appreciated.
Ian.Yes.
--
| From: "Ian Webster" <i.webster@.nos-pam.select.co.uk>
| Subject: Install reporting services (not DB) on 2003 Web Edition?
| Date: Thu, 28 Jul 2005 16:06:47 +0100
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#Ew1WY4kFHA.1480@.TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 217.206.61.36
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:49125
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I am looking to deploy reporting services on two serves, one already
running
| SQL2000 plus an exisitng IIS Server.
|
| The IIS server is running Windows 2003 Web Edition - is installing the
| non-DB components of this edition of windows supported - cannot find the
| into in the deployment guide!
|
| Any thanks much appreciated.
|
| Ian.
|
|
||||http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx
This article talks about deployment scenarios.
HTH,
""Brad Syputa - MS"" wrote:
> Yes.
> --
> | From: "Ian Webster" <i.webster@.nos-pam.select.co.uk>
> | Subject: Install reporting services (not DB) on 2003 Web Edition?
> | Date: Thu, 28 Jul 2005 16:06:47 +0100
> | Lines: 12
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <#Ew1WY4kFHA.1480@.TK2MSFTNGP10.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: 217.206.61.36
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:49125
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I am looking to deploy reporting services on two serves, one already
> running
> | SQL2000 plus an exisitng IIS Server.
> |
> | The IIS server is running Windows 2003 Web Edition - is installing the
> | non-DB components of this edition of windows supported - cannot find the
> | into in the deployment guide!
> |
> | Any thanks much appreciated.
> |
> | Ian.
> |
> |
> |
>

install Reporting service problem on SQL 2005 Express advanced Help please

Hi All,
I try to install reporting services with a french version of SQL 2005
Express Advanced on W2003 std SP1
Install of SQL2005 OK
When setup programm reach reporting service installation, i get an error
message( in french) :
"Le programme d'installation de SQL Server n'a pas pu récupérer le nom du
certificat SSL"
in English from my own translation : "SQL server installation program has
not been able to find SSL certificate"
This stop installation
detail of error give :
Linkid 20476
Nom du produit Microsoft sql Server
Version du Produit 9.00.2047.00
Source du mesage setup.rll
ID du message 29561
evtType
sqlca\sqlrsguica.cpp@.CheckRSSetupRequirements@.CheckRSSetupRequirements@.x7379
I try to install anyway reporting services via RSConfigTool
Install seems ok . Reporting services start ok
but http://mydomain/reports/Pages/folder.aspx give : Red cross Error
and message : "The request failed with HTTP status 400: Bad Request."
That we can find in C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
Services\LogFiles:
----
w3wp!ui!1!17/02/2007-12:02:13:: e ERROR: The request failed with HTTP status
400: Bad Request.
w3wp!ui!1!17/02/2007-12:02:13:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: The request failed with HTTP status 400: Bad
Request.
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at
Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
methodname)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!17/02/2007-12:02:13:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)
-----
Any idea '
MERCI beaucoup
Philippe
C.I.A ITI work around by desintalling IIS et re_install.
In fact i had installed a certificate via selfssl prior install reporting
services, as i have no option to remove this cerificate, the only way i
found, was to uninstall IIS
Philippe
"Philippe" <ph.boussaroque@.Espace-NTIC.com> a écrit dans le message de news:
ecmCyToUHHA.1364@.TK2MSFTNGP06.phx.gbl...
> Hi All,
> I try to install reporting services with a french version of SQL 2005
> Express Advanced on W2003 std SP1
> Install of SQL2005 OK
> When setup programm reach reporting service installation, i get an error
> message( in french) :
> "Le programme d'installation de SQL Server n'a pas pu récupérer le nom du
> certificat SSL"
> in English from my own translation : "SQL server installation program has
> not been able to find SSL certificate"
> This stop installation
> detail of error give :
> Linkid 20476
> Nom du produit Microsoft sql Server
> Version du Produit 9.00.2047.00
> Source du mesage setup.rll
> ID du message 29561
> evtType
> sqlca\sqlrsguica.cpp@.CheckRSSetupRequirements@.CheckRSSetupRequirements@.x7379
> I try to install anyway reporting services via RSConfigTool
> Install seems ok . Reporting services start ok
> but http://mydomain/reports/Pages/folder.aspx give : Red cross Error
> and message : "The request failed with HTTP status 400: Bad Request."
> That we can find in C:\Program Files\Microsoft SQL
> Server\MSSQL.2\Reporting Services\LogFiles:
> ----
> w3wp!ui!1!17/02/2007-12:02:13:: e ERROR: The request failed with HTTP
> status 400: Bad Request.
> w3wp!ui!1!17/02/2007-12:02:13:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The request failed with HTTP status 400: Bad
> Request.
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
> at
> Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
> methodname)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
> at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> level)
> at
> Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Page.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> w3wp!ui!1!17/02/2007-12:02:13:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)
> -----
> Any idea '
> MERCI beaucoup
> Philippe
> C.I.A IT
>
>

Install report server in msde

Dear all,
Is this possible to install report server in msde
If not, i am a new in reporting services, is it possible to develop and test
just install the report designer?Joe, the simple answer is no, as a minimum you'll need VB.Net 2003 and
SQL2000 Dev. Ed. around £30-£50 each in UK. You can almost fully test
reports in VB.Net but the Report Manager uses an HTML renderer where
the Development environment uses the RS.exe renderer so there can be
differences.
I think RS/SQL2005 is supposed to be able run reports completely stand
alone from SQL server. This is currently in a fairly advanced beta
stage.
Regards
Chris
Joe wrote:
> Dear all,
> Is this possible to install report server in msde
> If not, i am a new in reporting services, is it possible to develop
> and test just install the report designer?

Install Report Designer without SQL-Server-DBMS

Hi,
I would like to design Reporting Services-reports with Visual Studio .NET
2003 by using the Reporting Services Report Designer. VS 2003 .NET is
installed on my local machine (OS=Win XP Prof.) and the Report Server I want
to use is an already running Reporting Services installation (SQL Server
2000) which is available through the network. My question is: how can I
install the Report Designer on my local machine without installing the whole
SQL-Server DBMS?
Thanks in advance & kind regards
ChristianSelect only the design components when you install to your workstation.
-T
"Christian Nein" <no@.spam.com> wrote in message
news:u7T6Qc2eGHA.4932@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I would like to design Reporting Services-reports with Visual Studio .NET
> 2003 by using the Reporting Services Report Designer. VS 2003 .NET is
> installed on my local machine (OS=Win XP Prof.) and the Report Server I
> want to use is an already running Reporting Services installation (SQL
> Server 2000) which is available through the network. My question is: how
> can I install the Report Designer on my local machine without installing
> the whole SQL-Server DBMS?
> Thanks in advance & kind regards
> Christian
>|||I don't even see those options when running the setup (SQL Server 2000
Stand. Edition).
Am I running the wrong Setup? Is there a separate setup for the designer?
Regards
Christian
"Tim Dot NoSpam" <Tim.NoSpam@.hughes.net> wrote:
> Select only the design components when you install to your workstation.
> -T
> "Christian Nein" <no@.spam.com> wrote:
>> Hi,
>> I would like to design Reporting Services-reports with Visual Studio .NET
>> 2003 by using the Reporting Services Report Designer. VS 2003 .NET is
>> installed on my local machine (OS=Win XP Prof.) and the Report Server I
>> want to use is an already running Reporting Services installation (SQL
>> Server 2000) which is available through the network. My question is: how
>> can I install the Report Designer on my local machine without installing
>> the whole SQL-Server DBMS?
>> Thanks in advance & kind regards
>> Christian|||RS came out on a different schedule than SQL Server 2000 and comes on its
own media. With SQL 2005, RS 2005 is shipped with SQL 2005.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Christian Nein" <no@.spam.com> wrote in message
news:e5fQKp$eGHA.3640@.TK2MSFTNGP03.phx.gbl...
>I don't even see those options when running the setup (SQL Server 2000
>Stand. Edition).
> Am I running the wrong Setup? Is there a separate setup for the designer?
> Regards
> Christian
>
> "Tim Dot NoSpam" <Tim.NoSpam@.hughes.net> wrote:
>> Select only the design components when you install to your workstation.
>> -T
>> "Christian Nein" <no@.spam.com> wrote:
>> Hi,
>> I would like to design Reporting Services-reports with Visual Studio
>> .NET 2003 by using the Reporting Services Report Designer. VS 2003 .NET
>> is installed on my local machine (OS=Win XP Prof.) and the Report Server
>> I want to use is an already running Reporting Services installation (SQL
>> Server 2000) which is available through the network. My question is: how
>> can I install the Report Designer on my local machine without installing
>> the whole SQL-Server DBMS?
>> Thanks in advance & kind regards
>> Christian
>

Install Report Designer on XP

I am trying to install Report Designer on my XP development machine. We
already have Reporting Services Enterprise install on our SQL Server. When I
insert the CD it automatically attempts to install the Server components and
fails becuase it is an XP machine. I only want to install the client
components but the install never gets to that point. Is there a way that I
can just install the client from the CD and bypass the System check for the
server compnents.
ThanksNot sure, but I know that the 2005 Developer Edition will work for you,
if that's possible for you to do-
Matt A|||Is it 2000 or 2005 installation?
In 2000, if I remember well you still have the possibility to click on NEXT
and ignore the errors reported by the SCC tool. This will install only the
client tools.
In 2005, Select Workstation components, Books Online and development tools
on the Components to Install page
Med Bouchenafa
"Robert Willhite" <RobertWillhite@.discussions.microsoft.com> a écrit dans le
message de news: C20A2556-1C93-4880-966F-50AE546BCF4F@.microsoft.com...
>I am trying to install Report Designer on my XP development machine. We
> already have Reporting Services Enterprise install on our SQL Server.
> When I
> insert the CD it automatically attempts to install the Server components
> and
> fails becuase it is an XP machine. I only want to install the client
> components but the install never gets to that point. Is there a way that
> I
> can just install the client from the CD and bypass the System check for
> the
> server compnents.
> Thanks|||It is the 2000 edition. It never gets past the SCC tool errors. I
eventually get some kind of windows error. I will have to try it again
tomorrow morning to get the error.
Thanks
Rob Willhite
"Med Bouchenafa" wrote:
> Is it 2000 or 2005 installation?
> In 2000, if I remember well you still have the possibility to click on NEXT
> and ignore the errors reported by the SCC tool. This will install only the
> client tools.
> In 2005, Select Workstation components, Books Online and development tools
> on the Components to Install page
> Med Bouchenafa
> "Robert Willhite" <RobertWillhite@.discussions.microsoft.com> a écrit dans le
> message de news: C20A2556-1C93-4880-966F-50AE546BCF4F@.microsoft.com...
> >I am trying to install Report Designer on my XP development machine. We
> > already have Reporting Services Enterprise install on our SQL Server.
> > When I
> > insert the CD it automatically attempts to install the Server components
> > and
> > fails becuase it is an XP machine. I only want to install the client
> > components but the install never gets to that point. Is there a way that
> > I
> > can just install the client from the CD and bypass the System check for
> > the
> > server compnents.
> >
> > Thanks
>
>|||I am running Reporting Services Standard Edition
"Robert Willhite" wrote:
> I am trying to install Report Designer on my XP development machine. We
> already have Reporting Services Enterprise install on our SQL Server. When I
> insert the CD it automatically attempts to install the Server components and
> fails becuase it is an XP machine. I only want to install the client
> components but the install never gets to that point. Is there a way that I
> can just install the client from the CD and bypass the System check for the
> server compnents.
> Thanks

Install Report Designer (RS 2000) on VS2005 Express?

Does anyone know if it's possible to install the Report Designer component of Reporting Services 2000 on one the Visusal Studio Express versions? My client is running SQL Server 2000 in production, and wants to evaluate Reporting Services for an upcoming project. However, they aren't currently running any version of Visual Studio 2003. I know we can buy VB.Net 2003 and then install the report designer on that machine, but they'd like to get buy as cheaply as possible (like, free); hence the interest in using VS Express.
They don't want to commit to SQL Server 2005 or I'd suggest they install the CTP on a development machine and play with Reporting Services 2005.
Thanks,
Ericany solutions to this problem?sql

Install Question

Hello, if my company owns 6 processor licenses for Sql Server, am I able to
utilize Reporting Services or is their a separate license?Whether you need another license depends if you are installing RS on a box
that has SQL Server DB installed on it. You need a license for the box which
has RS installed. For instance, let's say I have a web farm with 3 IIS
servers all of which are using a single DB on another box. I need an
additional 3 SQL Server server licenses.
On the other hand, if I have IIS and RS running on the same box as SQL
Server DB, then RS falls under the license for the DB.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"tcs" <tcs@.discussions.microsoft.com> wrote in message
news:D677E056-F2A3-4373-812B-38480F0B0F39@.microsoft.com...
> Hello, if my company owns 6 processor licenses for Sql Server, am I able
> to
> utilize Reporting Services or is their a separate license?|||Right, so if I split out RS onto a different box, I am ok as long as I have a
license to cover it. So right now if we have 6 enterprise licenses, i could
farm it out over two boxes if desired?
"Bruce L-C [MVP]" wrote:
> Whether you need another license depends if you are installing RS on a box
> that has SQL Server DB installed on it. You need a license for the box which
> has RS installed. For instance, let's say I have a web farm with 3 IIS
> servers all of which are using a single DB on another box. I need an
> additional 3 SQL Server server licenses.
> On the other hand, if I have IIS and RS running on the same box as SQL
> Server DB, then RS falls under the license for the DB.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "tcs" <tcs@.discussions.microsoft.com> wrote in message
> news:D677E056-F2A3-4373-812B-38480F0B0F39@.microsoft.com...
> > Hello, if my company owns 6 processor licenses for Sql Server, am I able
> > to
> > utilize Reporting Services or is their a separate license?
>
>|||Definitely. What are you are talking about is a web farm. Several IIS
servers all using the same database for its object caching and metadata
storage. This is an enterprise feature. You need to have a SQL Server
Enterprise license for each IIS box that is running Reporting Services.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"tcs" <tcs@.discussions.microsoft.com> wrote in message
news:DFA03ABE-38AE-4CD3-B681-7535DF67A8DB@.microsoft.com...
> Right, so if I split out RS onto a different box, I am ok as long as I
> have a
> license to cover it. So right now if we have 6 enterprise licenses, i
> could
> farm it out over two boxes if desired?
>
> "Bruce L-C [MVP]" wrote:
>> Whether you need another license depends if you are installing RS on a
>> box
>> that has SQL Server DB installed on it. You need a license for the box
>> which
>> has RS installed. For instance, let's say I have a web farm with 3 IIS
>> servers all of which are using a single DB on another box. I need an
>> additional 3 SQL Server server licenses.
>> On the other hand, if I have IIS and RS running on the same box as SQL
>> Server DB, then RS falls under the license for the DB.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "tcs" <tcs@.discussions.microsoft.com> wrote in message
>> news:D677E056-F2A3-4373-812B-38480F0B0F39@.microsoft.com...
>> > Hello, if my company owns 6 processor licenses for Sql Server, am I
>> > able
>> > to
>> > utilize Reporting Services or is their a separate license?
>>sql

Install Problems with Report Server

I want to install Reporting Services to find out about how it works, but I'm
having problems.
I tried to install it on my Windows XP workstation to run with MSDE but got
the message:
"This edition of the Report Server Database is not supported on the edition
of SQL Server 2000 you have chosen. Please choose another SQL Server that
matches the requirements."
I therefore specified the name of one of our test servers running SQL Server
2000 and was able to proceed.
When I got to the screen that specified the "Server Farm" it asked for the
name of an existing install of Reporting Services. Since I don't already
have an existing install I left it empty, but was told I was unable to
proceed with the install unless I enter a value. I therefore named the
server I just was installing to.
When the install finished I got a message saying it wasn't possible to
initialise the report server and this would have to be done manually.
I tried connecting to the ReportServer web site but got the message:
The report server installation is not initialized. Check the documentation
for more information. (rsReportServerNotActivated) Get Online
Help -2147159550
I followed the instructions for manually activating the report server using
the reactivate utiltity, but when I tried to activate the server I got the
message:
"Failure obtaining information from remote WMI provider: Unable to find
Reporting Services WMI namespace on 192.111.1.224. Reporting Services may
not be installed."
How can I get Reporting Services running?You somehow got into the installation for a web farm. In a web farm you have
several RS servers all using the same database. That is definitely not what
you are doing. There is a readme file that explains how to install using the
commandline. When you have the database on a different server than Reporting
Services you need to use the commandline. Note that you will need to specify
an account that has admin priveleges with the database.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Robert Jones" <robert.jones@.btopenworld.com> wrote in message
news:ukytYm7YFHA.980@.TK2MSFTNGP12.phx.gbl...
>I want to install Reporting Services to find out about how it works, but
>I'm having problems.
> I tried to install it on my Windows XP workstation to run with MSDE but
> got the message:
> "This edition of the Report Server Database is not supported on the
> edition of SQL Server 2000 you have chosen. Please choose another SQL
> Server that matches the requirements."
> I therefore specified the name of one of our test servers running SQL
> Server 2000 and was able to proceed.
> When I got to the screen that specified the "Server Farm" it asked for the
> name of an existing install of Reporting Services. Since I don't already
> have an existing install I left it empty, but was told I was unable to
> proceed with the install unless I enter a value. I therefore named the
> server I just was installing to.
> When the install finished I got a message saying it wasn't possible to
> initialise the report server and this would have to be done manually.
> I tried connecting to the ReportServer web site but got the message:
> The report server installation is not initialized. Check the documentation
> for more information. (rsReportServerNotActivated) Get Online
> Help -2147159550
> I followed the instructions for manually activating the report server
> using the reactivate utiltity, but when I tried to activate the server I
> got the message:
> "Failure obtaining information from remote WMI provider: Unable to find
> Reporting Services WMI namespace on 192.111.1.224. Reporting Services may
> not be installed."
> How can I get Reporting Services running?
>
>

Install problem

I have been so far unsuccessful in getting Reporting Services
installed on our web server. This server will be used as the
ReportServer. All prerequisites have been installed. I keep getting
the same cryptic error:
Setting Internal Properties
Error code: 267
The suspect activity is in the middle of the log file as shown here.
It appears there is a problem in ReadSkuInfo.
Action start 17:28:24:
SetInstanceProperty.6ED6C379_934D_4B59_816D_25F6911C3538.
<Func Name='RedirectorCAX'>
Function=SetInstanceProperty
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: SetInstanceProperty
<Func Name='SetInstanceProperty'>
Using instanced id: MSSQL.1
<Func Name='ReadSkuInfo'>
GetTempFileName failed 267
<EndFunc Name='ReadSkuInfo' Return='267' GetLastError='267'>
<EndFunc Name='SetInstanceProperty' Return='267' GetLastError='267'>
Gathering darwin properties for failure handling.
<Func Name='DisplayErrorDialog'>
<Failure Type='Fatal' Error='267'>
<EndFunc Name='RedirectorCAX' Return='267' GetLastError='487'>
Action ended 17:29:36:
SetInstanceProperty.6ED6C379_934D_4B59_816D_25F6911C3538. Return value
3.
Thanks!
MarkAccording to the log:
GetTempFileName failed 267
Error 267 is 'The directory name is invalid'. Before this call is a call to
GetTempPath. It would seem this function is returning something invalid.
According to the docs:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fileio/base/gettemppath.asp
The GetTempPath function checks for the existence of environment variables
in the following order and uses the first path found:
1.. The path specified by the TMP environment variable.
2.. The path specified by the TEMP environment variable.
3.. The path specified by the USERPROFILE environment variable.
4.. The Windows directory.
Note that the function does not verify that the path exists.
Can you see if the function is returning something invalid? If so you will
need to fix this problem first.
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"MarkMurphy" <murphy@.murphysw.com> wrote in message
news:e061eb57.0407290935.637d561d@.posting.google.com...
> I have been so far unsuccessful in getting Reporting Services
> installed on our web server. This server will be used as the
> ReportServer. All prerequisites have been installed. I keep getting
> the same cryptic error:
> Setting Internal Properties
> Error code: 267
>
> The suspect activity is in the middle of the log file as shown here.
> It appears there is a problem in ReadSkuInfo.
> Action start 17:28:24:
> SetInstanceProperty.6ED6C379_934D_4B59_816D_25F6911C3538.
> <Func Name='RedirectorCAX'>
> Function=SetInstanceProperty
> <Func Name='SetCAContext'>
> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
> Doing Action: SetInstanceProperty
> <Func Name='SetInstanceProperty'>
> Using instanced id: MSSQL.1
> <Func Name='ReadSkuInfo'>
> GetTempFileName failed 267
> <EndFunc Name='ReadSkuInfo' Return='267' GetLastError='267'>
> <EndFunc Name='SetInstanceProperty' Return='267' GetLastError='267'>
> Gathering darwin properties for failure handling.
> <Func Name='DisplayErrorDialog'>
> <Failure Type='Fatal' Error='267'>
> <EndFunc Name='RedirectorCAX' Return='267' GetLastError='487'>
> Action ended 17:29:36:
> SetInstanceProperty.6ED6C379_934D_4B59_816D_25F6911C3538. Return value
> 3.
>
> Thanks!
> Mark|||Thanks Dan,
I was able to get past that error earlier this morning. When I tried
installing it from the console of the web server instead of through
terminal services, it mentioned the temp directory not being correct.
I went to the temp environmental variables and it had F:\temp and
F:\tmp. Well F drive doesn't exist on that server. So I changed it
to C and it got past that error.
Appreciate you getting back.
-Mark

install on a new server

Currently we have SQL server reporting services running on a win 2000 server
running IIS. I need to move the reporting services to a new server running
win 2003 w/ IIS. How do I go about installing this on the new server and
keeping the old settings and reports.
thanks
mikeSimulate a Farm installation , then de-activate the first node.
1. Install another Reporting Services on the new server, pointing to the
existing SQL Server repository. When setup is complete, you should see all of
your reports through that server, since the repository (database) is the
same. During the install , you will be taken through a (web farm) setup
screen that is slightly different then a regular stand-alone install. On that
screen you have to specifiy the new server . Do that.
2. after verifiing that you are able to access your reports throught the new
server via the browser, go ahead and de-activate the first node by deleting
rows 2 and 3 from the keys tables in the ReportServer database (the metabase
repository at this point will think it has only one server) , after that
restart the new report server.
3. Take the first RS sever offline. You have successfully performed the
migration.
"Mike Fremont" wrote:
> Currently we have SQL server reporting services running on a win 2000 server
> running IIS. I need to move the reporting services to a new server running
> win 2003 w/ IIS. How do I go about installing this on the new server and
> keeping the old settings and reports.
> thanks
> mike|||Note that this only works if you are using RS Enterprise (web farm does not
work with standard).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Nick" <Nick@.discussions.microsoft.com> wrote in message
news:A162A01B-ED4F-48A5-A149-6C658EACFE9A@.microsoft.com...
> Simulate a Farm installation , then de-activate the first node.
> 1. Install another Reporting Services on the new server, pointing to the
> existing SQL Server repository. When setup is complete, you should see all
of
> your reports through that server, since the repository (database) is the
> same. During the install , you will be taken through a (web farm) setup
> screen that is slightly different then a regular stand-alone install. On
that
> screen you have to specifiy the new server . Do that.
> 2. after verifiing that you are able to access your reports throught the
new
> server via the browser, go ahead and de-activate the first node by
deleting
> rows 2 and 3 from the keys tables in the ReportServer database (the
metabase
> repository at this point will think it has only one server) , after that
> restart the new report server.
> 3. Take the first RS sever offline. You have successfully performed the
> migration.
>
> "Mike Fremont" wrote:
> > Currently we have SQL server reporting services running on a win 2000
server
> > running IIS. I need to move the reporting services to a new server
running
> > win 2003 w/ IIS. How do I go about installing this on the new server
and
> > keeping the old settings and reports.
> >
> > thanks
> > mikesql

Install of SQL 2005

If a server is going to be used for just SQL database access - locally on the
WAN - is there any need for IIS?
Does installing reporting services and IIS degrade the machine.
I've got a client whose DBA is debating these issues with the tech who
installed OS and SQL...
DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
Services on another server later if it's ever needed.
Recommendations and opinions would be appreciated.
Best practice would usually dictate that IIS / SSRS are employed on another
machine. However, just like whether you should buy an SL55 AMG or a Toyota
Corolla, it depends...
A
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:9FF616F6-89A7-4B3C-B78E-566D976B25AF@.microsoft.com...
> If a server is going to be used for just SQL database access - locally on
> the
> WAN - is there any need for IIS?
> Does installing reporting services and IIS degrade the machine.
> I've got a client whose DBA is debating these issues with the tech who
> installed OS and SQL...
> DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
> Services on another server later if it's ever needed.
> Recommendations and opinions would be appreciated.
|||I agree. I would install bare essentials now, and add IIS/RS if/when needed.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eOtb68zxHHA.4352@.TK2MSFTNGP05.phx.gbl...
> Best practice would usually dictate that IIS / SSRS are employed on another machine. However,
> just like whether you should buy an SL55 AMG or a Toyota Corolla, it depends...
> A
>
>
> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
> news:9FF616F6-89A7-4B3C-B78E-566D976B25AF@.microsoft.com...
>
|||On Jul 15, 4:30 pm, Steve Z <Ste...@.discussions.microsoft.com> wrote:
> If a server is going to be used for just SQL database access - locally on the
> WAN - is there any need for IIS?
> Does installing reporting services and IIS degrade the machine.
> I've got a client whose DBA is debating these issues with the tech who
> installed OS and SQL...
> DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
> Services on another server later if it's ever needed.
> Recommendations and opinions would be appreciated.
As already echoed in the thread, start with your minimal footprint and
add as necessary. Reporting Services is pretty easy to get up and
running when need be. Just get your specifications and go from there.
|||Is there a reason to use a named instance?
Is there a reason to not use a named instance?
This will be a large enterprise server - over 1000 users - around 20 or so
buildings across town.
Opinions?
|||No and no. A named instance isn't different from a default instance except for how you access it
from a client (like only machinename or machinename\instancename). So do what feels natural for you.
Well, the one difference I can think of is resolution from machine (or host) name to port number,
when using the IP netlib.
For the default instance, the port is well known (1433). You can change this but that requires that
you specify that port in the client app.
For a named instance, the client queries the "SQL Server browser" service which relies what port
number the desired instance is using. This is done using port 1434, UDP.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:9A6F1BE0-5819-457A-8E07-86869FDF2BE7@.microsoft.com...
> Is there a reason to use a named instance?
> Is there a reason to not use a named instance?
> This will be a large enterprise server - over 1000 users - around 20 or so
> buildings across town.
> Opinions?

Install of SQL 2005

If a server is going to be used for just SQL database access - locally on the
WAN - is there any need for IIS?
Does installing reporting services and IIS degrade the machine.
I've got a client whose DBA is debating these issues with the tech who
installed OS and SQL...
DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
Services on another server later if it's ever needed.
Recommendations and opinions would be appreciated.Best practice would usually dictate that IIS / SSRS are employed on another
machine. However, just like whether you should buy an SL55 AMG or a Toyota
Corolla, it depends...
A
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:9FF616F6-89A7-4B3C-B78E-566D976B25AF@.microsoft.com...
> If a server is going to be used for just SQL database access - locally on
> the
> WAN - is there any need for IIS?
> Does installing reporting services and IIS degrade the machine.
> I've got a client whose DBA is debating these issues with the tech who
> installed OS and SQL...
> DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
> Services on another server later if it's ever needed.
> Recommendations and opinions would be appreciated.|||I agree. I would install bare essentials now, and add IIS/RS if/when needed.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eOtb68zxHHA.4352@.TK2MSFTNGP05.phx.gbl...
> Best practice would usually dictate that IIS / SSRS are employed on another machine. However,
> just like whether you should buy an SL55 AMG or a Toyota Corolla, it depends...
> A
>
>
> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
> news:9FF616F6-89A7-4B3C-B78E-566D976B25AF@.microsoft.com...
>> If a server is going to be used for just SQL database access - locally on the
>> WAN - is there any need for IIS?
>> Does installing reporting services and IIS degrade the machine.
>> I've got a client whose DBA is debating these issues with the tech who
>> installed OS and SQL...
>> DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
>> Services on another server later if it's ever needed.
>> Recommendations and opinions would be appreciated.
>|||On Jul 15, 4:30 pm, Steve Z <Ste...@.discussions.microsoft.com> wrote:
> If a server is going to be used for just SQL database access - locally on the
> WAN - is there any need for IIS?
> Does installing reporting services and IIS degrade the machine.
> I've got a client whose DBA is debating these issues with the tech who
> installed OS and SQL...
> DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
> Services on another server later if it's ever needed.
> Recommendations and opinions would be appreciated.
As already echoed in the thread, start with your minimal footprint and
add as necessary. Reporting Services is pretty easy to get up and
running when need be. Just get your specifications and go from there.|||Is there a reason to use a named instance?
Is there a reason to not use a named instance?
This will be a large enterprise server - over 1000 users - around 20 or so
buildings across town.
Opinions?|||No and no. A named instance isn't different from a default instance except for how you access it
from a client (like only machinename or machinename\instancename). So do what feels natural for you.
Well, the one difference I can think of is resolution from machine (or host) name to port number,
when using the IP netlib.
For the default instance, the port is well known (1433). You can change this but that requires that
you specify that port in the client app.
For a named instance, the client queries the "SQL Server browser" service which relies what port
number the desired instance is using. This is done using port 1434, UDP.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:9A6F1BE0-5819-457A-8E07-86869FDF2BE7@.microsoft.com...
> Is there a reason to use a named instance?
> Is there a reason to not use a named instance?
> This will be a large enterprise server - over 1000 users - around 20 or so
> buildings across town.
> Opinions?

Install of SQL 2005

If a server is going to be used for just SQL database access - locally on th
e
WAN - is there any need for IIS?
Does installing reporting services and IIS degrade the machine.
I've got a client whose DBA is debating these issues with the tech who
installed OS and SQL...
DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
Services on another server later if it's ever needed.
Recommendations and opinions would be appreciated.Best practice would usually dictate that IIS / SSRS are employed on another
machine. However, just like whether you should buy an SL55 AMG or a Toyota
Corolla, it depends...
A
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:9FF616F6-89A7-4B3C-B78E-566D976B25AF@.microsoft.com...
> If a server is going to be used for just SQL database access - locally on
> the
> WAN - is there any need for IIS?
> Does installing reporting services and IIS degrade the machine.
> I've got a client whose DBA is debating these issues with the tech who
> installed OS and SQL...
> DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
> Services on another server later if it's ever needed.
> Recommendations and opinions would be appreciated.|||I agree. I would install bare essentials now, and add IIS/RS if/when needed.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:eOtb68zxHHA.4352@.TK2MSFTNGP05.phx.gbl...
> Best practice would usually dictate that IIS / SSRS are employed on anothe
r machine. However,
> just like whether you should buy an SL55 AMG or a Toyota Corolla, it depen
ds...
> A
>
>
> "Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
> news:9FF616F6-89A7-4B3C-B78E-566D976B25AF@.microsoft.com...
>|||On Jul 15, 4:30 pm, Steve Z <Ste...@.discussions.microsoft.com> wrote:
> If a server is going to be used for just SQL database access - locally on
the
> WAN - is there any need for IIS?
> Does installing reporting services and IIS degrade the machine.
> I've got a client whose DBA is debating these issues with the tech who
> installed OS and SQL...
> DBA wants bare-bones SQL install - thinking of installing IIS/Reporting
> Services on another server later if it's ever needed.
> Recommendations and opinions would be appreciated.
As already echoed in the thread, start with your minimal footprint and
add as necessary. Reporting Services is pretty easy to get up and
running when need be. Just get your specifications and go from there.|||Is there a reason to use a named instance?
Is there a reason to not use a named instance?
This will be a large enterprise server - over 1000 users - around 20 or so
buildings across town.
Opinions?|||No and no. A named instance isn't different from a default instance except f
or how you access it
from a client (like only machinename or machinename\instancename). So do wha
t feels natural for you.
Well, the one difference I can think of is resolution from machine (or host)
name to port number,
when using the IP netlib.
For the default instance, the port is well known (1433). You can change this
but that requires that
you specify that port in the client app.
For a named instance, the client queries the "SQL Server browser" service wh
ich relies what port
number the desired instance is using. This is done using port 1434, UDP.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Steve Z" <SteveZ@.discussions.microsoft.com> wrote in message
news:9A6F1BE0-5819-457A-8E07-86869FDF2BE7@.microsoft.com...
> Is there a reason to use a named instance?
> Is there a reason to not use a named instance?
> This will be a large enterprise server - over 1000 users - around 20 or so
> buildings across town.
> Opinions?sql

Install of Reports Designer

Ok.. I've been looking around and I just don't see how to do it. I used to
have an eval copy of Reporting services on my local machine. The eval copy
ran out so I got the enterprise copy on CD. when I try to install this on my
machine I get an error saying that it won't let me install reporting services
on a machine that is not a server. Which is fine.. But how the heck do I re
install report Designer so I can make some reports?
Thanks for the infoI think you are seeing some warnings. Ignore them and you should eventually
end up where you can select what components to install.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jerrad Anderson" <Jerrad Anderson@.discussions.microsoft.com> wrote in
message news:6F8F92BA-6246-4406-9C57-66E18BBA88C4@.microsoft.com...
> Ok.. I've been looking around and I just don't see how to do it. I used to
> have an eval copy of Reporting services on my local machine. The eval copy
> ran out so I got the enterprise copy on CD. when I try to install this on
> my
> machine I get an error saying that it won't let me install reporting
> services
> on a machine that is not a server. Which is fine.. But how the heck do I
> re
> install report Designer so I can make some reports?
> Thanks for the info|||Thanks.. works now :)
"Bruce Johnson [MSFT]" wrote:
> I think you are seeing some warnings. Ignore them and you should eventually
> end up where you can select what components to install.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jerrad Anderson" <Jerrad Anderson@.discussions.microsoft.com> wrote in
> message news:6F8F92BA-6246-4406-9C57-66E18BBA88C4@.microsoft.com...
> > Ok.. I've been looking around and I just don't see how to do it. I used to
> > have an eval copy of Reporting services on my local machine. The eval copy
> > ran out so I got the enterprise copy on CD. when I try to install this on
> > my
> > machine I get an error saying that it won't let me install reporting
> > services
> > on a machine that is not a server. Which is fine.. But how the heck do I
> > re
> > install report Designer so I can make some reports?
> >
> > Thanks for the info
>
>