cascading parameter help - solution

I a report that will have two parameters (Year and Account name), I'm having trouble setting up the second parameter to be filtered based on the value of the first parameter.

here is the second parameter with a value hard coded.(see bold text) this works fine when I run the report.

WITH MEMBER [Measures].[ParameterCaption] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,FILTER([CUSTOMER JOB].[ACCOUNT NAME].ALLMEMBERS,([Job Complete Date].[Year].&[2006],[Measures].[Billed Sales Amount])) ON ROWS FROM [DW PREP ARCHIVE]

When I try the following code where I have added in the equal sign and double quotes I get an error message (see below)

= "WITH MEMBER [Measures].[ParameterCaption] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,FILTER([CUSTOMER JOB].[ACCOUNT NAME].ALLMEMBERS,(" & Parameter!JobCompleteDateYear.value & ",[Measures].[Billed Sales Amount])) ON ROWS FROM [DW PREP ARCHIVE]"

error message

TITLE: Microsoft Visual Studio

The query cannot be retrieved from the query builder.
Check the query for syntax errors.
Reporting Services will continue to use the most recent valid query.

ADDITIONAL INFORMATION:

Query preparation failed. (Microsoft.AnalysisServices.Controls)

Query (1, 1) Parser: The syntax for '=' is incorrect. (msmgdsrv)

BUTTONS:

OK

Any suggestions ?

thanks

I found my solution. I needed to use the Strtomember function and inserted the parameter name as @.parametername

here is the final code

before

WITH MEMBER [Measures].[ParameterCaption] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,FILTER([CUSTOMER JOB].[ACCOUNT NAME].ALLMEMBERS,([Job Complete Date].[Year].&[2006],[Measures].[Billed Sales Amount])) ON ROWS FROM [DW PREP ARCHIVE]

after

WITH MEMBER [Measures].[ParameterCaption] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,FILTER([CUSTOMER JOB].[ACCOUNT NAME].ALLMEMBERS,(Strtomember(@.JobCompleteDateYear),[Measures].[Billed Sales Amount])) ON ROWS FROM [DW PREP ARCHIVE]

cascading parameter help

I a report that will have two parameters (Year and Account name), I'm having trouble setting up the second parameter to be filtered based on the value of the first parameter.

here is the second parameter with a value hard coded.(see bold text) this works fine when I run the report.

WITH MEMBER [Measures].[ParameterCaption] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,FILTER([CUSTOMER JOB].[ACCOUNT NAME].ALLMEMBERS,([Job Complete Date].[Year].&[2006],[Measures].[Billed Sales Amount])) ON ROWS FROM [DW PREP ARCHIVE]

When I try the following code where I have added in the equal sign and double quotes I get an error message (see below)

= "WITH MEMBER [Measures].[ParameterCaption] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,FILTER([CUSTOMER JOB].[ACCOUNT NAME].ALLMEMBERS,(" & Parameter!JobCompleteDateYear.value & ",[Measures].[Billed Sales Amount])) ON ROWS FROM [DW PREP ARCHIVE]"

error message

TITLE: Microsoft Visual Studio

The query cannot be retrieved from the query builder.
Check the query for syntax errors.
Reporting Services will continue to use the most recent valid query.

ADDITIONAL INFORMATION:

Query preparation failed. (Microsoft.AnalysisServices.Controls)

Query (1, 1) Parser: The syntax for '=' is incorrect. (msmgdsrv)

BUTTONS:

OK

Any suggestions ?

thanks

I found my solution. I needed to use the Strtomember function and inserted the parameter name as @.parametername

here is the final code

before

WITH MEMBER [Measures].[ParameterCaption] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,FILTER([CUSTOMER JOB].[ACCOUNT NAME].ALLMEMBERS,([Job Complete Date].[Year].&[2006],[Measures].[Billed Sales Amount])) ON ROWS FROM [DW PREP ARCHIVE]

after

WITH MEMBER [Measures].[ParameterCaption] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[CUSTOMER JOB].[ACCOUNT NAME].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,FILTER([CUSTOMER JOB].[ACCOUNT NAME].ALLMEMBERS,(Strtomember(@.JobCompleteDateYear),[Measures].[Billed Sales Amount])) ON ROWS FROM [DW PREP ARCHIVE]

capturing dynamically returned integer

Hello there.
I have a dynamic SQL query (I had to use it - I swear!) that returns a
single integer value. However, I'm having trouble capturing the value in a
local variable. Any ideas what I should do with my syntax (to get it working
I mean...)?
declare @.SQLQuery nvarchar(1024)
declare @.IntegerVar integer
select @.SQLQuery = 'select max(Column1) from table1'
--execute sp_executesql @.testSQL --this returns an integer value
--the following gives errors
select @.IntegerVar = (execute sp_executesql @.testSQL)
--the following assigns 0 to @.IntegerVar rather than the query result
execute @.IntegerVar = sp_executesql @.testSQLhttp://www.aspfaq.com/2492
"len" <len@.discussions.microsoft.com> wrote in message
news:B254F6C4-E94F-48B6-BB9C-7C03066D6998@.microsoft.com...
> Hello there.
> I have a dynamic SQL query (I had to use it - I swear!) that returns a
> single integer value. However, I'm having trouble capturing the value in a
> local variable. Any ideas what I should do with my syntax (to get it
> working
> I mean...)?
> declare @.SQLQuery nvarchar(1024)
> declare @.IntegerVar integer
> select @.SQLQuery = 'select max(Column1) from table1'
> --execute sp_executesql @.testSQL --this returns an integer value
> --the following gives errors
> select @.IntegerVar = (execute sp_executesql @.testSQL)
> --the following assigns 0 to @.IntegerVar rather than the query result
> execute @.IntegerVar = sp_executesql @.testSQL|||Try,
declare @.SQLQuery nvarchar(1024)
declare @.IntegerVar integer
select @.SQLQuery = N'select @.IntegerVar = max(Column1) from table1'
execute sp_executesql @.testSQL, N'@.IntegerVar int output', @.IntegerVar outpu
t
select @.IntegerVar
go
INF: Using Output Parameters with sp_executesql
http://support.microsoft.com/defaul...B;EN-US;q262499
AMB
"len" wrote:

> Hello there.
> I have a dynamic SQL query (I had to use it - I swear!) that returns a
> single integer value. However, I'm having trouble capturing the value in a
> local variable. Any ideas what I should do with my syntax (to get it worki
ng
> I mean...)?
> declare @.SQLQuery nvarchar(1024)
> declare @.IntegerVar integer
> select @.SQLQuery = 'select max(Column1) from table1'
> --execute sp_executesql @.testSQL --this returns an integer value
> --the following gives errors
> select @.IntegerVar = (execute sp_executesql @.testSQL)
> --the following assigns 0 to @.IntegerVar rather than the query result
> execute @.IntegerVar = sp_executesql @.testSQL|||Hi Len
Try something like:
declare @.SQLQuery nvarchar(1024)
declare @.IntegerVar integer
select @.SQLQuery = 'select @.MaxVar = max(Column1) from table1'
execute sp_executesql @.SQLQuery, N'@.MaxVar int OUTPUT', @.IntegerVar OUTPUT
SELECT @.IntegerVar
John
"len" wrote:

> Hello there.
> I have a dynamic SQL query (I had to use it - I swear!) that returns a
> single integer value. However, I'm having trouble capturing the value in a
> local variable. Any ideas what I should do with my syntax (to get it worki
ng
> I mean...)?
> declare @.SQLQuery nvarchar(1024)
> declare @.IntegerVar integer
> select @.SQLQuery = 'select max(Column1) from table1'
> --execute sp_executesql @.testSQL --this returns an integer value
> --the following gives errors
> select @.IntegerVar = (execute sp_executesql @.testSQL)
> --the following assigns 0 to @.IntegerVar rather than the query result
> execute @.IntegerVar = sp_executesql @.testSQL

Capture table & index scanning

I have a table I believe is the subject of excessive
scanning on the table & its indexes. I am having trouble
getting SQLProfiler to capture the calls to SPs that are
causing scans on the table. Anybody know how to config
SQLProfiler to do this or a better way?
Thanks,
RogerHave you set filters to search for the SP name?
TextData--> Like %whatever%
I use this combined with the databaseid filter to limit the thousands of
rows my dbs put out to Profiler
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"Roger White" <anonymous@.discussions.microsoft.com> wrote in message
news:1f72301c457be$1c6e9b30$a401280a@.phx.gbl...
> I have a table I believe is the subject of excessive
> scanning on the table & its indexes. I am having trouble
> getting SQLProfiler to capture the calls to SPs that are
> causing scans on the table. Anybody know how to config
> SQLProfiler to do this or a better way?
> Thanks,
> Roger|||Roger
http://www.sql-server-performance.com/sql_server_profiler_tips.asp
"Roger White" <anonymous@.discussions.microsoft.com> wrote in message
news:1f72301c457be$1c6e9b30$a401280a@.phx.gbl...
> I have a table I believe is the subject of excessive
> scanning on the table & its indexes. I am having trouble
> getting SQLProfiler to capture the calls to SPs that are
> causing scans on the table. Anybody know how to config
> SQLProfiler to do this or a better way?
> Thanks,
> Roger|||Thanks for the reply Kevin. I know the table & its
actually the SPs I'm trying to identify. Here's my
Profiler settings:
Events:
Scan:Started
RPC:Completed
SP:Completed
Data Columns:
IndexID (Grouped)
EventClass
StartTime
SPID
Duration
TextData
HostName
DatabaseID
ApplicationName
CPU
Reads
Filters:
DatabaseID = 8
ObjectID = 295776211 (the table thats being scanned)
I suspect the table is being scanned because SQL slows
down, CPU goes up & I run sp_lock & a few SPIDs have
taken out 2million+ locks on the table. The above
Profiler settings indicate scans, but doesn't tell me
what SPs are running when the scan occurs. Any help
appreciated.
Thanks,
Roger
>--Original Message--
>Have you set filters to search for the SP name?
>TextData--> Like %whatever%
>I use this combined with the databaseid filter to limit
the thousands of
>rows my dbs put out to Profiler
>--
>Kevin Hill
>President
>3NF Consulting
>www.3nf-inc.com/NewsGroups.htm
>www.DallasDBAs.com/forum - new DB forum for Dallas/Ft.
Worth area DBAs.
>"Roger White" <anonymous@.discussions.microsoft.com>
wrote in message
>news:1f72301c457be$1c6e9b30$a401280a@.phx.gbl...
>> I have a table I believe is the subject of excessive
>> scanning on the table & its indexes. I am having
trouble
>> getting SQLProfiler to capture the calls to SPs that
are
>> causing scans on the table. Anybody know how to config
>> SQLProfiler to do this or a better way?
>> Thanks,
>> Roger
>
>.
>|||Thanks Uri. I had already found this article. The whole
site is excellent. Please see my reply to Kevin. I
would appreciate any more help as this is really hurting
our production system.
Thanks,
Roger
>--Original Message--
>Roger
>http://www.sql-server-
performance.com/sql_server_profiler_tips.asp
>|||Roger
Can you identify where does the table involve?
Look at these stored procedure/queries.
Have you appropriate indexes for searching on the table?
"Roger White" <anonymous@.discussions.microsoft.com> wrote in message
news:1fa4c01c45836$aad376c0$a501280a@.phx.gbl...
> Thanks Uri. I had already found this article. The whole
> site is excellent. Please see my reply to Kevin. I
> would appreciate any more help as this is really hurting
> our production system.
> Thanks,
> Roger
> >--Original Message--
> >Roger
> >http://www.sql-server-
> performance.com/sql_server_profiler_tips.asp
> >|||Uri,
We have 4000 SPs. The table is probably called by
hundreds of these SPs. Through knowledge of the front-
ends, we have clustered, non-clustered & composite
indexes which we have seen improvements in some SPs, but
we are still experiencing problems. Can I assume that
SQLProfiler can't do this?
Thanks,
Roger
>--Original Message--
>Roger
>Can you identify where does the table involve?
>Look at these stored procedure/queries.
>Have you appropriate indexes for searching on the table?
>
>
>"Roger White" <anonymous@.discussions.microsoft.com>
wrote in message
>news:1fa4c01c45836$aad376c0$a501280a@.phx.gbl...
>> Thanks Uri. I had already found this article. The
whole
>> site is excellent. Please see my reply to Kevin. I
>> would appreciate any more help as this is really
hurting
>> our production system.
>> Thanks,
>> Roger
>> >--Original Message--
>> >Roger
>> >http://www.sql-server-
>> performance.com/sql_server_profiler_tips.asp
>> >
>
>.
>|||Can you set a filter on the duration to only show those that are taking over
a certain amount of time?
I have a trace template established to identify anything over 5000 (5
seconds) in my environment...
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"Roger White" <anonymous@.discussions.microsoft.com> wrote in message
news:1fddf01c45835$fc33ca20$a001280a@.phx.gbl...
> Thanks for the reply Kevin. I know the table & its
> actually the SPs I'm trying to identify. Here's my
> Profiler settings:
> Events:
> Scan:Started
> RPC:Completed
> SP:Completed
> Data Columns:
> IndexID (Grouped)
> EventClass
> StartTime
> SPID
> Duration
> TextData
> HostName
> DatabaseID
> ApplicationName
> CPU
> Reads
> Filters:
> DatabaseID = 8
> ObjectID = 295776211 (the table thats being scanned)
> I suspect the table is being scanned because SQL slows
> down, CPU goes up & I run sp_lock & a few SPIDs have
> taken out 2million+ locks on the table. The above
> Profiler settings indicate scans, but doesn't tell me
> what SPs are running when the scan occurs. Any help
> appreciated.
> Thanks,
> Roger
> >--Original Message--
> >Have you set filters to search for the SP name?
> >
> >TextData--> Like %whatever%
> >
> >I use this combined with the databaseid filter to limit
> the thousands of
> >rows my dbs put out to Profiler
> >
> >--
> >Kevin Hill
> >President
> >3NF Consulting
> >
> >www.3nf-inc.com/NewsGroups.htm
> >www.DallasDBAs.com/forum - new DB forum for Dallas/Ft.
> Worth area DBAs.
> >
> >"Roger White" <anonymous@.discussions.microsoft.com>
> wrote in message
> >news:1f72301c457be$1c6e9b30$a401280a@.phx.gbl...
> >> I have a table I believe is the subject of excessive
> >> scanning on the table & its indexes. I am having
> trouble
> >> getting SQLProfiler to capture the calls to SPs that
> are
> >> causing scans on the table. Anybody know how to config
> >> SQLProfiler to do this or a better way?
> >>
> >> Thanks,
> >> Roger
> >
> >
> >.
> >|||Roger
Well, I would go with idetifying those stored procedures (although it might
be >100) and then run SQL Server Profiler to capture a long running stored
procedures (group by duration).
"Roger White" <anonymous@.discussions.microsoft.com> wrote in message
news:1fa4401c4584c$6739b350$a101280a@.phx.gbl...
> Uri,
> We have 4000 SPs. The table is probably called by
> hundreds of these SPs. Through knowledge of the front-
> ends, we have clustered, non-clustered & composite
> indexes which we have seen improvements in some SPs, but
> we are still experiencing problems. Can I assume that
> SQLProfiler can't do this?
> Thanks,
> Roger
> >--Original Message--
> >Roger
> >Can you identify where does the table involve?
> >Look at these stored procedure/queries.
> >Have you appropriate indexes for searching on the table?
> >
> >
> >
> >
> >"Roger White" <anonymous@.discussions.microsoft.com>
> wrote in message
> >news:1fa4c01c45836$aad376c0$a501280a@.phx.gbl...
> >> Thanks Uri. I had already found this article. The
> whole
> >> site is excellent. Please see my reply to Kevin. I
> >> would appreciate any more help as this is really
> hurting
> >> our production system.
> >>
> >> Thanks,
> >>
> >> Roger
> >> >--Original Message--
> >> >Roger
> >> >http://www.sql-server-
> >> performance.com/sql_server_profiler_tips.asp
> >> >
> >
> >
> >.
> >

Cant update table

I'm having trouble updating a table in a SQL 2000 database usinb VB6.0. I have no problem opening the table and reading data from a field however when I go to update it I get the following error.

Runtimer error '-217418113 (8000ffff):
Query cannot be updated because the FROM clause is not a single simple table name.

I've tried to help myself with this one but any information which I found referred to someone trying to write to two tables simultaneously. I am simply trying to write to one.

Here's my code

Dim cnn1 As ADODB.Connection
Dim rstRailSet As ADODB.Recordset

Set cnn1 = New ADODB.Connection
cnn1.ConnectionString = "driver={SQL Server};" & _
"server=" & ServerName & ";" & _
"uid=" & UserID & ";" & _
"pwd=" & Password & ";" & _
"database=" & DBName & ";"
cnn1.Open
Set rstRailSet = New ADODB.Recordset

rstRailSet.LockType = adLockOptimistic

rstRailSet.Open "Select SLN From [Rail Set] where Rail_set_ID = '" & RailID & "'", cnn1, , , adCmdText
rstRailSet!SLN = RailSLN
rstRailSet.Update

The above message appears when the update command is executed.

Any help is greatly appreciated.maybe i am not an ADO expert but I do not see an update statement here. I see a recordset and a select statement.|||The update is done in the last line of code "rstRailSet.Update". I assume this is all that's required.|||This might be better posted in the VB forum.

gotcha. I had forgtten the rs object had an update command. I just always use either a command object or a con.execute(sql) where sql is an update sql command.

I might try this below.

rstRailSet.Open "Select SLN From [Rail Set] where Rail_set_ID = '" & RailID & "'", cnn1, , , adCmdText
rstRailSet("SLN") = RailSLN
rstRailSet.Update

But in your code snippt I do not see where RailSLN is defined or populated. Also according to some yellowing ADO 2.6 documentation on my bookshelf your datasource has to allow bookmarks and and keyset or dynamic cursors.|||Is [Rail Set] a table, or could it be a view?|||Thrasymachus

Tried your suggestion without luck. RailSLN is an argument passed to the sub containing this code. (I excluded it to keep it simple, or so I thought.)

Not sure of the bookmark/dynamic cursor implication. The source is a table within a SQL server 2000 database. I thought that the source of this issue may lie on the SQL server end hence I posted it here.

Blindmand

[Rail Set] is a table in a SQL server 2000 database.

Bare in mind here that I have no problem reading data from the source. The message seems to indicate that it some how can't work its way back. As these things can go I'm not sure whether the message is legit or whether its being triggered by an unrelated issue. (you know how this can go). It occurs when rstRailSet.Update is executed.|||SUCCESS

I set the cursor type to adOpenDynamic and I'm off to the races

rstRailSet.Open "Select SLN From [Rail Set] where Rail_set_ID = '" & RailID & "'", cnn1, adOpenDynamic, , adCmdText

At his point I do not understand enough about cursor type to know why it works but I'll bone up on it to satisfy my curiosity.

Thanks for your suggestions!

Can''t uninstall SSRS 2005 x64

Hi all,

I'm having trouble removing SSRS from a Win 2003 x64 Server. I have searched the forums here and tried different suggestions but to no avail. The problem: I go to Add/Remove Programs and choose to change SQL Server, I select the 3-4 options required to remove Reporting Services and when I get to the screen that has the sub-heading 'The selected components are being configured' nothing happens. I just get a Next button but no other feedback whatsoever and SSRS still resides on the server.

It might be worth mentioning that during the change installation wizard I get a warning that 64 bit SSRS cannot be run when ASP.NET is running in 32 bit mode. This is in fact the reason I am uninstalling SSRS, but I do not know if this has any bearing on being able to remove SSRS.

Any ideas as to what I can do to remove this?

Regards,

Stephen.

Sometimes I enjoy giving obvious answers for kicks. I have a feeling this isn't the answer to your problem, but at least you got a response.

Why are you clicking change in Add/Remove Programs? Shouldn't you be clicking the remove button? And if you are removing SSRS from the server, why not just remove SQL Server completely?

|||

Thanks for the reply ??€?§Q?. Unfortunately I cannot remove SQL Server as this is a production server and SQL Server is host to 10 live DBs. The reason I am using Add/Remove programs is SSRS is a feature of the SQL Server 2005 installation so I am using the installation wizard that is activated from Add/Remove programs to try to remove SSRS from the SQL Server installation.

Regards,

Stephen.

|||

I managed to figure it out. Apparently the ASP.NET version warning was important. I set the used the adsutil admin script to set Enable32BitAppOnWin64 to false and then I was able to uninstall it. I then set Enable32BitAppOnWin64 to true and installed the 32 bit version.

Regards,

Stephen.

Can''t uninstall SSRS 2005 x64

Hi all,

I'm having trouble removing SSRS from a Win 2003 x64 Server. I have searched the forums here and tried different suggestions but to no avail. The problem: I go to Add/Remove Programs and choose to change SQL Server, I select the 3-4 options required to remove Reporting Services and when I get to the screen that has the sub-heading 'The selected components are being configured' nothing happens. I just get a Next button but no other feedback whatsoever and SSRS still resides on the server.

It might be worth mentioning that during the change installation wizard I get a warning that 64 bit SSRS cannot be run when ASP.NET is running in 32 bit mode. This is in fact the reason I am uninstalling SSRS, but I do not know if this has any bearing on being able to remove SSRS.

Any ideas as to what I can do to remove this?

Regards,

Stephen.

Sometimes I enjoy giving obvious answers for kicks. I have a feeling this isn't the answer to your problem, but at least you got a response.

Why are you clicking change in Add/Remove Programs? Shouldn't you be clicking the remove button? And if you are removing SSRS from the server, why not just remove SQL Server completely?

|||

Thanks for the reply ??€?§Q?. Unfortunately I cannot remove SQL Server as this is a production server and SQL Server is host to 10 live DBs. The reason I am using Add/Remove programs is SSRS is a feature of the SQL Server 2005 installation so I am using the installation wizard that is activated from Add/Remove programs to try to remove SSRS from the SQL Server installation.

Regards,

Stephen.

|||

I managed to figure it out. Apparently the ASP.NET version warning was important. I set the used the adsutil admin script to set Enable32BitAppOnWin64 to false and then I was able to uninstall it. I then set Enable32BitAppOnWin64 to true and installed the 32 bit version.

Regards,

Stephen.

Can''t uninstall SSRS 2005 x64

Hi all,

I'm having trouble removing SSRS from a Win 2003 x64 Server. I have searched the forums here and tried different suggestions but to no avail. The problem: I go to Add/Remove Programs and choose to change SQL Server, I select the 3-4 options required to remove Reporting Services and when I get to the screen that has the sub-heading 'The selected components are being configured' nothing happens. I just get a Next button but no other feedback whatsoever and SSRS still resides on the server.

It might be worth mentioning that during the change installation wizard I get a warning that 64 bit SSRS cannot be run when ASP.NET is running in 32 bit mode. This is in fact the reason I am uninstalling SSRS, but I do not know if this has any bearing on being able to remove SSRS.

Any ideas as to what I can do to remove this?

Regards,

Stephen.

Sometimes I enjoy giving obvious answers for kicks. I have a feeling this isn't the answer to your problem, but at least you got a response.

Why are you clicking change in Add/Remove Programs? Shouldn't you be clicking the remove button? And if you are removing SSRS from the server, why not just remove SQL Server completely?

|||

Thanks for the reply ??€?§Q?. Unfortunately I cannot remove SQL Server as this is a production server and SQL Server is host to 10 live DBs. The reason I am using Add/Remove programs is SSRS is a feature of the SQL Server 2005 installation so I am using the installation wizard that is activated from Add/Remove programs to try to remove SSRS from the SQL Server installation.

Regards,

Stephen.

|||

I managed to figure it out. Apparently the ASP.NET version warning was important. I set the used the adsutil admin script to set Enable32BitAppOnWin64 to false and then I was able to uninstall it. I then set Enable32BitAppOnWin64 to true and installed the 32 bit version.

Regards,

Stephen.

Can''t uninstall SSRS 2005 x64

Hi all,

I'm having trouble removing SSRS from a Win 2003 x64 Server. I have searched the forums here and tried different suggestions but to no avail. The problem: I go to Add/Remove Programs and choose to change SQL Server, I select the 3-4 options required to remove Reporting Services and when I get to the screen that has the sub-heading 'The selected components are being configured' nothing happens. I just get a Next button but no other feedback whatsoever and SSRS still resides on the server.

It might be worth mentioning that during the change installation wizard I get a warning that 64 bit SSRS cannot be run when ASP.NET is running in 32 bit mode. This is in fact the reason I am uninstalling SSRS, but I do not know if this has any bearing on being able to remove SSRS.

Any ideas as to what I can do to remove this?

Regards,

Stephen.

Sometimes I enjoy giving obvious answers for kicks. I have a feeling this isn't the answer to your problem, but at least you got a response.

Why are you clicking change in Add/Remove Programs? Shouldn't you be clicking the remove button? And if you are removing SSRS from the server, why not just remove SQL Server completely?

|||

Thanks for the reply ??€?§Q?. Unfortunately I cannot remove SQL Server as this is a production server and SQL Server is host to 10 live DBs. The reason I am using Add/Remove programs is SSRS is a feature of the SQL Server 2005 installation so I am using the installation wizard that is activated from Add/Remove programs to try to remove SSRS from the SQL Server installation.

Regards,

Stephen.

|||

I managed to figure it out. Apparently the ASP.NET version warning was important. I set the used the adsutil admin script to set Enable32BitAppOnWin64 to false and then I was able to uninstall it. I then set Enable32BitAppOnWin64 to true and installed the 32 bit version.

Regards,

Stephen.