please help me to cearte this stored procedure

Hi ,

I want to make a report of records of a table, there is abut 15 fields that this report based on them , so we need a select query like this

Select f1,f2from Table1where f3=@.f3and f4=@.f4 and ….and f17=@.f17

-- f1 = field1 and ….

The problem is sometimes @.fs are empty, for example if @.f4was empty so "and f4=@.f4" should be excluded from the select query .(and it means there is no limitation for f4 field)

I know, probably I couldn't explain my purpose very well, but I hope somebody kindly try to understand it .

how can I perform that in a stored procedure?

Please help me

Thank you

try it like this:

SELECT f1,f2FROM Table1WHERE (f3=@.f3OR @.f3ISNULL)AND (f4=@.f4OR @.f4ISNULL)AND ….AND (f17=@.f17OR @.f17ISNULL)

|||

Is in your example @.f4 empty or null? I think null, so I created the following query for you:

Select

f1from table1where f1= @.f1and(f4= @.f4or @.f4isnull)

This query selects all the records where f1 matches @.f1 and f4 matches @.f4 or @.f4 is null (and will be ignored then).

I hope this helps

Richard

|||

mbanavige & richardsoeteman.net thank you very, very much!.

|||

Hi

Assume there are 3 tables like these:

Table0

Primary key

Name

1

Name1

2

Name2

3

Name3

Table 1:

Foreign key

Column1

1

Data1

2

Data1

Table2:

Foreign key

Column2

2

Data2

3

Data2

And there are 2 parameters that they may be null: @.Data1 and @.Data2

I need a select query that

-selects "Name2" from Table0 if:

@.Data1="Data1"

@.Data2="Data2"

-selects "Name1, Name2" from Table0 if:

@.Data1="Data1"

@.Data2=null

-selects "Name2, Name3" from Table0 if:

@.Data1=null

@.Data2="Data2"

And selects "Name1, Name2, Name3" from Table0 if both of@.Data1 &@.Data2 wasnull.

I know I did not explain very well again but it's the final step of my project and I really need help. So please help me again

Thanks,

|||

Same concept:

Read this post:http://forums.asp.net/thread/1440706.aspx

|||

thank you Mike,

What about parameters that areint ordecimal and we want to ignore them , they can not benull ,they can be 0.

thank you Mike,

|||

You can use the same concept

Select

f1from table1where(f1= @.f1or @.f1=0)

|||Thank you Richard,

Please help me SQL 2005 and Access Databases

I have a restaurant POS application that is written in VB 6 and the data is being written to a access database. I need to access this database over the internet. I need to get certain tables (current sales) in this database to automatically send the updated data to a Web Server. My questions are: What is the best way to do this? Do I need to have sql express loaded on site and let it do the interactions with the Access server and then connect to SQL express over the internet? I am new to this and not sure of the best way to design it. Do I use Report services or analysis services to design?

Thanks

What about using a WebService which exposes the data grabbing functionality. The WebService can be additionally secured via various methods. I would not use SQL Server as a gateway to get the data in that case.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Thank you. I will look into this. I don't really understand the background process to get the data but will learn.

Bob

|||

Web Service is the only way to go if you're going to use SQL Express. You can not connect directly to SQL Express through the internet as it does not support HTTP Endpoints.

Mike

Please help me solve this problem

Hello All,
I am new to crystalreport am using crystalreport 8.5. I have to provide the link for
a column whose value is > 1000. i don't want to suppress the values other than1000.
My Problem is the link should be enabled only when the value is > 1000. Please share your experience to solve this problem.
Thanks in advance
Vasuformat the field of the column using a formula..

if(value>100, "link text" & value, value)

?|||Thanks a lot cjard. it works well. the link is enabled for value > 1000
thanks and regards
Vasu

Please help me set up SQL Express

I am extremely new to ASP, SQL, everything. I'm trying to set up a simple username/password system for our website (built with Expression Web) that would only be used by about 15 employees. I am following directions in Zak Ruvalcaba's book on Expression Web, and I'm stuck. I have .NET Framework and SQL Express downloaded and installed. I'm running the ASP.NET SQL Server Setup Wizard, but Setup fails because it is unable to connect to SQL Server database. I'm completely lost. Any help would be greatly appreciated. Thanks.

How to configure services for Asp.net is covered in the link below, post again if you still need help.

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

Please help me populate my date fields

Hi,

I have the following table:

CREATE TABLE [Orders] (
[OrdID] [int] ,
[OrderDate] [datetime] ,
[OrderDateONLY] [datetime],
[OrderDayName] [nvarchar] (15),
[OrderMonth] [nvarchar] (25),
[OrderDayOfMonth] [smallint] NULL ,
[OrderWeekofYear] [smallint] NULL
)
GO

The field OrderDate contains BOTH Date and Time information. What I want to do is populate the fields (in bold above) from the OrderDate field... I have tried all that I could think of but nothing works. The last and the best try that I gave was the following but that too does not work. Can you PLEASE help. Many thanks in advance:

Insert ORDERS
(OrderDateONLY, OrderDayName, OrderMonth, OrderDayOfMonth, OrderWeekofYear)
select
d, datename (dw, d), datename (mm, d), Year (d), datepart (ww, d)
from
(select convert (char (8), OrderDate, 112)as d
from ORDERS
) as xupdate orders set orderdateonly=convert(varchar,orderdate,105),order Dayname=datename(dw,orderdate),orderMonth=datename (m,orderdate),
orderDayOfMonth=day(orderdate),orderweekofyear=dat ename(wk,orderdate)|||populate only orderDate in this

CREATE TABLE [dbo].[Orders] (
[OrdID] [int] NULL ,
[OrderDate] [datetime] NULL ,
[OrderDateONLY] AS ([orderdate]) ,
[OrderDayName] AS (datename(weekday,[orderdate])) ,
[OrderMonth] AS (datename(month,[orderdate]))
.....
)|||harsal_in,

Thanks for the reply...i think i'm very close now except for one problem...when I run the statement i get an error message saying:

"The conversion of a char datatype to datetime datatype resulted in an out of range datetime value"

The problem seems to be with the "orderdateonly=convert(varchar,orderdate,105)" but I can't figure out :confused:|||it works very well on my machine.
anyways try this:
update orders set orderdateonly=convert(datetime,convert(varchar,ord erdate,105)),orderDayname=datename(dw,orderdate),o rderMonth=datename (m,orderdate),
orderDayOfMonth=day(orderdate),orderweekofyear=dat ename(wk,orderdate)|||harshal_in,

I wonder what's wrong at my end becuase I am still getting the same error. I have SP1 and could this be the problem? I'll update to SP3 but for now is there a solution.

Thanks.|||Format 120 (or 121 Brett...) are better for date conversion because they are interpreted unambiguously by SQL Server.

update orders
set orderdateonly=convert(datetime,convert(char(10),or derdate,120)),
orderDayname=datename(dw,orderdate),
orderMonth=datename (m,orderdate),
orderDayOfMonth=day(orderdate),
orderweekofyear=datename(wk,orderdate)

...but the problem with your design here is that you will need to ensure that anytime the orderdate is modified that all the other columns are updated as well. I recommend that instead of having columns to store these values directly you should create them as calculated fields using the above formulas. This way, they will automatically be synchronized with the orderdate field.|||Unless it's a warehouse...or for performance reasons...which I can't see it...

NEVER store derived data....

What's the reason..

If you store derived data, then you get caught in the trap of making sure the derived data is TRUE to the source...all the time...

Which means an additional process..

This is OLTP, right?

in OLAP, it done once and never changes, so it is TRUE at the time of the derivation

OLTP is fluid, and alway in a state of flux...(like the capacitor :D )

So why?sql

Please help me out-no values for all the cells of the cubes?

Hi, all here,

I encountered a very very weird problem-I changed nothing, but suddenly all cell values are empty for one of my cubes? But the data is totally fine viewing from the data source view?

Why is that?

Please help me out and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

Hi, experts,

Please help me out!

I am looking forward to hearing from you.

Thanks.

With best regards,

Yours sincerely,

|||Hi

Make sure that you havne't remove the 'CALCULATE' command in your script editor under the calculations tab.

Chris.
|||

Hi,Chris,

Thank you so much indeed! I really appreciate your brilliant help so much!

With kindest regards,

Yours sincerely,

please help me out

my mdf and ldf are in 1 drive only. i am facing query timeout problem for
this server which is mainly used for employees
if i separate ldf into another drive will there will be any perf benefit
can i add another log file
how to clean up my log fileraghu veer wrote:
> my mdf and ldf are in 1 drive only. i am facing query timeout problem
> for this server which is mainly used for employees
> if i separate ldf into another drive will there will be any perf
> benefit can i add another log file
> how to clean up my log file
No way to know for sure given the limited amount of information.
Assuming you do not have SQL tuning problems or CPU-related issues (not
enough CPU or other services/applications using too much), then a drive
change should be in order. It's always a good idea to separate data and
log files.
A query timeout occurs when you set a maximum limit for query execution
in your code. Have you set a maximum timeout value? Make sure you roll
back the transaction when the query times out.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||BOL has this
SET QUERY_GOVERNOR_COST_LIMIT
Overrides the currently configured value for the current connection.
Syntax
SET QUERY_GOVERNOR_COST_LIMIT value
Arguments
value
Is a numeric or integer value indicating if all queries are allowed to run
(value of 0) or if no queries are allowed to run with an estimated cost
greater than the specified nonzero value. If a numeric value is specified,
Microsoft? SQL Server? truncates it to an integer.
Remarks
Using SET QUERY_GOVERNOR_COST_LIMIT applies to the current connection only
and lasts the duration of the current connection. Use the query governor cos
t
limit option of sp_configure to change the server-wide query governor cost
limit value. For more information about configuring this option, see
sp_configure and Setting Configuration Options.
The setting of SET QUERY_GOVERNOR_COST_LIMIT is set at execute or run time
and not at parse time.
Permissions
SET QUERY_GOVERNOR_COST_LIMIT permissions default to members of the symin
fixed server role.
Regards
R.D
--Knowledge gets doubled when shared
"David Gugick" wrote:

> raghu veer wrote:
> No way to know for sure given the limited amount of information.
> Assuming you do not have SQL tuning problems or CPU-related issues (not
> enough CPU or other services/applications using too much), then a drive
> change should be in order. It's always a good idea to separate data and
> log files.
> A query timeout occurs when you set a maximum limit for query execution
> in your code. Have you set a maximum timeout value? Make sure you roll
> back the transaction when the query times out.
>
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>|||R.D wrote:
> BOL has this
> SET QUERY_GOVERNOR_COST_LIMIT
> Overrides the currently configured value for the current connection.
> <SNIP>
Are you saying you are setting a governor limit? If so, I wouldn't think
resource overutilization on the server would cause queries to not run
using this setting. Could you clarify?
David Gugick
Quest Software
www.imceda.com
www.quest.com

Please help me out

I have written a sql procedure, i want to pass delared variable @.cnt in line131,char24
below is the PL Code:
CREATE PROCEDURE PL
@.dt varchar(10),
@.stock as bit --1/true for updated and 0/false for previous executed data
AS

set dateformat dmy
set nocount on

Declare @.sdate VARCHAR(10)
Declare @.clup as Decimal(18,2)
declare @.cnt as integer
DECLARE @.amt as decimal(18,2),@.gamt as decimal(18,2), @.damt as decimal(18,2), @.camt as decimal(18,2)

delete from temp_pl
delete from temp_bal

Select @.sdate = Convert(varchar(10),StartDate,103 ) From Param
exec show_trial @.dt
-- Now data is in temp_trial
if( @.Stock =1 )
begin
exec Closing @.sdate, @.dt
end

select party_nm as acc, dr_amt as Amtdr, cr_amt as Amtcr into #Tlist from temp_trial WHERE party_cd not in (150,152,151,38,36,33,32,35,34)
--select * from #tlist

SELECT Acc,AmtDr,AmtCr ,Type, odr into #tmpop FROM (
Select 'Opening Stock (UP)' as Acc ,'AmtDr'= case when oup >0 then oup else 0 end ,
'AmtCr'= case when oup <0 then abs(oup) else 0 end , 'T' as Type ,1 as odr From temp_stock_balance
union
Select 'Opening Stock (Ex UP)' as Acc ,'AmtDr'= case when oex >0 then oex else 0 end ,
'AmtCr'= case when oex <0 then abs(oex) else 0 end , 'T' as Type ,1 as odr From temp_stock_balance

union
Select 'Purchase (UP)' as Acc ,'AmtDr'= case when pup >0 then pup else 0 end ,
'AmtCr'= case when pup <0 then abs(pup) else 0 end , 'T' as Type ,2 as odr From temp_stock_balance
union
Select 'Purchase (Ex UP)' as Acc ,'AmtDr'= case when pex >0 then pex else 0 end ,
'AmtCr'= case when pex <0 then abs(pex) else 0 end , 'T' as Type ,2 as odr From temp_stock_balance
union
Select 'Sales (UP)' as Acc , 'AmtDr' =case when sUp < 0 then abs(sup) else 0 END ,
'AmtCr' =case when sup > 0 then sup else 0 eND, 'T' as Type ,2 as odr From temp_stock_balance
union
Select 'Sales (Ex-UP)' as Acc , 'AmtDr' =case when sex < 0 then abs(sex) else 0 END ,
'AmtCr' =case when sex > 0 then sex else 0 eND, 'T' as Type ,2 as odr From temp_stock_balance

union
Select 'Closing Stock(UP)' as Acc , 'AmtDr' =case when CUp < 0 then abs(cup) else 0 END ,
'AmtCr' =case when Cup > 0 then cup else 0 eND, 'T' as Type ,3 as odr From temp_stock_balance
union
Select 'Closing Stock(Ex-UP)' as Acc , 'AmtDr' =case when Cex < 0 then abs(cex) else 0 END ,
'AmtCr' =case when Cex > 0 then cex else 0 eND, 'T' as Type ,3 as odr From temp_stock_balance
)A

Select * into #tmpl from(
SELECT Acc, AmtDr, AmtCr ,Type ,odr
From (Select * from #tlist ) a INNER JOIN (Select party_nm,Ac_type as Type,odr From Party where Ac_type IN ('P','T') )
Acmast ON a.Acc = Acmast.Party_nm
UNION
select Acc,AmtDr,AmtCr ,Type , odr from #tmpop
) a

update #tmpl set Amtdr = abs(AmtCr) where AmtCr < 0
update #tmpl set AmtCr =abs( Amtdr) where AmtDr < 0
/*
--Gp
set @.clup = (Select 'GP' = case
when sum(AmtDr)>= sum(AmtCr) then (Sum(AmtDr) -Sum(AmtCr) )* -1

When sum(AmtDr) < Sum(AmtCr) then (Sum(AmtCr) -Sum(AmtDr) ) end From #tmpl where Type= 'T' )
*/
--TRADING A/C
SELECT Acc , AmtCr,type into #CT FROM #tmpL WHERE (AmtCr > 0 and Type ='T') order by odr Asc, Acc asc
SELECT Acc , AmtDr,type into #DT FROM #tmpL WHERE (AmtDr > 0 and Type ='T') order by odr Asc, Acc asc

SELECT IDENTITY(int, 1,1) AS ids,Acc , AmtCr,type into #CreditT FROM #CT
SELECT IDENTITY(int, 1,1) AS ids,Acc , AmtDr,type into #debitT FROM #DT

Select IDENTITY(int, 1,1) AS sr_no, * INTO #TRADE1 from
(Select d.Acc as Accdr , d.AmtDr as AmtDr , C.acc as AccCr ,C.amtCr as AmtCr ,'T' as Type from
#debitT d Full outer join #creditT c on c.ids =d.ids
)A
insert into #trade1 values(null,0,null,0,'T') --Line before sum

select @.amt=sum(isnull(amtcr,0))-sum(isnull(amtdr,0)) from #trade1

select @.damt=sum(isnull(amtdr,0)) from #trade1
select @.camt=sum(isnull(amtcr,0)) from #trade1
insert into #trade1 values (null,@.damt,null,@.camt,'T')
if @.amt>0
begin
select @.gamt=sum(isnull(amtcr,0)) from #trade1
insert into #trade1 (accdr,amtdr,type) values('Gross Profit C/F to P&L',@.amt,'T')
end
else if @.amt<0
begin
select @.gamt=sum(isnull(amtdr,0)) from #trade1
insert into #trade1 (acccr,amtcr,type) values('Gross Loss C/F to P&L',abs(@.amt),'T')
end
else
begin
select @.gamt=sum(isnull(amtdr,0)) from #trade1
end
insert into #trade1 values(null,0,null,0,'T') --Line after gross
insert into #trade1 values(null,@.gamt,null,@.gamt,'T')
insert into #trade1 values(null,0,null,0,'T') --Line after Trade gross
if @.amt>0
begin
insert into #trade1 (acccr,amtcr,type) values('Gross Profit B/F from P&L',@.amt,'P')
end
else if @.amt<0
begin
insert into #trade1 (accdr,amtdr,type) values('Gross Loss B/F from P&L',abs(@.amt),'P')
end
else
begin
insert into #trade1 values(null,null,null,null,'T')
end
Select * INTO #TRADE from #trade1 order by sr_no
------------------------------
--P/L A/C

SELECT Acc , AmtCr,type into #CP FROM #tmpL WHERE (AmtCr > 0 and Type ='P') order by odr Asc, Acc asc
SELECT Acc , AmtDr,type into #DP FROM #tmpL WHERE (AmtDr > 0 and Type ='P') order by odr Asc, Acc asc

SELECT IDENTITY(int, 1,1) AS ids,Acc , AmtCr,type into #CreditP FROM #CP
SELECT IDENTITY(int, 1,1) AS ids,Acc , AmtDr,type into #debitP FROM #DP

select @.cnt=count(SR_NO)+1 from #trade

select IDENTITY (int,@.cnt,1) AS sr_no,accdr,amtdr,acccr,amtcr,type INTO #PL_TEMP1 from #trade t WHERE t.type='P'

insert into #pl_temp1 (accdr,amtdr,acccr,amtcr,type)
Select d.Acc ,d.AmtDr, C.acc ,C.amtCr as AmtCr ,'P' as Type from
#debitP d Full outer join #creditP c on c.ids =d.ids

delete from #trade WHERE type='P'
select @.amt=sum(isnull(amtcr,0))-sum(isnull(amtdr,0)) from #PL_TEMP1

insert into #PL_TEMP1 values(null,0,null,0,'P') --line before sum

select @.amt=sum(isnull(amtcr,0))-sum(isnull(amtdr,0)) from #PL_TEMP1
insert into temp_bal values(@.amt)

select @.damt=sum(isnull(amtdr,0)) from #PL_TEMP1
select @.camt=sum(isnull(amtcr,0)) from #PL_TEMP1
insert into #PL_TEMP1 values (null,@.damt,null,@.camt,'P')
if @.amt>0
begin
select @.gamt=sum(isnull(amtcr,0)) from #PL_TEMP1
insert into #PL_TEMP1 (accdr,amtdr,type) values('Net Profit C/F to Balance Sheet',@.amt,'P')
end
else if @.amt<0
begin
select @.gamt=sum(isnull(amtdr,0)) from #PL_TEMP1
insert into #PL_TEMP1 (acccr,amtcr,type) values('Net Loss C/F to Balance Sheet',abs(@.amt),'P')
end
else
begin
select @.gamt=sum(isnull(amtdr,0)) from #PL_TEMP1
end
insert into #PL_TEMP1 values(null,0,null,0,'P') --Line after NET
insert into #PL_TEMP1 values(null,@.gamt,null,@.gamt,'P')
insert into #PL_TEMP1 values(null,0,null,0,'P') --Line after PL NET

Select * INTO #PL_TEMP from #PL_TEMP1 order by sr_no

INSERT INTO temp_PL
SELECT * FROM
(select * from #PL_TEMP
UNION
SELECT * FROM #TRADE
) a order by sr_no
GO

please help meDo not post your procedure. Just explain your problem in detail and post code in the pirticular error area.

Please help me on Script

we are using a data loading tool that periodically changes a database option for several databases in several of the database instances. One of these options is the database Auto-Close option. When this option is enabled, the database will close and generate a very large error log. We already using stored procedure script to monitor all the activity happening. I need to track all the activity happens after this Auto-Close option enables, for this i will have to add some script in my script which monitors daily activity.I am new to Scripts. Please help me, what to write in script.

Regards,
SumitWhy you're using AUTO_CLOSE option on that database?
In order to monitor the activity you can schedule server side trace and refer to http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm link fyi.|||Why you're using AUTO_CLOSE option on that database?
In order to monitor the activity you can schedule server side trace and refer to http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm link fyi.

Hi,
Thanks for your responce, I donot have option to use Auto_close option or not, I just have to find out how can I add this option to our daily report email script. There are lots of changes occur when this option enable mainly it increase the log file size that i need to include my mail report, I am not very much aware of the scrips. pls find some way so that i can add it in scripts running.

Regards,
sumit

Please help me install RS on Vista Business 64bit

SS2005 64bit is installed and running fine on my copy of Vista Business 64
here
I've gone into Programs and Features and enabled all the IIS/ASP.NET stuff
posted on the internet.
I've also created a IWAM_computername account and added it to the
Administrators group.
The setup program says it has to be run from the command prompt with the
SKUUPGRADE=1 paramater and now I'm resorting to tedious guesswork.
This is what I've tried:
E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
ADDLOCAL=RS_Server
INSTANCENAME=SQL2K5 RSACCOUNT="mycomputername\Clive"
RSPASSWORD="thepassword" SKUUPGRADE=1 /qb
It gets to installing Reporting Services and when the status is "Configuring
Components" it gives the error:
"SQL Server setup could not validate the service accounts. Either the
service accounts have not been provided for all of the services being
installed, or the specified username or password is incorrect. For each
service, specify a valid username, password and domain or specify a built-in
system account."
I've also tried:
E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
ADDLOCAL=RS_Server
INSTANCENAME=SQL2K5 RSACCOUNT="LocalSystem" SKUUPGRADE=1 /qb
and
E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
ADDLOCAL=RS_Server
INSTANCENAME=SQL2K5 RSACCOUNT=LocalSystem SKUUPGRADE=1 /qb
Any help much appreciated!
Clive (London UK)If you don't get any help here you might have better luck on the web forum.
It has the other RS MVP and lots more MS people hanging there.
http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Clive" <clive@.EndorphinSoftware.co.uk> wrote in message
news:uRvBHM$FIHA.6068@.TK2MSFTNGP05.phx.gbl...
> SS2005 64bit is installed and running fine on my copy of Vista Business 64
> here
> I've gone into Programs and Features and enabled all the IIS/ASP.NET stuff
> posted on the internet.
> I've also created a IWAM_computername account and added it to the
> Administrators group.
> The setup program says it has to be run from the command prompt with the
> SKUUPGRADE=1 paramater and now I'm resorting to tedious guesswork.
> This is what I've tried:
> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> ADDLOCAL=RS_Server
> INSTANCENAME=SQL2K5 RSACCOUNT="mycomputername\Clive"
> RSPASSWORD="thepassword" SKUUPGRADE=1 /qb
> It gets to installing Reporting Services and when the status is
> "Configuring Components" it gives the error:
> "SQL Server setup could not validate the service accounts. Either the
> service accounts have not been provided for all of the services being
> installed, or the specified username or password is incorrect. For each
> service, specify a valid username, password and domain or specify a
> built-in system account."
> I've also tried:
> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> ADDLOCAL=RS_Server
> INSTANCENAME=SQL2K5 RSACCOUNT="LocalSystem" SKUUPGRADE=1 /qb
> and
> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> ADDLOCAL=RS_Server
> INSTANCENAME=SQL2K5 RSACCOUNT=LocalSystem SKUUPGRADE=1 /qb
> Any help much appreciated!
> Clive (London UK)|||Ok to begin with if there was not an IWAM_ account already created then you
don't need to create one.
Secondly ignore that SKUUPGRADE thing. It's just a warning and I've seen it
when I know for a fact that I am using the same edition that was already
installed.
Follow the steps in the article here:
http://support.microsoft.com/kb/934164/en-us
Also, make sure that you've run aspnet_regiis -i from the
c:\windows\microsoft.net\framework64\v2.0.50727 folder. If the 64bit ASP
.NET extensions aren't registered then it won't even load up the pages in
the first place. Then make sure that the 32bit ASP .NET web service
extensions have been disabled from IIS and that the 64bit extensions are
enabled.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: "Clive" <clive@.EndorphinSoftware.co.uk>
> Subject: Please help me install RS on Vista Business 64bit
> Date: Fri, 26 Oct 2007 18:09:51 +0100
> Lines: 44
> MIME-Version: 1.0
> Content-Type: text/plain;
> format=flowed;
> charset="iso-8859-1";
> reply-type=original
> SS2005 64bit is installed and running fine on my copy of Vista Business
64
> here
> I've gone into Programs and Features and enabled all the IIS/ASP.NET
stuff
> posted on the internet.
> I've also created a IWAM_computername account and added it to the
> Administrators group.
> The setup program says it has to be run from the command prompt with the
> SKUUPGRADE=1 paramater and now I'm resorting to tedious guesswork.
> This is what I've tried:
> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> ADDLOCAL=RS_Server
> INSTANCENAME=SQL2K5 RSACCOUNT="mycomputername\Clive"
> RSPASSWORD="thepassword" SKUUPGRADE=1 /qb
> It gets to installing Reporting Services and when the status is
"Configuring
> Components" it gives the error:
> "SQL Server setup could not validate the service accounts. Either the
> service accounts have not been provided for all of the services being
> installed, or the specified username or password is incorrect. For each
> service, specify a valid username, password and domain or specify a
built-in
> system account."
> I've also tried:
> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> ADDLOCAL=RS_Server
> INSTANCENAME=SQL2K5 RSACCOUNT="LocalSystem" SKUUPGRADE=1 /qb
> and
> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> ADDLOCAL=RS_Server
> INSTANCENAME=SQL2K5 RSACCOUNT=LocalSystem SKUUPGRADE=1 /qb
> Any help much appreciated!
> Clive (London UK)
>|||Thanks for that Chris. It's installing now - but not working. (I noticed
that also no new RS system DBs have been added).
I've removed all mentions of ASP.NET 32 in IIS Manager (Anything that didn't
say 64) - from ISAPI and CGI Restrictions and ISAPI Filters
The Reporting Services Configuration Manager gives a WMI error (see below):
What else am I doing wrong?
(I've ended up installing various instances and setup REMOVE=RS_Server
doesn't seem to be removing them. Tips on that would also be helpful.)
Many thanks,
Clive
---
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has
occurred and no additional error information is available. -->
System.Runtime.InteropServices.COMException (0x8000000A)
at
System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
errorCode, IntPtr errorInfo)
at System.Management.ManagementObject.InvokeMethod(String methodName,
ManagementBaseObject inParameters, InvokeMethodOptions options)
at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
-- End of inner exception stack trace --
at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
at
ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration()
at
ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemNames
itemName)
at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs e)
at System.Windows.Forms.Form.set_Active(Boolean value)
at System.Windows.Forms.Form.WmActivate(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
---
RSConfigTool
Assembly Version: 9.0.242.0
Win32 Version: 9.00.3042.00
CodeBase:
file:///C:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/90/Tools/binn/RSConfigTool.exe
---
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
---
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
---
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
---
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
---
System.Management
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll
---
System.ServiceProcess
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
CodeBase:
file:///C:/Windows/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f11d50a3a/System.ServiceProcess.dll
---
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
"Chris Alton [MSFT]" <calton@.online.microsoft.com> wrote in message
news:fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl...
> Ok to begin with if there was not an IWAM_ account already created then
> you
> don't need to create one.
> Secondly ignore that SKUUPGRADE thing. It's just a warning and I've seen
> it
> when I know for a fact that I am using the same edition that was already
> installed.
> Follow the steps in the article here:
> http://support.microsoft.com/kb/934164/en-us
> Also, make sure that you've run aspnet_regiis -i from the
> c:\windows\microsoft.net\framework64\v2.0.50727 folder. If the 64bit ASP
> NET extensions aren't registered then it won't even load up the pages in
> the first place. Then make sure that the 32bit ASP .NET web service
> extensions have been disabled from IIS and that the 64bit extensions are
> enabled.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> --
>> From: "Clive" <clive@.EndorphinSoftware.co.uk>
>> Subject: Please help me install RS on Vista Business 64bit
>> Date: Fri, 26 Oct 2007 18:09:51 +0100
>> Lines: 44
>> MIME-Version: 1.0
>> Content-Type: text/plain;
>> format=flowed;
>> charset="iso-8859-1";
>> reply-type=original
>> SS2005 64bit is installed and running fine on my copy of Vista Business
> 64
>> here
>> I've gone into Programs and Features and enabled all the IIS/ASP.NET
> stuff
>> posted on the internet.
>> I've also created a IWAM_computername account and added it to the
>> Administrators group.
>> The setup program says it has to be run from the command prompt with the
>> SKUUPGRADE=1 paramater and now I'm resorting to tedious guesswork.
>> This is what I've tried:
>> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
>> ADDLOCAL=RS_Server
>> INSTANCENAME=SQL2K5 RSACCOUNT="mycomputername\Clive"
>> RSPASSWORD="thepassword" SKUUPGRADE=1 /qb
>> It gets to installing Reporting Services and when the status is
> "Configuring
>> Components" it gives the error:
>> "SQL Server setup could not validate the service accounts. Either the
>> service accounts have not been provided for all of the services being
>> installed, or the specified username or password is incorrect. For each
>> service, specify a valid username, password and domain or specify a
> built-in
>> system account."
>> I've also tried:
>> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
>> ADDLOCAL=RS_Server
>> INSTANCENAME=SQL2K5 RSACCOUNT="LocalSystem" SKUUPGRADE=1 /qb
>> and
>> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
>> ADDLOCAL=RS_Server
>> INSTANCENAME=SQL2K5 RSACCOUNT=LocalSystem SKUUPGRADE=1 /qb
>> Any help much appreciated!
>> Clive (London UK)
>>
>|||0x8000000A means "The data necessary to complete this operation is not yet
available."
There was a bug that caused this error on Vista Systems but it was fixed in
SP2.
Did you install Reporting Services before or after you installed SP2?
If you installed Reporting Services after you installed SP2 then you will
need to apply SP2 again since Reporting Services will not be upgraded and
therefore the bug will not be fixed.
If you want you can delete the ReportServer and TempDB databases since they
can be easily recreated using the configuration tool.
> mscorlib
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
> ---
> RSConfigTool
> Assembly Version: 9.0.242.0
> Win32 Version: 9.00.3042.00
> CodeBase:
>
file:///C:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/90/Tools/binn/RS
ConfigTool.exe
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: "Clive" <clive@.EndorphinSoftware.co.uk>
> References: <uRvBHM$FIHA.6068@.TK2MSFTNGP05.phx.gbl>
<fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl>
> In-Reply-To: <fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl>
> Subject: Re: Please help me install RS on Vista Business 64bit
> Date: Fri, 26 Oct 2007 19:38:12 +0100
> Lines: 211
> MIME-Version: 1.0
> Content-Type: text/plain;
> format=flowed;
> charset="iso-8859-1";
> reply-type=original
> Content-Transfer-Encoding: 7bit
> Thanks for that Chris. It's installing now - but not working. (I
noticed
> that also no new RS system DBs have been added).
> I've removed all mentions of ASP.NET 32 in IIS Manager (Anything that
didn't
> say 64) - from ISAPI and CGI Restrictions and ISAPI Filters
> The Reporting Services Configuration Manager gives a WMI error (see
below):
> What else am I doing wrong?
> (I've ended up installing various instances and setup REMOVE=RS_Server
> doesn't seem to be removing them. Tips on that would also be helpful.)
> Many thanks,
> Clive
> ---
> See the end of this message for details on invoking
> just-in-time (JIT) debugging instead of this dialog box.
> ************** Exception Text **************
> ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has
> occurred and no additional error information is available. -->
> System.Runtime.InteropServices.COMException (0x8000000A)
> at
> System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
> errorCode, IntPtr errorInfo)
> at System.Management.ManagementObject.InvokeMethod(String methodName,
> ManagementBaseObject inParameters, InvokeMethodOptions options)
> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
> -- End of inner exception stack trace --
> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
> at
> ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration()
> at
>
ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemName
s
> itemName)
> at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
> at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
> at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
> at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs e)
> at System.Windows.Forms.Form.set_Active(Boolean value)
> at System.Windows.Forms.Form.WmActivate(Message& m)
> at System.Windows.Forms.Form.WndProc(Message& m)
> at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&
m)
> at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
> at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
> IntPtr wparam, IntPtr lparam)
>
> ************** Loaded Assemblies **************
> mscorlib
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
> file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
> ---
> RSConfigTool
> Assembly Version: 9.0.242.0
> Win32 Version: 9.00.3042.00
> CodeBase:
>
file:///C:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/90/Tools/binn/RS
ConfigTool.exe
> ---
> System.Windows.Forms
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
>
file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561
934e089/System.Windows.Forms.dll
> ---
> System
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
>
file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System
.dll
> ---
> System.Drawing
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
>
file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3
a/System.Drawing.dll
> ---
> System.Xml
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
>
file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/Sy
stem.Xml.dll
> ---
> System.Management
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
>
file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d5
0a3a/System.Management.dll
> ---
> System.ServiceProcess
> Assembly Version: 2.0.0.0
> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> CodeBase:
>
file:///C:/Windows/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f
11d50a3a/System.ServiceProcess.dll
> ---
> ************** JIT Debugging **************
> To enable just-in-time (JIT) debugging, the .config file for this
> application or computer (machine.config) must have the
> jitDebugging value set in the system.windows.forms section.
> The application must also be compiled with debugging
> enabled.
> For example:
> <configuration>
> <system.windows.forms jitDebugging="true" />
> </configuration>
> When JIT debugging is enabled, any unhandled exception
> will be sent to the JIT debugger registered on the computer
> rather than be handled by this dialog box.
>
>
>
> "Chris Alton [MSFT]" <calton@.online.microsoft.com> wrote in message
> news:fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl...
> > Ok to begin with if there was not an IWAM_ account already created then
> > you
> > don't need to create one.
> >
> > Secondly ignore that SKUUPGRADE thing. It's just a warning and I've
seen
> > it
> > when I know for a fact that I am using the same edition that was already
> > installed.
> >
> > Follow the steps in the article here:
> > http://support.microsoft.com/kb/934164/en-us
> >
> > Also, make sure that you've run aspnet_regiis -i from the
> > c:\windows\microsoft.net\framework64\v2.0.50727 folder. If the 64bit ASP
> > NET extensions aren't registered then it won't even load up the pages in
> > the first place. Then make sure that the 32bit ASP .NET web service
> > extensions have been disabled from IIS and that the 64bit extensions are
> > enabled.
> >
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > --
> >> From: "Clive" <clive@.EndorphinSoftware.co.uk>
> >> Subject: Please help me install RS on Vista Business 64bit
> >> Date: Fri, 26 Oct 2007 18:09:51 +0100
> >> Lines: 44
> >> MIME-Version: 1.0
> >> Content-Type: text/plain;
> >> format=flowed;
> >> charset="iso-8859-1";
> >> reply-type=original
> >>
> >> SS2005 64bit is installed and running fine on my copy of Vista Business
> > 64
> >> here
> >>
> >> I've gone into Programs and Features and enabled all the IIS/ASP.NET
> > stuff
> >> posted on the internet.
> >>
> >> I've also created a IWAM_computername account and added it to the
> >> Administrators group.
> >>
> >> The setup program says it has to be run from the command prompt with
the
> >> SKUUPGRADE=1 paramater and now I'm resorting to tedious guesswork.
> >>
> >> This is what I've tried:
> >>
> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> >> ADDLOCAL=RS_Server
> >> INSTANCENAME=SQL2K5 RSACCOUNT="mycomputername\Clive"
> >> RSPASSWORD="thepassword" SKUUPGRADE=1 /qb
> >>
> >> It gets to installing Reporting Services and when the status is
> > "Configuring
> >> Components" it gives the error:
> >>
> >> "SQL Server setup could not validate the service accounts. Either the
> >> service accounts have not been provided for all of the services being
> >> installed, or the specified username or password is incorrect. For
each
> >> service, specify a valid username, password and domain or specify a
> > built-in
> >> system account."
> >>
> >> I've also tried:
> >>
> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> >> ADDLOCAL=RS_Server
> >> INSTANCENAME=SQL2K5 RSACCOUNT="LocalSystem" SKUUPGRADE=1 /qb
> >>
> >> and
> >>
> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> >> ADDLOCAL=RS_Server
> >> INSTANCENAME=SQL2K5 RSACCOUNT=LocalSystem SKUUPGRADE=1 /qb
> >>
> >> Any help much appreciated!
> >>
> >> Clive (London UK)
> >>
> >>
> >
>|||I had upgraded SQL2005 to SP2 - but ran the original setup CD to try and
install RS again.
Now I've applied SP2 to the failed RS installation from original CD - and it
is looking much better - but I still can't access the reportserver from IE -
it fails to authenticate when I try to log in as Administrator. It just
keeps prompting again for username and password - and I've changed the Admin
password so as to be sure I'm definitely entering it correctly in IE. After
three attempts it gives HTTP Error 401.3 - Unauthorized
In Programs and Features, in IIS -> World Wide Web Services -> Security,
I've turned on Windows Authrntication as well as Basic Authrntication,
Request Filtering and URL Authorisation
I've tried too many things to mention - and I think it's now a complete
mess. Now I'd just like to wipe off all instances of the DB Engine and RS
but I'm even having difficulty doing that. The uninstall program only
mentions some of the instances - and after "uninstalling" an RS instance -
it's still there!
Is there a global SS 2005 wipe function that will enable me to start again?
If not I think I'll just wipe Vista and put Win 2003 on the laptop and start
again from there.
Many thanks for your help
Clive
"Chris Alton [MSFT]" <calton@.online.microsoft.com> wrote in message
news:cbqRstAGIHA.360@.TK2MSFTNGHUB02.phx.gbl...
> 0x8000000A means "The data necessary to complete this operation is not yet
> available."
> There was a bug that caused this error on Vista Systems but it was fixed
> in
> SP2.
> Did you install Reporting Services before or after you installed SP2?
> If you installed Reporting Services after you installed SP2 then you will
> need to apply SP2 again since Reporting Services will not be upgraded and
> therefore the bug will not be fixed.
> If you want you can delete the ReportServer and TempDB databases since
> they
> can be easily recreated using the configuration tool.
>> mscorlib
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
>> ---
>> RSConfigTool
>> Assembly Version: 9.0.242.0
>> Win32 Version: 9.00.3042.00
>> CodeBase:
> file:///C:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/90/Tools/binn/RS
> ConfigTool.exe
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> --
>> From: "Clive" <clive@.EndorphinSoftware.co.uk>
>> References: <uRvBHM$FIHA.6068@.TK2MSFTNGP05.phx.gbl>
> <fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl>
>> In-Reply-To: <fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl>
>> Subject: Re: Please help me install RS on Vista Business 64bit
>> Date: Fri, 26 Oct 2007 19:38:12 +0100
>> Lines: 211
>> MIME-Version: 1.0
>> Content-Type: text/plain;
>> format=flowed;
>> charset="iso-8859-1";
>> reply-type=original
>> Content-Transfer-Encoding: 7bit
>> Thanks for that Chris. It's installing now - but not working. (I
> noticed
>> that also no new RS system DBs have been added).
>> I've removed all mentions of ASP.NET 32 in IIS Manager (Anything that
> didn't
>> say 64) - from ISAPI and CGI Restrictions and ISAPI Filters
>> The Reporting Services Configuration Manager gives a WMI error (see
> below):
>> What else am I doing wrong?
>> (I've ended up installing various instances and setup REMOVE=RS_Server
>> doesn't seem to be removing them. Tips on that would also be helpful.)
>> Many thanks,
>> Clive
>> ---
>> See the end of this message for details on invoking
>> just-in-time (JIT) debugging instead of this dialog box.
>> ************** Exception Text **************
>> ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has
>> occurred and no additional error information is available. -->
>> System.Runtime.InteropServices.COMException (0x8000000A)
>> at
>> System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
>> errorCode, IntPtr errorInfo)
>> at System.Management.ManagementObject.InvokeMethod(String methodName,
>> ManagementBaseObject inParameters, InvokeMethodOptions options)
>> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
>> -- End of inner exception stack trace --
>> at ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
>> at
>> ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration()
>> at
> ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemName
> s
>> itemName)
>> at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
>> at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
>> at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
>> at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs
>> e)
>> at System.Windows.Forms.Form.set_Active(Boolean value)
>> at System.Windows.Forms.Form.WmActivate(Message& m)
>> at System.Windows.Forms.Form.WndProc(Message& m)
>> at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&
> m)
>> at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&
>> m)
>> at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
>> IntPtr wparam, IntPtr lparam)
>>
>> ************** Loaded Assemblies **************
>> mscorlib
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
>> ---
>> RSConfigTool
>> Assembly Version: 9.0.242.0
>> Win32 Version: 9.00.3042.00
>> CodeBase:
> file:///C:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/90/Tools/binn/RS
> ConfigTool.exe
>> ---
>> System.Windows.Forms
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561
> 934e089/System.Windows.Forms.dll
>> ---
>> System
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System
> dll
>> ---
>> System.Drawing
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3
> a/System.Drawing.dll
>> ---
>> System.Xml
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/Sy
> stem.Xml.dll
>> ---
>> System.Management
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d5
> 0a3a/System.Management.dll
>> ---
>> System.ServiceProcess
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
> file:///C:/Windows/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f
> 11d50a3a/System.ServiceProcess.dll
>> ---
>> ************** JIT Debugging **************
>> To enable just-in-time (JIT) debugging, the .config file for this
>> application or computer (machine.config) must have the
>> jitDebugging value set in the system.windows.forms section.
>> The application must also be compiled with debugging
>> enabled.
>> For example:
>> <configuration>
>> <system.windows.forms jitDebugging="true" />
>> </configuration>
>> When JIT debugging is enabled, any unhandled exception
>> will be sent to the JIT debugger registered on the computer
>> rather than be handled by this dialog box.
>>
>>
>>
>> "Chris Alton [MSFT]" <calton@.online.microsoft.com> wrote in message
>> news:fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl...
>> > Ok to begin with if there was not an IWAM_ account already created then
>> > you
>> > don't need to create one.
>> >
>> > Secondly ignore that SKUUPGRADE thing. It's just a warning and I've
> seen
>> > it
>> > when I know for a fact that I am using the same edition that was
>> > already
>> > installed.
>> >
>> > Follow the steps in the article here:
>> > http://support.microsoft.com/kb/934164/en-us
>> >
>> > Also, make sure that you've run aspnet_regiis -i from the
>> > c:\windows\microsoft.net\framework64\v2.0.50727 folder. If the 64bit
>> > ASP
>> > NET extensions aren't registered then it won't even load up the pages
>> > in
>> > the first place. Then make sure that the 32bit ASP .NET web service
>> > extensions have been disabled from IIS and that the 64bit extensions
>> > are
>> > enabled.
>> >
>> > --
>> > Chris Alton, Microsoft Corp.
>> > SQL Server Developer Support Engineer
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> > --
>> >> From: "Clive" <clive@.EndorphinSoftware.co.uk>
>> >> Subject: Please help me install RS on Vista Business 64bit
>> >> Date: Fri, 26 Oct 2007 18:09:51 +0100
>> >> Lines: 44
>> >> MIME-Version: 1.0
>> >> Content-Type: text/plain;
>> >> format=flowed;
>> >> charset="iso-8859-1";
>> >> reply-type=original
>> >>
>> >> SS2005 64bit is installed and running fine on my copy of Vista
>> >> Business
>> > 64
>> >> here
>> >>
>> >> I've gone into Programs and Features and enabled all the IIS/ASP.NET
>> > stuff
>> >> posted on the internet.
>> >>
>> >> I've also created a IWAM_computername account and added it to the
>> >> Administrators group.
>> >>
>> >> The setup program says it has to be run from the command prompt with
> the
>> >> SKUUPGRADE=1 paramater and now I'm resorting to tedious guesswork.
>> >>
>> >> This is what I've tried:
>> >>
>> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
>> >> ADDLOCAL=RS_Server
>> >> INSTANCENAME=SQL2K5 RSACCOUNT="mycomputername\Clive"
>> >> RSPASSWORD="thepassword" SKUUPGRADE=1 /qb
>> >>
>> >> It gets to installing Reporting Services and when the status is
>> > "Configuring
>> >> Components" it gives the error:
>> >>
>> >> "SQL Server setup could not validate the service accounts. Either the
>> >> service accounts have not been provided for all of the services being
>> >> installed, or the specified username or password is incorrect. For
> each
>> >> service, specify a valid username, password and domain or specify a
>> > built-in
>> >> system account."
>> >>
>> >> I've also tried:
>> >>
>> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
>> >> ADDLOCAL=RS_Server
>> >> INSTANCENAME=SQL2K5 RSACCOUNT="LocalSystem" SKUUPGRADE=1 /qb
>> >>
>> >> and
>> >>
>> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
>> >> ADDLOCAL=RS_Server
>> >> INSTANCENAME=SQL2K5 RSACCOUNT=LocalSystem SKUUPGRADE=1 /qb
>> >>
>> >> Any help much appreciated!
>> >>
>> >> Clive (London UK)
>> >>
>> >>
>> >
>>
>|||Chris - over the w/e I completely wiped my copy of Vista Business 64 and
started again.
RS2005 now works on Vista Business 64 - albeit web access is a bit slow to
get going.
But the important thing is it's working - thank you very much for your help.
Regards
Clive
"Clive" <clive@.EndorphinSoftware.co.uk> wrote in message
news:e8Vj8JHGIHA.5208@.TK2MSFTNGP04.phx.gbl...
>I had upgraded SQL2005 to SP2 - but ran the original setup CD to try and
>install RS again.
> Now I've applied SP2 to the failed RS installation from original CD - and
> it is looking much better - but I still can't access the reportserver from
> IE - it fails to authenticate when I try to log in as Administrator. It
> just keeps prompting again for username and password - and I've changed
> the Admin password so as to be sure I'm definitely entering it correctly
> in IE. After three attempts it gives HTTP Error 401.3 - Unauthorized
> In Programs and Features, in IIS -> World Wide Web Services -> Security,
> I've turned on Windows Authrntication as well as Basic Authrntication,
> Request Filtering and URL Authorisation
> I've tried too many things to mention - and I think it's now a complete
> mess. Now I'd just like to wipe off all instances of the DB Engine and RS
> but I'm even having difficulty doing that. The uninstall program only
> mentions some of the instances - and after "uninstalling" an RS instance -
> it's still there!
> Is there a global SS 2005 wipe function that will enable me to start
> again?
> If not I think I'll just wipe Vista and put Win 2003 on the laptop and
> start again from there.
>
> Many thanks for your help
> Clive
>
> "Chris Alton [MSFT]" <calton@.online.microsoft.com> wrote in message
> news:cbqRstAGIHA.360@.TK2MSFTNGHUB02.phx.gbl...
>> 0x8000000A means "The data necessary to complete this operation is not
>> yet
>> available."
>> There was a bug that caused this error on Vista Systems but it was fixed
>> in
>> SP2.
>> Did you install Reporting Services before or after you installed SP2?
>> If you installed Reporting Services after you installed SP2 then you will
>> need to apply SP2 again since Reporting Services will not be upgraded and
>> therefore the bug will not be fixed.
>> If you want you can delete the ReportServer and TempDB databases since
>> they
>> can be easily recreated using the configuration tool.
>> mscorlib
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
>> ---
>> RSConfigTool
>> Assembly Version: 9.0.242.0
>> Win32 Version: 9.00.3042.00
>> CodeBase:
>> file:///C:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/90/Tools/binn/RS
>> ConfigTool.exe
>> --
>> Chris Alton, Microsoft Corp.
>> SQL Server Developer Support Engineer
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> --
>> From: "Clive" <clive@.EndorphinSoftware.co.uk>
>> References: <uRvBHM$FIHA.6068@.TK2MSFTNGP05.phx.gbl>
>> <fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl>
>> In-Reply-To: <fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl>
>> Subject: Re: Please help me install RS on Vista Business 64bit
>> Date: Fri, 26 Oct 2007 19:38:12 +0100
>> Lines: 211
>> MIME-Version: 1.0
>> Content-Type: text/plain;
>> format=flowed;
>> charset="iso-8859-1";
>> reply-type=original
>> Content-Transfer-Encoding: 7bit
>> Thanks for that Chris. It's installing now - but not working. (I
>> noticed
>> that also no new RS system DBs have been added).
>> I've removed all mentions of ASP.NET 32 in IIS Manager (Anything that
>> didn't
>> say 64) - from ISAPI and CGI Restrictions and ISAPI Filters
>> The Reporting Services Configuration Manager gives a WMI error (see
>> below):
>> What else am I doing wrong?
>> (I've ended up installing various instances and setup REMOVE=RS_Server
>> doesn't seem to be removing them. Tips on that would also be helpful.)
>> Many thanks,
>> Clive
>> ---
>> See the end of this message for details on invoking
>> just-in-time (JIT) debugging instead of this dialog box.
>> ************** Exception Text **************
>> ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has
>> occurred and no additional error information is available. -->
>> System.Runtime.InteropServices.COMException (0x8000000A)
>> at
>> System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
>> errorCode, IntPtr errorInfo)
>> at System.Management.ManagementObject.InvokeMethod(String methodName,
>> ManagementBaseObject inParameters, InvokeMethodOptions options)
>> at
>> ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
>> -- End of inner exception stack trace --
>> at
>> ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
>> at
>> ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration()
>> at
>> ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemName
>> s
>> itemName)
>> at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
>> at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
>> at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
>> at ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs
>> e)
>> at System.Windows.Forms.Form.set_Active(Boolean value)
>> at System.Windows.Forms.Form.WmActivate(Message& m)
>> at System.Windows.Forms.Form.WndProc(Message& m)
>> at
>> System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&
>> m)
>> at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&
>> m)
>> at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
>> IntPtr wparam, IntPtr lparam)
>>
>> ************** Loaded Assemblies **************
>> mscorlib
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
>> ---
>> RSConfigTool
>> Assembly Version: 9.0.242.0
>> Win32 Version: 9.00.3042.00
>> CodeBase:
>> file:///C:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/90/Tools/binn/RS
>> ConfigTool.exe
>> ---
>> System.Windows.Forms
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561
>> 934e089/System.Windows.Forms.dll
>> ---
>> System
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System
>> dll
>> ---
>> System.Drawing
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3
>> a/System.Drawing.dll
>> ---
>> System.Xml
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/Sy
>> stem.Xml.dll
>> ---
>> System.Management
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d5
>> 0a3a/System.Management.dll
>> ---
>> System.ServiceProcess
>> Assembly Version: 2.0.0.0
>> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
>> CodeBase:
>> file:///C:/Windows/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f
>> 11d50a3a/System.ServiceProcess.dll
>> ---
>> ************** JIT Debugging **************
>> To enable just-in-time (JIT) debugging, the .config file for this
>> application or computer (machine.config) must have the
>> jitDebugging value set in the system.windows.forms section.
>> The application must also be compiled with debugging
>> enabled.
>> For example:
>> <configuration>
>> <system.windows.forms jitDebugging="true" />
>> </configuration>
>> When JIT debugging is enabled, any unhandled exception
>> will be sent to the JIT debugger registered on the computer
>> rather than be handled by this dialog box.
>>
>>
>>
>> "Chris Alton [MSFT]" <calton@.online.microsoft.com> wrote in message
>> news:fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl...
>> > Ok to begin with if there was not an IWAM_ account already created
>> > then
>> > you
>> > don't need to create one.
>> >
>> > Secondly ignore that SKUUPGRADE thing. It's just a warning and I've
>> seen
>> > it
>> > when I know for a fact that I am using the same edition that was
>> > already
>> > installed.
>> >
>> > Follow the steps in the article here:
>> > http://support.microsoft.com/kb/934164/en-us
>> >
>> > Also, make sure that you've run aspnet_regiis -i from the
>> > c:\windows\microsoft.net\framework64\v2.0.50727 folder. If the 64bit
>> > ASP
>> > NET extensions aren't registered then it won't even load up the pages
>> > in
>> > the first place. Then make sure that the 32bit ASP .NET web service
>> > extensions have been disabled from IIS and that the 64bit extensions
>> > are
>> > enabled.
>> >
>> > --
>> > Chris Alton, Microsoft Corp.
>> > SQL Server Developer Support Engineer
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> > --
>> >> From: "Clive" <clive@.EndorphinSoftware.co.uk>
>> >> Subject: Please help me install RS on Vista Business 64bit
>> >> Date: Fri, 26 Oct 2007 18:09:51 +0100
>> >> Lines: 44
>> >> MIME-Version: 1.0
>> >> Content-Type: text/plain;
>> >> format=flowed;
>> >> charset="iso-8859-1";
>> >> reply-type=original
>> >>
>> >> SS2005 64bit is installed and running fine on my copy of Vista
>> >> Business
>> > 64
>> >> here
>> >>
>> >> I've gone into Programs and Features and enabled all the IIS/ASP.NET
>> > stuff
>> >> posted on the internet.
>> >>
>> >> I've also created a IWAM_computername account and added it to the
>> >> Administrators group.
>> >>
>> >> The setup program says it has to be run from the command prompt with
>> the
>> >> SKUUPGRADE=1 paramater and now I'm resorting to tedious guesswork.
>> >>
>> >> This is what I've tried:
>> >>
>> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
>> >> ADDLOCAL=RS_Server
>> >> INSTANCENAME=SQL2K5 RSACCOUNT="mycomputername\Clive"
>> >> RSPASSWORD="thepassword" SKUUPGRADE=1 /qb
>> >>
>> >> It gets to installing Reporting Services and when the status is
>> > "Configuring
>> >> Components" it gives the error:
>> >>
>> >> "SQL Server setup could not validate the service accounts. Either
>> >> the
>> >> service accounts have not been provided for all of the services being
>> >> installed, or the specified username or password is incorrect. For
>> each
>> >> service, specify a valid username, password and domain or specify a
>> > built-in
>> >> system account."
>> >>
>> >> I've also tried:
>> >>
>> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
>> >> ADDLOCAL=RS_Server
>> >> INSTANCENAME=SQL2K5 RSACCOUNT="LocalSystem" SKUUPGRADE=1 /qb
>> >>
>> >> and
>> >>
>> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
>> >> ADDLOCAL=RS_Server
>> >> INSTANCENAME=SQL2K5 RSACCOUNT=LocalSystem SKUUPGRADE=1 /qb
>> >>
>> >> Any help much appreciated!
>> >>
>> >> Clive (London UK)
>> >>
>> >>
>> >
>>
>|||That's great. Sorry about the late reply got a bit under the weather there
for a few days.
I was going to mention to you that a 401.3 error means that the account
accessing the web page does not have file access permissions to the file
being accessed. If you are using "anonymous" access this usually means that
the IUSR_MACHINENAME account does not have access to the SRS files in the
C:\program files\microsoft sql server\MSSQL.#\Reporting Services\Report
Manager folder. So all you need to do is add the IUSR_MACHINENAME account
to the Report Manager folder,give it read access and make sure that the
subfolders/items get that setting too.
Good luck on your future SRS endeavors :)
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: "Clive" <clive@.EndorphinSoftware.co.uk>
> References: <uRvBHM$FIHA.6068@.TK2MSFTNGP05.phx.gbl>
<fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl>
<uzBgg9$FIHA.284@.TK2MSFTNGP02.phx.gbl>
<cbqRstAGIHA.360@.TK2MSFTNGHUB02.phx.gbl>
<e8Vj8JHGIHA.5208@.TK2MSFTNGP04.phx.gbl>
> In-Reply-To: <e8Vj8JHGIHA.5208@.TK2MSFTNGP04.phx.gbl>
> Subject: Re: Please help me install RS on Vista Business 64bit
> Date: Mon, 29 Oct 2007 13:43:45 -0000
> Chris - over the w/e I completely wiped my copy of Vista Business 64 and
> started again.
> RS2005 now works on Vista Business 64 - albeit web access is a bit slow
to
> get going.
> But the important thing is it's working - thank you very much for your
help.
> Regards
> Clive
>
>
> "Clive" <clive@.EndorphinSoftware.co.uk> wrote in message
> news:e8Vj8JHGIHA.5208@.TK2MSFTNGP04.phx.gbl...
> >I had upgraded SQL2005 to SP2 - but ran the original setup CD to try
and
> >install RS again.
> >
> > Now I've applied SP2 to the failed RS installation from original CD -
and
> > it is looking much better - but I still can't access the reportserver
from
> > IE - it fails to authenticate when I try to log in as Administrator.
It
> > just keeps prompting again for username and password - and I've changed
> > the Admin password so as to be sure I'm definitely entering it
correctly
> > in IE. After three attempts it gives HTTP Error 401.3 - Unauthorized
> >
> > In Programs and Features, in IIS -> World Wide Web Services ->
Security,
> > I've turned on Windows Authrntication as well as Basic Authrntication,
> > Request Filtering and URL Authorisation
> >
> > I've tried too many things to mention - and I think it's now a complete
> > mess. Now I'd just like to wipe off all instances of the DB Engine and
RS
> > but I'm even having difficulty doing that. The uninstall program only
> > mentions some of the instances - and after "uninstalling" an RS
instance -
> > it's still there!
> >
> > Is there a global SS 2005 wipe function that will enable me to start
> > again?
> >
> > If not I think I'll just wipe Vista and put Win 2003 on the laptop and
> > start again from there.
> >
> >
> > Many thanks for your help
> >
> > Clive
> >
> >
> > "Chris Alton [MSFT]" <calton@.online.microsoft.com> wrote in message
> > news:cbqRstAGIHA.360@.TK2MSFTNGHUB02.phx.gbl...
> >> 0x8000000A means "The data necessary to complete this operation is not
> >> yet
> >> available."
> >>
> >> There was a bug that caused this error on Vista Systems but it was
fixed
> >> in
> >> SP2.
> >>
> >> Did you install Reporting Services before or after you installed SP2?
> >>
> >> If you installed Reporting Services after you installed SP2 then you
will
> >> need to apply SP2 again since Reporting Services will not be upgraded
and
> >> therefore the bug will not be fixed.
> >>
> >> If you want you can delete the ReportServer and TempDB databases since
> >> they
> >> can be easily recreated using the configuration tool.
> >>
> >> mscorlib
> >> Assembly Version: 2.0.0.0
> >> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> >> CodeBase:
> >> file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
> >> ---
> >> RSConfigTool
> >> Assembly Version: 9.0.242.0
> >> Win32 Version: 9.00.3042.00
> >> CodeBase:
> >>
> >>
file:///C:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/90/Tools/binn/RS
> >> ConfigTool.exe
> >>
> >> --
> >> Chris Alton, Microsoft Corp.
> >> SQL Server Developer Support Engineer
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >> --
> >> From: "Clive" <clive@.EndorphinSoftware.co.uk>
> >> References: <uRvBHM$FIHA.6068@.TK2MSFTNGP05.phx.gbl>
> >> <fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl>
> >> In-Reply-To: <fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl>
> >> Subject: Re: Please help me install RS on Vista Business 64bit
> >> Date: Fri, 26 Oct 2007 19:38:12 +0100
> >> Lines: 211
> >> MIME-Version: 1.0
> >> Content-Type: text/plain;
> >> format=flowed;
> >> charset="iso-8859-1";
> >> reply-type=original
> >> Content-Transfer-Encoding: 7bit
> >>
> >> Thanks for that Chris. It's installing now - but not working. (I
> >> noticed
> >> that also no new RS system DBs have been added).
> >>
> >> I've removed all mentions of ASP.NET 32 in IIS Manager (Anything that
> >> didn't
> >> say 64) - from ISAPI and CGI Restrictions and ISAPI Filters
> >>
> >> The Reporting Services Configuration Manager gives a WMI error (see
> >> below):
> >>
> >> What else am I doing wrong?
> >>
> >> (I've ended up installing various instances and setup REMOVE=RS_Server
> >> doesn't seem to be removing them. Tips on that would also be
helpful.)
> >>
> >> Many thanks,
> >> Clive
> >>
> >> ---
> >> See the end of this message for details on invoking
> >> just-in-time (JIT) debugging instead of this dialog box.
> >>
> >> ************** Exception Text **************
> >> ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error
has
> >> occurred and no additional error information is available. -->
> >> System.Runtime.InteropServices.COMException (0x8000000A)
> >> at
> >>
System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32
> >> errorCode, IntPtr errorInfo)
> >> at System.Management.ManagementObject.InvokeMethod(String
methodName,
> >> ManagementBaseObject inParameters, InvokeMethodOptions options)
> >> at
> >> ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
> >> -- End of inner exception stack trace --
> >> at
> >> ReportServicesConfigUI.WMIProvider.RSInstance.RefreshServerStatus()
> >> at
> >>
ReportServicesConfigUI.WMIProvider.RSInstance.get_DelayLoadConfiguration()
> >> at
> >>
> >>
ReportServicesConfigUI.WMIProvider.RSInstance.get_Item(ConfigurationItemName
> >> s
> >> itemName)
> >> at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus()
> >> at ReportServicesConfigUI.ConfigurationManager.ChangeMachine()
> >> at ReportServicesConfigUI.ConfigurationManager.LaunchDialog()
> >> at
ReportServicesConfigUI.ConfigurationManager.OnActivated(EventArgs
> >> e)
> >> at System.Windows.Forms.Form.set_Active(Boolean value)
> >> at System.Windows.Forms.Form.WmActivate(Message& m)
> >> at System.Windows.Forms.Form.WndProc(Message& m)
> >> at
> >> System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&
> >> m)
> >> at
System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&
> >> m)
> >> at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32
msg,
> >> IntPtr wparam, IntPtr lparam)
> >>
> >>
> >> ************** Loaded Assemblies **************
> >> mscorlib
> >> Assembly Version: 2.0.0.0
> >> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> >> CodeBase:
> >> file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
> >> ---
> >> RSConfigTool
> >> Assembly Version: 9.0.242.0
> >> Win32 Version: 9.00.3042.00
> >> CodeBase:
> >>
> >>
file:///C:/Program%20Files%20(x86)/Microsoft%20SQL%20Server/90/Tools/binn/RS
> >> ConfigTool.exe
> >> ---
> >> System.Windows.Forms
> >> Assembly Version: 2.0.0.0
> >> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> >> CodeBase:
> >>
> >>
file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561
> >> 934e089/System.Windows.Forms.dll
> >> ---
> >> System
> >> Assembly Version: 2.0.0.0
> >> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> >> CodeBase:
> >>
> >>
file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System
> >> dll
> >> ---
> >> System.Drawing
> >> Assembly Version: 2.0.0.0
> >> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> >> CodeBase:
> >>
> >>
file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3
> >> a/System.Drawing.dll
> >> ---
> >> System.Xml
> >> Assembly Version: 2.0.0.0
> >> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> >> CodeBase:
> >>
> >>
file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/Sy
> >> stem.Xml.dll
> >> ---
> >> System.Management
> >> Assembly Version: 2.0.0.0
> >> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> >> CodeBase:
> >>
> >>
file:///C:/Windows/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d5
> >> 0a3a/System.Management.dll
> >> ---
> >> System.ServiceProcess
> >> Assembly Version: 2.0.0.0
> >> Win32 Version: 2.0.50727.312 (rtmLHS.050727-3100)
> >> CodeBase:
> >>
> >>
file:///C:/Windows/assembly/GAC_MSIL/System.ServiceProcess/2.0.0.0__b03f5f7f
> >> 11d50a3a/System.ServiceProcess.dll
> >> ---
> >>
> >> ************** JIT Debugging **************
> >> To enable just-in-time (JIT) debugging, the .config file for this
> >> application or computer (machine.config) must have the
> >> jitDebugging value set in the system.windows.forms section.
> >> The application must also be compiled with debugging
> >> enabled.
> >>
> >> For example:
> >>
> >> <configuration>
> >> <system.windows.forms jitDebugging="true" />
> >> </configuration>
> >>
> >> When JIT debugging is enabled, any unhandled exception
> >> will be sent to the JIT debugger registered on the computer
> >> rather than be handled by this dialog box.
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> "Chris Alton [MSFT]" <calton@.online.microsoft.com> wrote in message
> >> news:fGkI4a$FIHA.540@.TK2MSFTNGHUB02.phx.gbl...
> >> > Ok to begin with if there was not an IWAM_ account already created
> >> > then
> >> > you
> >> > don't need to create one.
> >> >
> >> > Secondly ignore that SKUUPGRADE thing. It's just a warning and I've
> >> seen
> >> > it
> >> > when I know for a fact that I am using the same edition that was
> >> > already
> >> > installed.
> >> >
> >> > Follow the steps in the article here:
> >> > http://support.microsoft.com/kb/934164/en-us
> >> >
> >> > Also, make sure that you've run aspnet_regiis -i from the
> >> > c:\windows\microsoft.net\framework64\v2.0.50727 folder. If the
64bit
> >> > ASP
> >> > NET extensions aren't registered then it won't even load up the
pages
> >> > in
> >> > the first place. Then make sure that the 32bit ASP .NET web service
> >> > extensions have been disabled from IIS and that the 64bit
extensions
> >> > are
> >> > enabled.
> >> >
> >> > --
> >> > Chris Alton, Microsoft Corp.
> >> > SQL Server Developer Support Engineer
> >> > This posting is provided "AS IS" with no warranties, and confers no
> >> > rights.
> >> > --
> >> >> From: "Clive" <clive@.EndorphinSoftware.co.uk>
> >> >> Subject: Please help me install RS on Vista Business 64bit
> >> >> Date: Fri, 26 Oct 2007 18:09:51 +0100
> >> >> Lines: 44
> >> >> MIME-Version: 1.0
> >> >> Content-Type: text/plain;
> >> >> format=flowed;
> >> >> charset="iso-8859-1";
> >> >> reply-type=original
> >> >>
> >> >> SS2005 64bit is installed and running fine on my copy of Vista
> >> >> Business
> >> > 64
> >> >> here
> >> >>
> >> >> I've gone into Programs and Features and enabled all the
IIS/ASP.NET
> >> > stuff
> >> >> posted on the internet.
> >> >>
> >> >> I've also created a IWAM_computername account and added it to the
> >> >> Administrators group.
> >> >>
> >> >> The setup program says it has to be run from the command prompt
with
> >> the
> >> >> SKUUPGRADE=1 paramater and now I'm resorting to tedious guesswork.
> >> >>
> >> >> This is what I've tried:
> >> >>
> >> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> >> >> ADDLOCAL=RS_Server
> >> >> INSTANCENAME=SQL2K5 RSACCOUNT="mycomputername\Clive"
> >> >> RSPASSWORD="thepassword" SKUUPGRADE=1 /qb
> >> >>
> >> >> It gets to installing Reporting Services and when the status is
> >> > "Configuring
> >> >> Components" it gives the error:
> >> >>
> >> >> "SQL Server setup could not validate the service accounts. Either
> >> >> the
> >> >> service accounts have not been provided for all of the services
being
> >> >> installed, or the specified username or password is incorrect. For
> >> each
> >> >> service, specify a valid username, password and domain or specify a
> >> > built-in
> >> >> system account."
> >> >>
> >> >> I've also tried:
> >> >>
> >> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> >> >> ADDLOCAL=RS_Server
> >> >> INSTANCENAME=SQL2K5 RSACCOUNT="LocalSystem" SKUUPGRADE=1 /qb
> >> >>
> >> >> and
> >> >>
> >> >> E:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Servers>setup.exe
> >> >> ADDLOCAL=RS_Server
> >> >> INSTANCENAME=SQL2K5 RSACCOUNT=LocalSystem SKUUPGRADE=1 /qb
> >> >>
> >> >> Any help much appreciated!
> >> >>
> >> >> Clive (London UK)
> >> >>
> >> >>
> >> >
> >>
> >>
> >>
> >
>sql