When trying to install Rs on Win2003 server running standard SQL2k SP3a I get into strange situation.
On start of installation I get statement that asp.net and Visual studio are not installed or not running (they are installed and running)
Than it proceedes to install Reporting services, goes through all dialogues, states it is installed
But it is not! I can see RS books, but not the program, also no reporting services are running .
Help
Natalijahi,
i prepared a documentation to install sps,sqlserver and
reporting services in a machine...i'm sending it to
you..just leave with the sharepoint and do the
remaining ..u dont need to change any file name or any
thing . just follow the procedure. better to use sql
server enterprise edition
************
To configure a server running share point portal server,
sql server , analysis services and reporting services
Software Requirements:
1. windows 2003 server enterprise edition.
1.1. Configure application server (enable both front page
extensions and asp.net ) to install IIS.
1.2. Install smtp server
1.3. Configure DNS giving appropriate IP address.
2. SQL Server 2000 Enterprise Edition with Analysis
Services (if reqd) and service packs for both SQL server
and Analysis services.
3. Visual Studio .net Enterprise Architecture
4. Share Point Portal Server
Install share point portal server with out
desktop engine if u r using sql server on the same
machine.
while configuring share point portal server it
will ask to remove front page server extensions at the
time of creating a portal. remove the front page server
extensions and then restart the machine and after that
create a portal site.
5. Reporting services
While installing reporting services it will
check the system and gives a warning message that share
point is also installed in the system and we need to
manually configure reporting services.
leave it and go for the next tab.
Specify a domain/user account where ever asked.
unckeck the ssl certification if u dont have
any and check direct to default
website.
Then continue installing.
After installation
1. go to IIS
right click on reports--> properties--
>configuration -->extensions-->edit
and then uncheck if "Verify that the file exists" is
checked.
and then click OK
close IIS.
2. open E:\Inetpub\wwwroot\webconfig file.
2.1. in <http Modules>
include the third line also.
<add name="Session"
type="System.Web.SessionState.SessionStateModule"/>
and change the below line as follows
pages enableSessionState="true" enableViewState="true"
enableViewStateMac="true" validateRequest="false" />
3. In cmd prompt go to
E:\Program Files\Common Files\Microsoft Shared\web server
extensions\60\BIN
type
stsadm -o addpath -url http://localhost/reportserver -type
exclusion
and
stsadm -o addpath -url http://localhost/reports -type
exclusion
4. in cmd prompt go to
E:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer
type
rsactivate -c "rsreportserver.config"
Then restart the machine
ur configuration is complete now.
*********************
>--Original Message--
>When trying to install Rs on Win2003 server running
standard SQL2k SP3a I get into strange situation.
>On start of installation I get statement that asp.net and
Visual studio are not installed or not running (they are
installed and running)
>Than it proceedes to install Reporting services, goes
through all dialogues, states it is installed
>But it is not! I can see RS books, but not the program,
also no reporting services are running .
>Help
>Natalija
>.
>
Showing posts with label sql2k. Show all posts
Showing posts with label sql2k. Show all posts
Subscribe to:
Posts (Atom)