Install server2005 in LDAP machine problem: Found the problem and the solution

Hi all,

I installed June CTP on server with (already) SQL 2000 and LDAP (the idea is to check if 2005 and 2000 are good friends).
after installation I start to retrieve Errors from the LDAP: "Automation error The authentication mechanism is unknown." (error 2147016662)

more info about the proccess that failed:
ASP file (IIS5) create object (mine dll).
mine dll try to connect LDAP and retrieve data from user.

The proccess fail when it try to connect the LDAP (I debug it).

more then it: when I create the dll from VB6, every thing gone great.

Any Idea?Just to let you know:

The problem was COM+ issue.
Some how the installation couse my COM+ application to stop working (or work with limited security owner).

I build new COM+ Application, moved all my dlls to the new one, and it work.

Install server2005 in LDAP machine problem

Hi all,

I installed June CTP on server with (already) SQL 2000 and LDAP (the idea is to check if 2005 and 2000 are good friends).
after installation I start to retrieve Errors from the LDAP: "Automation error The authentication mechanism is unknown." (error 2147016662)

more info about the proccess that failed:
ASP file (IIS5) create object (mine dll).
mine dll try to connect LDAP and retrieve data from user.

The proccess fail when it try to connect the LDAP (I debug it).

more then it: when I create the dll from VB6, every thing gone great.

Any Idea?Just to let you know:

The problem was COM+ issue.
Some how the installation couse my COM+ application to stop working (or work with limited security owner).

I build new COM+ Application, moved all my dlls to the new one, and it work.

Install security patch ms03-031 on sql2k sp3 server

Tried to install security patch ms03-031 on sql2k sp3
server, but got message said that there is no valid
instance for the patch. Anyone else had this problem?I would first run Select @.@.version from Query Analyzer to verify that the
version is 2000.8.00.760 (SP3)
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Thanks for the response, Rand.
Yes, I did that and even tried to reapply sp3 but still
can't install that patch with same message. Any other
reasons?
>--Original Message--
>I would first run Select @.@.version from Query Analyzer to
verify that the
>version is 2000.8.00.760 (SP3)
>Rand
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>|||Check the registry for the version number.
HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion\CSDVersion.
Make sure it also say 8.00.760
Rand.
This posting is provided "as is" with no warranties and confers no rights.|||Thanks for the response, Rand. That was first thing I do
and it returned correct result. I even tried reapply sp3
but still got message said that can't find instance for
the patch. Any other reasons?
>--Original Message--
>I would first run Select @.@.version from Query Analyzer to
verify that the
>version is 2000.8.00.760 (SP3)
>Rand
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>|||It says 8.00.534, I changed it to 8.00.760 but still
doesn't let me apply the patch.
>--Original Message--
>Check the registry for the version number.
>HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\CurrentVer
sion\CSDVersion.
>Make sure it also say 8.00.760
>Rand.
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>

Install Security

Reguarding best practices: when I am installing s SQL
Server Database, best practice would say that I do not use
the Domain Admin or the BUILTIN Admin account to run the
database under. If I cannot use these accounts, what do I
use? My network has Active Directory installed and we are
running on Win2000 servers."Rich" <anonymous@.discussions.microsoft.com> wrote in message
news:8b5201c3e9a2$dbf005a0$a401280a@.phx.gbl...

quote:

---

> Reguarding best practices: when I am installing s SQL
> Server Database, best practice would say that I do not use
> the Domain Admin or the BUILTIN Admin account to run the
> database under. If I cannot use these accounts, what do I
> use? My network has Active Directory installed and we are
> running on Win2000 servers.

---

For fairly high level of security you can use a domain account with user
level domain permissions, on the server grant the permissions (user rights,
registry & NTFS permissions) found in this document:
http://support.microsoft.com/defaul...1&Product=sql2k
Stevesql

Install Second Node

How would I go about installing the second node for SQL 2000 cluster? The
first node is up and running.
Think I go it. Thanks-
"Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
news:uNZKUQMtHHA.2124@.TK2MSFTNGP02.phx.gbl...
> How would I go about installing the second node for SQL 2000 cluster? The
> first node is up and running.
>
|||Whats the answer ? You cant do this live, can you ?
"Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
news:uAIXXWMtHHA.1208@.TK2MSFTNGP05.phx.gbl...
> Think I go it. Thanks-
> "Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
> news:uNZKUQMtHHA.2124@.TK2MSFTNGP02.phx.gbl...
>

Install Second Instance Of SQL Server 2005

I'm trying to install a second instance of SQL Server 2005 to an existing
server where Service Pack 2 is installed. Nothing special - no clustering, I
just want an additional instance for QA purposes.
The problem that I'm experiencing is that I receive an error message during
the installation:
Error 1603 installing Microsoft SQL Server 2005 Setup Support Files
The log file doesn't provide any description of an error. My only guess at
this point is that my current instance has higher versions of files than the
ones on the original install disk.
Any suggestions on how to proceed? Should I wipe-out the server and start
over?
I would appreciate any assistance. THANKS!!!
Regards,
RayHi Ray,
You could try running sqlrun.msi (in the setup directory) directly,
instead of the setup.exe. That would forego the installation of the
Setup Support Files. Not sure if that works, though.
--
Regards,
Steve
www.foxville.ch
On Sep 13, 7:08 pm, raz0r9edge <raz0r9e...@.discussions.microsoft.com>
wrote:
> I'm trying to install a second instance of SQL Server 2005 to an existing
> server where Service Pack 2 is installed. Nothing special - no clustering, I
> just want an additional instance for QA purposes.
> The problem that I'm experiencing is that I receive an error message during
> the installation:
> Error 1603 installing Microsoft SQL Server 2005 Setup Support Files
> The log file doesn't provide any description of an error. My only guess at
> this point is that my current instance has higher versions of files than the
> ones on the original install disk.
> Any suggestions on how to proceed? Should I wipe-out the server and start
> over?
> I would appreciate any assistance. THANKS!!!
> Regards,
> Ray

Install RSClientPrint

I am unable install ActiveX plug-in (RSClientPrint) for RS Printing in my
client's machine who do have the administrative rights to download plug-in
from the browser. Can anyone suggest me how can do this?Check the user's Security settings in Internet Explorer. Depending on
how it is setup, the browser may have disabled the ability to install
ActiveX controls.
Typically, you can work around this by adding the URL of your Report
website to the "Trusted Sites" zone. To do this, go to Internet
Explorer settings (Tools -> Internet Options), select the "Security"
tab, click on the "Trusted Sites" icon, then click the "Sites" button
to add your URL to this zone. Once this is done, click okay to close
the settings and try again. You should see the small "Trusted" icon in
the status-bar of your browser the next time you visit the Report
website, and it should allow installing the ActiveX control.
If its still not working, you may have to adjust the security settings
manually within Internet Explorer for this zone by clicking on the
"Custom Level" button on that same Security tab. There you can enable
the "Download signed ActiveX controls", and "Run ActiveX controls and
plugins" options.
I hope this helps.
Lance
http://www.lance-hunt.net

Install RS with SSL handled in firewall

Hi,

We are trying to install RS in an unusual environment. The Web server's SSL and public IP address are installed in the firewall. The communications between Web server and other servers such as database server are not encrypted; all the servers have no public IP addresses.

My question is if RS can be installed and if it will work properly. Any other advice?

Thanks

Yes - we call this SSL Offloading.

With SQL Server 2005 Reporting Services, things should just work with the exception of the following:

1) Report Builder - it requires a direct connection to the report server to download and to function.

2) Links in Emails - we use the URLRoot property in the rsreportserver.config file to form the URL for the link. You'll need to set the property to your external IP Address or the external hostname, and remember to use the https protocol designatiion.

3) Drill-through links in Exported reports (PDF, Excel, etc.) - again we use the URLRoot property in the rsreportserve.config file to form the URL for the link. See comment above.

4) SharePoint V2 web parts - need a direct connection to the report server to view reports.

With SQL Server 2000 Reporting Services, this is supported starting with SP2. The instructions for setting this up are in the SP2 readme file. One note I should add, is that it is required for the router to translate URLs.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

sql

Install RS Report Server without VS .Net

I want to install RS Report Server component but I don't want to install
Visual Studio. Can it be done ? Because the installer always check for Visual
Studio .Net in the beginning. ThanksYour machine needs to have MS .NET Framework version 1.1 installed, IIS
configured to run ASP.NET, MDAC 2.6 or higher and be able to connect to an
instance of SQL 2000 or even MSDE.
You can find all this info @.
http://www.microsoft.com/sql/reporting/productinfo/sysreqs.asp
SAL E. YOUNG
www.syoungdesigns.com
"Keenz" <Keenz@.discussions.microsoft.com> wrote in message
news:57122096-DC0B-47D8-AA06-215520C39D80@.microsoft.com...
>I want to install RS Report Server component but I don't want to install
> Visual Studio. Can it be done ? Because the installer always check for
> Visual
> Studio .Net in the beginning. Thanks|||On Mon, 10 Jan 2005 19:07:03 -0800, "Keenz" <Keenz@.discussions.microsoft.com>
wrote:
>I want to install RS Report Server component but I don't want to install
>Visual Studio. Can it be done ? Because the installer always check for Visual
>Studio .Net in the beginning. Thanks
Ignore the warning and continue with the installation. RS will be installed.
Only the report builder needs Visual Studio.
Joachim.

Install RS on SQL2000

I have SQL2000 Developer installed my XP box. Look like I can't put any
except the trial version of RS. Does RS run on SQL Std and Ent only? I
want to play with RS but don't want to install the trial version. Is there
a workaround? Thanks.Hi,
I have SS2000 Developer SP3 AND RS2000 SP2 on my XP SP2 machine with no
problem.
You need to double-check what is the problem with your installation.
Best Regards
Jordi Rambla
SQL Server MVP
Solid Quality Learning
Spain

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 for multiple websites on single computer

My understanding is that RS installs ONLY on the default website. I'm hosting
four websites on a single IIS computer. I want to use Reporting Services
separately on each of the websites. That is, each will have its own database
and its own set of reports. Is this possible? How?
Thanks.
DilipDilip,
I am not sure if you can host multiple instances of RS on single server,
but I have achieved the same requirement by creating a separate directory for
each application. Each corresponding application can have separate directory
with its Reports and required Dataset.
Hope this helps.
Mahesh
"Dilip Kumar" wrote:
> My understanding is that RS installs ONLY on the default website. I'm hosting
> four websites on a single IIS computer. I want to use Reporting Services
> separately on each of the websites. That is, each will have its own database
> and its own set of reports. Is this possible? How?
> Thanks.
> Dilip|||Thanks for your reply, Mahesh.
I want to keep all the domains separate. I want to access each set of
reports as follows:
http://www.companyA.com/Reports
http://www.companyB.com/Reports
http://www.companyC.com/Reports
http://www.companyD.com/Reports
Dilip
"Mahesh Gaware" wrote:
> Dilip,
> I am not sure if you can host multiple instances of RS on single server,
> but I have achieved the same requirement by creating a separate directory for
> each application. Each corresponding application can have separate directory
> with its Reports and required Dataset.
> Hope this helps.
> Mahesh
> "Dilip Kumar" wrote:
> > My understanding is that RS installs ONLY on the default website. I'm hosting
> > four websites on a single IIS computer. I want to use Reporting Services
> > separately on each of the websites. That is, each will have its own database
> > and its own set of reports. Is this possible? How?
> >
> > Thanks.
> > Dilip|||hi Dilip,
hmm.. I am sorry, I have no idea about how this can be acheived using
single IIS server for single RS instance.
Thanks,
Mahesh
"Dilip Kumar" wrote:
> Thanks for your reply, Mahesh.
> I want to keep all the domains separate. I want to access each set of
> reports as follows:
> http://www.companyA.com/Reports
> http://www.companyB.com/Reports
> http://www.companyC.com/Reports
> http://www.companyD.com/Reports
> Dilip
> "Mahesh Gaware" wrote:
> > Dilip,
> > I am not sure if you can host multiple instances of RS on single server,
> > but I have achieved the same requirement by creating a separate directory for
> > each application. Each corresponding application can have separate directory
> > with its Reports and required Dataset.
> >
> > Hope this helps.
> >
> > Mahesh
> >
> > "Dilip Kumar" wrote:
> >
> > > My understanding is that RS installs ONLY on the default website. I'm hosting
> > > four websites on a single IIS computer. I want to use Reporting Services
> > > separately on each of the websites. That is, each will have its own database
> > > and its own set of reports. Is this possible? How?
> > >
> > > Thanks.
> > > Dilip|||Hi Dilip,
I have been thinking about how to do this as I have been thinking of
doing the same...though I am coming to the conclusion it is probably
best to have one server per customer....
However, my thoughts on the subject were as follows...
1. Set up links or domains for each customer.
2. repoint the domains into a single dot net nuke portal (I am
considerign using dot net nuke www.dotnetnuke.com) as the 'BI portal'
for clients....probably a release 2.0 thing for me now.
3. User signs in or can now use integrated security for DNN but if you
have multiple companies on one server you are probably going to host
the server outside their security domains so you need a way to securely
log them into DNN.
4. Present reports inside the DNN environment which will allow you to
have the users looking at the one IIS server and one database without
each customer knowing about the other.....you control where the users
point to for each report or directory so you can just set up different
directories for different customers.
5. You could even set graphics etc from the userid or portal you were
looking at so the clients saw different formats etc inside their BI
portal...
Having played with all this...I thought it was easier just to get the
clients to pay for one machine each...
Peter

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 rolls back

Hi NG,
I have a installation problem on MSDE and install to window 2000
MSI (s) (34:FC): MainEngineThread is returning 1603
MSI (c) (54:58): Back from server. Return value: 1603
MSI (c) (54:58): Decrementing counter to disable shutdown. If counter >= 0,
shutdown will be denied. Counter after decrement: -1
Aktion beendet um 10:57:35: INSTALL. Rckgabewert 3.
MSI (c) (54:58): Note: 1: 2262 2: Control 3: -2147287038
then rolling back.
Does anyone experienced the same problem?
Thank you very much for any suggestion.
Regards
Roland
Hi
Try running the install with verbose logging switched on:
setup.exe /L*v <Setup Log File Path>
You may get a better error that describes the problem.
Regard
sMike
"Roland Skottke" wrote:

> Hi NG,
> I have a installation problem on MSDE and install to window 2000
> MSI (s) (34:FC): MainEngineThread is returning 1603
> MSI (c) (54:58): Back from server. Return value: 1603
> MSI (c) (54:58): Decrementing counter to disable shutdown. If counter >= 0,
> shutdown will be denied. Counter after decrement: -1
> Aktion beendet um 10:57:35: INSTALL. Rückgabewert 3.
> MSI (c) (54:58): Note: 1: 2262 2: Control 3: -2147287038
> then rolling back.
> Does anyone experienced the same problem?
> Thank you very much for any suggestion.
> Regards
> Roland
>
>
|||hi Roland Skottke
I have the same experienced before! I fixed this problem with error code of
1603 by start up the "server" service and re-install MSDE !
hope this can help you!
"Roland Skottke" <spam_roland.skottke@.arrisa.com>
??:cvhu96$ov2$01$1@.news.t-online.com...
> Hi NG,
> I have a installation problem on MSDE and install to window 2000
> MSI (s) (34:FC): MainEngineThread is returning 1603
> MSI (c) (54:58): Back from server. Return value: 1603
> MSI (c) (54:58): Decrementing counter to disable shutdown. If counter >=
0,
> shutdown will be denied. Counter after decrement: -1
> Aktion beendet um 10:57:35: INSTALL. Rckgabewert 3.
> MSI (c) (54:58): Note: 1: 2262 2: Control 3: -2147287038
> then rolling back.
> Does anyone experienced the same problem?
> Thank you very much for any suggestion.
> Regards
> Roland
>
|||Hi sMike,
this errors are a part of the log. The log have a lot of text, but i can't
find the error.
regards
Roland
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> schrieb im Newsbeitrag
news:ABD89029-6E6F-4E7B-97D3-4EA1EF90F98B@.microsoft.com...[vbcol=seagreen]
> Hi
> Try running the install with verbose logging switched on:
> setup.exe /L*v <Setup Log File Path>
> You may get a better error that describes the problem.
> Regard
> sMike
> "Roland Skottke" wrote:
0,[vbcol=seagreen]
|||Hi Angus,
where can i find the "server" service?
I can't count the numbers of re-install on this machine.
regards
Roland
"ANGUS" <angusgod@.theworld.com> schrieb im Newsbeitrag
news:O9q2LNcGFHA.2136@.TK2MSFTNGP14.phx.gbl...
> hi Roland Skottke
> I have the same experienced before! I fixed this problem with error code
of
> 1603 by start up the "server" service and re-install MSDE !
> hope this can help you!
>
> "Roland Skottke" <spam_roland.skottke@.arrisa.com>
> ??:cvhu96$ov2$01$1@.news.t-online.com...
> 0,
>

Install roll back

Hi Guys,
During install of msde2000a, at the last few second of
install on a 2000 server box, installation failed and
rollback. Could anyone can help to solve the problem,
below copied from msde log file.
Thanks,
Ted
Action 14:58:50:
DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOCUME~1
\C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
Starting custom action DisableNetAccess()
Ending custom action DisableNetAccess()
Action 14:58:50: WriteEnvironmentStrings. Updating
environment strings
WriteEnvironmentStrings: Name: PATH, Value: C:\Program
Files\Microsoft SQL Server\80\Tools\Binn\, Action
1610612738
Action 14:58:50: RegisterTypeLibraries. Registering type
libraries
RegisterTypeLibraries: LibID: {10010001-E260-11CF-AE68-
00AA004A34D5}
RegisterTypeLibraries: LibID: {10010001-EB1C-11CF-AE6E-
00AA004A34D5}
RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-
00AA004A34D5}
Action 14:58:51: InstallServices. Installing new services
Action 14:58:51:
InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library C:\DOCUME~1
\C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 6
Action ended 14:58:52: InstallFinalize. Return value 3.
Action 14:58:52: Rollback. Rolling back action:
If more of the log will help let me know.
Hi Ted,
Is your 2000 server part of a domain or standalone?
bigp
"Ted" <anonymous@.discussions.microsoft.com> wrote in message news:<355701c4c34c$ce848a60$a401280a@.phx.gbl>...
> Hi Guys,
> During install of msde2000a, at the last few second of
> install on a 2000 server box, installation failed and
> rollback. Could anyone can help to solve the problem,
> below copied from msde log file.
> Thanks,
> Ted
>
> Action 14:58:50:
> DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
> \Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library C:\DOCUME~1
> \C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
> D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> Starting custom action DisableNetAccess()
> Ending custom action DisableNetAccess()
> Action 14:58:50: WriteEnvironmentStrings. Updating
> environment strings
> WriteEnvironmentStrings: Name: PATH, Value: C:\Program
> Files\Microsoft SQL Server\80\Tools\Binn\, Action
> 1610612738
> Action 14:58:50: RegisterTypeLibraries. Registering type
> libraries
> RegisterTypeLibraries: LibID: {10010001-E260-11CF-AE68-
> 00AA004A34D5}
> RegisterTypeLibraries: LibID: {10010001-EB1C-11CF-AE6E-
> 00AA004A34D5}
> RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-
> 00AA004A34D5}
> Action 14:58:51: InstallServices. Installing new services
> Action 14:58:51:
> InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> TempFolder is C:\DOCUME~1\C2KUSE~1.CLA\LOCALS~1
> \Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library C:\DOCUME~1
> \C2KUSE~1.CLA\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-
> D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> Starting custom action InstallPerfMon
> Registering performance counters from sqlctr.ini
> PerfmonLoad routine returned error code 6
> Action ended 14:58:52: InstallFinalize. Return value 3.
> Action 14:58:52: Rollback. Rolling back action:
> If more of the log will help let me know.
|||I'm having the same problem he describes. It is a standalone server. I have found several web pages that detail this problem, but have yet to find a solution to it for Windows 2000 professional.
This page outlines the specific problem I'm having:
http://www.crescentbloom.com/III/D/11.htm
But in it's workaround, step 4 is something that my computer doesn't have (a 'Server' item on my services list)
I have also found instructions from Microsoft's site on how to fix this in Win 2003, but they also do not work for Win 2000 Pro. Can anybody be of help? Thank you!
-Greg
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum...erver-msde/681
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse...a630a1edd2a9d2
*****************************************
|||The Server is part of a large domain, I have installed
MSDE on other servers on the same domain and they worked
fine.

>--Original Message--
>Hi Ted,
>Is your 2000 server part of a domain or standalone?
>bigp
>"Ted" <anonymous@.discussions.microsoft.com> wrote in
message news:<355701c4c34c$ce848a60$a401280a@.phx.gbl>...[vbcol=seagreen]
{E09B48B5-[vbcol=seagreen]
{E09B48B5-[vbcol=seagreen]
type[vbcol=seagreen]
services[vbcol=seagreen]
{E09B48B5-[vbcol=seagreen]
{E09B48B5-
>.
>
|||The server service is runing ok

>--Original Message--
>I'm having the same problem he describes. It is a
standalone server. I have found several web pages that
detail this problem, but have yet to find a solution to
it for Windows 2000 professional.
>This page outlines the specific problem I'm having:
>http://www.crescentbloom.com/III/D/11.htm
>But in it's workaround, step 4 is something that my
computer doesn't have (a 'Server' item on my services
list)
>I have also found instructions from Microsoft's site on
how to fix this in Win 2003, but they also do not work
for Win 2000 Pro. Can anybody be of help? Thank you!
>-Greg
>*****************************************
>* A copy of the whole thread can be found at:
>* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-
msde/681
>*
>* Report spam or abuse by clicking the following URL:
>* http://www.sqlmonster.com/Uwe/Abuse.aspx?
aid=c471d6429e704a1082a630a1edd2a9d2
>*****************************************
>.
>
|||Can your server locate the PDC, the fsmocheck line of dcdiag?
<anonymous@.discussions.microsoft.com> wrote in message news:<43ee01c4c56d$de6b0800$a601280a@.phx.gbl>...[vbcol=seagreen]
> The Server is part of a large domain, I have installed
> MSDE on other servers on the same domain and they worked
> fine.
> message news:<355701c4c34c$ce848a60$a401280a@.phx.gbl>...
> {E09B48B5-
> {E09B48B5-
> type
> services
> {E09B48B5-
> {E09B48B5-
|||It is the pdc.
Do you think it my be rights?

>--Original Message--
>Can your server locate the PDC, the fsmocheck line of
dcdiag?
><anonymous@.discussions.microsoft.com> wrote in message
news:<43ee01c4c56d$de6b0800$a601280a@.phx.gbl>...[vbcol=seagreen]
worked[vbcol=seagreen]
$a401280a@.phx.gbl>...[vbcol=seagreen]
of[vbcol=seagreen]
and[vbcol=seagreen]
problem,[vbcol=seagreen]
DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B.[vbcol=seagreen]
AB0C-[vbcol=seagreen]
C:\Program[vbcol=seagreen]
AE68-[vbcol=seagreen]
AE6E-[vbcol=seagreen]
AE7B-[vbcol=seagreen]
InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.[vbcol=seagreen]
AB0C-[vbcol=seagreen]
value 3.
>.
>

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.
> |
> |
> |
>