Friday, March 30, 2012

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)
Tongue Tied

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)
Tongue Tied

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

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 reporting service 2005

Hi
I tried to install reporting service after i had installed sql server 2005, I find reporting service checkbox is disabled, so i can not install it.
Why it is disabled, and how i install reporting service.
thanks

Do you have IIS installed on the machine? If not installed, RS will not install either.

Also, because you have a SQL instance already installed, you have two options.

1. Install RS as another instance and you will get a full install and the check box should be enabled.

2. Install RS as a files only installation for the existing SQL Instance. Then use the configuration tool to configure RS to work with the current instance of SQL Server.

|||Hi Brad
That solved the problem. I installed IIS , and succeded in instaling RS within a named sqlsever 2005 service.
I tried to create a simple report using RS wizard in VS 2005 to test the reporting service , and when finishing the wizard the error message:
"Exception of type 'System.Runtime.InteropServices.COMException' " was thrown , and i can not generate the report.
Pls, how can i resolve the problem.
Thanks.

|||I resolved the exception error thanks to the post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=573569&SiteID=1&mode=1

after reading the post , I downloaded the refactor software . I tried to install it

, but it could not be installed due to error:

"Error 1001: The SavedState Dictionary contains inconsistent data and

might have corrupted."

I traced the propblem until i found that DXCore (software provided by same

company of refactor) was the reason.

I removed DXcore , and every thing in reporting service in visual studio 2005

become working well !!!..

Is it a bug in DXcore ?


sql

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 on another workstation

I have installed RS on a Windows 2003 Server. However, we
prefer to use VB .NET on a Windows 2000 workstation as
Report Designer.
We would like to know what component of Reporting Services
has to be installed on that Windows 2000 workstation after
installing VB.NET ?
ThanksJust run the SQL-RS setup again on your workstation, and select from
reporting services only the client tools. Also run Sp1 or 2 on the client
computer. I got a similar setup as I dont prefer to devolop on the server.
"Peter" wrote:
> I have installed RS on a Windows 2003 Server. However, we
> prefer to use VB .NET on a Windows 2000 workstation as
> Report Designer.
> We would like to know what component of Reporting Services
> has to be installed on that Windows 2000 workstation after
> installing VB.NET ?
> 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 replication components on cluster

Hi,
At the SQL Server cluster installation time I haven't choose the replication component(wasn't required at that time). Now it is and when I run again the setup to modify the installation and to add the replication components it doesn't give me that option.
The only option that I have is to uninstall the SQL Server.
Is it what is suppose to be? If yes how can I install the replication components?
Cata,
replication isn't enabled from the setup. If you use EM, and go to tools,
replication, configure publishing... you can set it up there.
Regards,
Paul Ibison
|||Thanks for your replay.
At the setup time when you install the SQL Server one is
asked if he wants to install the Replication components -
so there are some components that have to be installed. I
haven't choose that option.
Additionally when I am choosing to configure replication
EM - Tools - Cofigure Publishing, I get the message "The
Replication components were not included when SQL Server
was installed on <server>"

>--Original Message--
>Cata,
>replication isn't enabled from the setup. If you use EM,
and go to tools,
>replication, configure publishing... you can set it up
there.
>Regards,
>Paul Ibison
>
>.
>
|||My apologies - I had selected this checkbox without thinking when I installed, which was a while ago. I'm out of the office for a while but if no-one else answers in the next few days then I'll try on a test cluster I have built back at work. I suspect yo
u'll have to break the cluster then add the components, but I'll have a look.
Regards,
Paul Ibison

Install regular SQL Server Management Studio over SQL Server Mangement Studio Express (SSMSE)

I installed SQL Server 2005 Express edition with the SQL Server Mangement Studio Express (SSMSE) on my work laptop. When I tried to manage the SQL Server 2005 instances on our servers, I couldn't expand/drill down on the DB Maintenance Plan. This prompted me to find out that this may be one of the features that are lacking in the "Express" version of the SSMS. Therefore I'm in the process of finding a way to 'upgrade' my SSMSE to regular SSMS.

I popped the installation disc of "SQL Server 2005 Standard Edition" and there are client tools/components that I can install which I believe SSMS (Management Studio) is part of it. However when I clicked through the wizard I was told that all the components are already installed and the wizard couldn't go any further.

Is there a way for me to install a regular version of SSMS over my existing SSMSE? Do I have to remove SSMSE first?

Please advise,

Thanks.

The easy thing to do is to remove SSMSE first -as you questioned. Then install SSMS.|||Tip: If you have installed SSMS and then no need to install SSMSE as you can manage Express edition with SSMS alone.|||

Maintenance plans require SQL Agent to be installed on the server machine. SQL Agent doesn't come with SQL Server Express so Management Studio doesn't show maintenance plans when connected to a SQL Server Express server. If you connect to Developer, Workgroup, Standard or Enterprise, you'll see the Maintenance plans folder for those server types in regular SSMS.

Hope this helps,
Steve

|||

Install regular SQL Server Management Studio over SQL Server Mangement Studio Express (SSMSE)

I installed SQL Server 2005 Express edition with the SQL Server Mangement Studio Express (SSMSE) on my work laptop. When I tried to manage the SQL Server 2005 instances on our servers, I couldn't expand/drill down on the DB Maintenance Plan. This prompted me to find out that this may be one of the features that are lacking in the "Express" version of the SSMS. Therefore I'm in the process of finding a way to 'upgrade' my SSMSE to regular SSMS.

I popped the installation disc of "SQL Server 2005 Standard Edition" and there are client tools/components that I can install which I believe SSMS (Management Studio) is part of it. However when I clicked through the wizard I was told that all the components are already installed and the wizard couldn't go any further.

Is there a way for me to install a regular version of SSMS over my existing SSMSE? Do I have to remove SSMSE first?

Please advise,

Thanks.

The easy thing to do is to remove SSMSE first -as you questioned. Then install SSMS.|||Tip: If you have installed SSMS and then no need to install SSMSE as you can manage Express edition with SSMS alone.|||

Maintenance plans require SQL Agent to be installed on the server machine. SQL Agent doesn't come with SQL Server Express so Management Studio doesn't show maintenance plans when connected to a SQL Server Express server. If you connect to Developer, Workgroup, Standard or Enterprise, you'll see the Maintenance plans folder for those server types in regular SSMS.

Hope this helps,
Steve

|||

Install regular SQL Server Management Studio over SQL Server Mangement Studio Express (SSMSE

I installed SQL Server 2005 Express edition with the SQL Server Mangement Studio Express (SSMSE) on my work laptop. When I tried to manage the SQL Server 2005 instances on our servers, I couldn't expand/drill down on the DB Maintenance Plan. This prompted me to find out that this may be one of the features that are lacking in the "Express" version of the SSMS. Therefore I'm in the process of finding a way to 'upgrade' my SSMSE to regular SSMS.

I popped the installation disc of "SQL Server 2005 Standard Edition" and there are client tools/components that I can install which I believe SSMS (Management Studio) is part of it. However when I clicked through the wizard I was told that all the components are already installed and the wizard couldn't go any further.

Is there a way for me to install a regular version of SSMS over my existing SSMSE? Do I have to remove SSMSE first?

Please advise,

Thanks.

The easy thing to do is to remove SSMSE first -as you questioned. Then install SSMS.|||Tip: If you have installed SSMS and then no need to install SSMSE as you can manage Express edition with SSMS alone.|||

Maintenance plans require SQL Agent to be installed on the server machine. SQL Agent doesn't come with SQL Server Express so Management Studio doesn't show maintenance plans when connected to a SQL Server Express server. If you connect to Developer, Workgroup, Standard or Enterprise, you'll see the Maintenance plans folder for those server types in regular SSMS.

Hope this helps,
Steve

|||

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 question

I installed SQL2005 (Standard Edition - 32 bit) for the 1st time and it
seemed to install fine. However, I wasn't prompted for licensing info (per
processor or per
seat) as SQL2000 does. Did I miss an option somewhere? The licensetype is
now disabled and numlicenses is now null.
Also unlike the SQL2000 install, I didn't see where you have the option to
put the database files (for master, msdb) should you not want them under
C:\program files.
Thanks for any help.
Ron
>I installed SQL2005 (Standard Edition - 32 bit) for the 1st time and it
> seemed to install fine. However, I wasn't prompted for licensing info
> (per
> processor or per
> seat) as SQL2000 does. Did I miss an option somewhere? The licensetype
> is
> now disabled and numlicenses is now null.
Sounds like you installed an MSDN version, in which case, licensing is
disabled. MSDN versions are for testing and development, and processor/CAL
licensing becomes irrelevant. You should not be running the MSDN version of
SQL Server on a machine where licensing is a concern.

> Also unlike the SQL2000 install, I didn't see where you have the option to
> put the database files (for master, msdb) should you not want them under
> C:\program files.
That option is there, it's just not front and center... it's in one of the
options tabs where you breakdown all of the installable features.
A
|||I really don't see any indication that it's an MSDN version. The CDs show:
On left hand size -
English
Microsoft SQL Server 2005
Standard Edition
(32 Bit)
(Disc 1 of 2)
On right hand size-
December 2005
Servers
Servers
Application
It also reads Microsoft Licensing in several places. No mention of MSDN.
"Aaron Bertrand [SQL Server MVP]" wrote:

> Sounds like you installed an MSDN version, in which case, licensing is
> disabled. MSDN versions are for testing and development, and processor/CAL
> licensing becomes irrelevant. You should not be running the MSDN version of
> SQL Server on a machine where licensing is a concern.
>
> That option is there, it's just not front and center... it's in one of the
> options tabs where you breakdown all of the installable features.
> A
>
>
|||>I really don't see any indication that it's an MSDN version. The CDs show:
> On left hand size -
> English
> Microsoft SQL Server 2005
> Standard Edition
> (32 Bit)
> (Disc 1 of 2)
> On right hand size-
> December 2005
> Servers
> Servers
> Application
> It also reads Microsoft Licensing in several places. No mention of MSDN.
Does it say "Not for resale" or "Not for Retail" or "NFR" or "Not for OEM
Distribution" anywhere on the disc?
There are a few obscure cases where licensing becomes disabled, but 99% of
the time it's because it's an intentionall crippled edition.
A
|||Yes, it does show "Not for OEM or retail distribution" in the smaller print.
Should I be using another version?
"Aaron Bertrand [SQL Server MVP]" wrote:

> Does it say "Not for resale" or "Not for Retail" or "NFR" or "Not for OEM
> Distribution" anywhere on the disc?
> There are a few obscure cases where licensing becomes disabled, but 99% of
> the time it's because it's an intentionall crippled edition.
> A
>
>
|||> Yes, it does show "Not for OEM or retail distribution" in the smaller
> print.
> Should I be using another version?
I am not sure what you are using it for, if you require licensing, what your
compliance status is, whether it's personal or company, etc. If you are
using this for production then yes you should have official licenses I am
sure.
|||I'm told we have Volume Licensing and the CDs were not MSDN. I uninstalled
sql2005 and downloaded the SQL2005 standard edition via the MVLS website. I
installed that version and still no prompt for licensing (asking for per
processor or per seat).
The licensetype is disabled and numlicenses is null.
As this will eventually be a production server so I'm concerned that all
will be well. Since I'm convinced we are properly licensed, should I be
concerned as to the values in the server property setting?
Thanks again.
Ron
"Aaron Bertrand [SQL Server MVP]" wrote:

> I am not sure what you are using it for, if you require licensing, what your
> compliance status is, whether it's personal or company, etc. If you are
> using this for production then yes you should have official licenses I am
> sure.
>
>
|||SQL Server 2005 no longer tracks license information. The thinking at the
time this decision was made was that since license restrictions never were
enforced, eliminating the license information would reduce the number of
support calls generated when someone entered the wrong data or wanted to
switch license types. The license information columns weren't removed from
the system tables to keep from breaking applications that depend on them -
that's the normal deprecation policy - so they are still there but contain
no useful information. Now SQL works like most other MS server products -
the license is only a paper document that you need to have if you get
audited.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:734EF6A3-B060-452B-B505-6DBE4C601BA6@.microsoft.com...[vbcol=seagreen]
> I'm told we have Volume Licensing and the CDs were not MSDN. I
> uninstalled
> sql2005 and downloaded the SQL2005 standard edition via the MVLS website.
> I
> installed that version and still no prompt for licensing (asking for per
> processor or per seat).
> The licensetype is disabled and numlicenses is null.
> As this will eventually be a production server so I'm concerned that all
> will be well. Since I'm convinced we are properly licensed, should I be
> concerned as to the values in the server property setting?
> Thanks again.
> Ron
> "Aaron Bertrand [SQL Server MVP]" wrote:

Install question

I installed SQL2005 (Standard Edition - 32 bit) for the 1st time and it
seemed to install fine. However, I wasn't prompted for licensing info (per
processor or per
seat) as SQL2000 does. Did I miss an option somewhere? The licensetype is
now disabled and numlicenses is now null.
Also unlike the SQL2000 install, I didn't see where you have the option to
put the database files (for master, msdb) should you not want them under
C:\program files.
Thanks for any help.
Ron>I installed SQL2005 (Standard Edition - 32 bit) for the 1st time and it
> seemed to install fine. However, I wasn't prompted for licensing info
> (per
> processor or per
> seat) as SQL2000 does. Did I miss an option somewhere? The licensetype
> is
> now disabled and numlicenses is now null.
Sounds like you installed an MSDN version, in which case, licensing is
disabled. MSDN versions are for testing and development, and processor/CAL
licensing becomes irrelevant. You should not be running the MSDN version of
SQL Server on a machine where licensing is a concern.

> Also unlike the SQL2000 install, I didn't see where you have the option to
> put the database files (for master, msdb) should you not want them under
> C:\program files.
That option is there, it's just not front and center... it's in one of the
options tabs where you breakdown all of the installable features.
A|||I really don't see any indication that it's an MSDN version. The CDs show:
On left hand size -
English
Microsoft SQL Server 2005
Standard Edition
(32 Bit)
(Disc 1 of 2)
On right hand size-
December 2005
Servers
Servers
Application
It also reads Microsoft Licensing in several places. No mention of MSDN.
"Aaron Bertrand [SQL Server MVP]" wrote:

> Sounds like you installed an MSDN version, in which case, licensing is
> disabled. MSDN versions are for testing and development, and processor/CA
L
> licensing becomes irrelevant. You should not be running the MSDN version
of
> SQL Server on a machine where licensing is a concern.
>
> That option is there, it's just not front and center... it's in one of the
> options tabs where you breakdown all of the installable features.
> A
>
>|||>I really don't see any indication that it's an MSDN version. The CDs show:
> On left hand size -
> English
> Microsoft SQL Server 2005
> Standard Edition
> (32 Bit)
> (Disc 1 of 2)
> On right hand size-
> December 2005
> Servers
> Servers
> Application
> It also reads Microsoft Licensing in several places. No mention of MSDN.
Does it say "Not for resale" or "Not for Retail" or "NFR" or "Not for OEM
Distribution" anywhere on the disc?
There are a few obscure cases where licensing becomes disabled, but 99% of
the time it's because it's an intentionall crippled edition.
A|||Yes, it does show "Not for OEM or retail distribution" in the smaller print.
Should I be using another version?
"Aaron Bertrand [SQL Server MVP]" wrote:

> Does it say "Not for resale" or "Not for Retail" or "NFR" or "Not for OEM
> Distribution" anywhere on the disc?
> There are a few obscure cases where licensing becomes disabled, but 99% of
> the time it's because it's an intentionall crippled edition.
> A
>
>|||> Yes, it does show "Not for OEM or retail distribution" in the smaller
> print.
> Should I be using another version?
I am not sure what you are using it for, if you require licensing, what your
compliance status is, whether it's personal or company, etc. If you are
using this for production then yes you should have official licenses I am
sure.|||I'm told we have Volume Licensing and the CDs were not MSDN. I uninstalled
sql2005 and downloaded the SQL2005 standard edition via the MVLS website. I
installed that version and still no prompt for licensing (asking for per
processor or per seat).
The licensetype is disabled and numlicenses is null.
As this will eventually be a production server so I'm concerned that all
will be well. Since I'm convinced we are properly licensed, should I be
concerned as to the values in the server property setting?
Thanks again.
Ron
"Aaron Bertrand [SQL Server MVP]" wrote:

> I am not sure what you are using it for, if you require licensing, what yo
ur
> compliance status is, whether it's personal or company, etc. If you are
> using this for production then yes you should have official licenses I am
> sure.
>
>|||SQL Server 2005 no longer tracks license information. The thinking at the
time this decision was made was that since license restrictions never were
enforced, eliminating the license information would reduce the number of
support calls generated when someone entered the wrong data or wanted to
switch license types. The license information columns weren't removed from
the system tables to keep from breaking applications that depend on them -
that's the normal deprecation policy - so they are still there but contain
no useful information. Now SQL works like most other MS server products -
the license is only a paper document that you need to have if you get
audited.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:734EF6A3-B060-452B-B505-6DBE4C601BA6@.microsoft.com...[vbcol=seagreen]
> I'm told we have Volume Licensing and the CDs were not MSDN. I
> uninstalled
> sql2005 and downloaded the SQL2005 standard edition via the MVLS website.
> I
> installed that version and still no prompt for licensing (asking for per
> processor or per seat).
> The licensetype is disabled and numlicenses is null.
> As this will eventually be a production server so I'm concerned that all
> will be well. Since I'm convinced we are properly licensed, should I be
> concerned as to the values in the server property setting?
> Thanks again.
> Ron
> "Aaron Bertrand [SQL Server MVP]" wrote:
>

Install QA only ?

If we want someone to use Query Analyzer only - allow end
user to run query by themselves, is it necessary for us to
install "Client Connectivity" on that machine as well?
Thanks
This is a duplicate post. It's been answered in another area.
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:01d601c528e5$f105d400$a401280a@.phx.gbl...
> If we want someone to use Query Analyzer only - allow end
> user to run query by themselves, is it necessary for us to
> install "Client Connectivity" on that machine as well?
> Thanks
>
|||Dear Paul,
You suggest to remove the userid from Public database role
as follow:
+++++++++++++++++++++++
If you remove the public role permissions to what it
should have (ZERO), and limit the access users have in the
databases, they won't be able to do anymore with EM than
QA.
+++++++++++++++++++++++
However, from the newsgroup, a lot of people suggest that
we should not remove any user from the Public Role. Is it
OK for me to do so ?
Besides, the user belongs to the db_datareader role only,
is there still any problem ?
Since we are not using Reporting Service, is there any
other way to meet the need ?
Thanks

>--Original Message--
>This is a duplicate post. It's been answered in another
area.
>"Paul" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:01d601c528e5$f105d400$a401280a@.phx.gbl...
end[vbcol=seagreen]
to
>
>.
>

Install QA only ?

If we want someone to use Query Analyzer only - allow end
user to run query by themselves, is it necessary for us to
install "Client Connectivity" on that machine as well?
ThanksThis is a duplicate post. It's been answered in another area.
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:01d601c528e5$f105d400$a401280a@.phx.gbl...
> If we want someone to use Query Analyzer only - allow end
> user to run query by themselves, is it necessary for us to
> install "Client Connectivity" on that machine as well?
> Thanks
>|||Dear Paul,
You suggest to remove the userid from Public database role
as follow:
+++++++++++++++++++++++
If you remove the public role permissions to what it
should have (ZERO), and limit the access users have in the
databases, they won't be able to do anymore with EM than
QA.
+++++++++++++++++++++++
However, from the newsgroup, a lot of people suggest that
we should not remove any user from the Public Role. Is it
OK for me to do so ?
Besides, the user belongs to the db_datareader role only,
is there still any problem ?
Since we are not using Reporting Service, is there any
other way to meet the need ?
Thanks

>--Original Message--
>This is a duplicate post. It's been answered in another
area.
>"Paul" <anonymous@.discussions.microsoft.com> wrote in
message
>news:01d601c528e5$f105d400$a401280a@.phx.gbl...
end[vbcol=seagreen]
to[vbcol=seagreen]
>
>.
>

Install QA only ?

If we want someone to use Query Analyzer only - allow end
user to run query by themselves, is it necessary for us to
install "Client Connectivity" on that machine as well?
ThanksThis is a duplicate post. It's been answered in another area.
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:01d601c528e5$f105d400$a401280a@.phx.gbl...
> If we want someone to use Query Analyzer only - allow end
> user to run query by themselves, is it necessary for us to
> install "Client Connectivity" on that machine as well?
> Thanks
>|||Dear Paul,
You suggest to remove the userid from Public database role
as follow:
+++++++++++++++++++++++
If you remove the public role permissions to what it
should have (ZERO), and limit the access users have in the
databases, they won't be able to do anymore with EM than
QA.
+++++++++++++++++++++++
However, from the newsgroup, a lot of people suggest that
we should not remove any user from the Public Role. Is it
OK for me to do so ?
Besides, the user belongs to the db_datareader role only,
is there still any problem ?
Since we are not using Reporting Service, is there any
other way to meet the need ?
Thanks
>--Original Message--
>This is a duplicate post. It's been answered in another
area.
>"Paul" <anonymous@.discussions.microsoft.com> wrote in
message
>news:01d601c528e5$f105d400$a401280a@.phx.gbl...
>> If we want someone to use Query Analyzer only - allow
end
>> user to run query by themselves, is it necessary for us
to
>> install "Client Connectivity" on that machine as well?
>> Thanks
>
>.
>sql