manually removing encryption keys

Hi,
I am trying to recover a reporting services installation to a different
server with a different name. At the moment I am battling a "this
edition of reporting services does not support web farms". I think now
I have remove all the encryption keys and then install just one key,
with the associated installation ID in the config file.
Anyway, I can't remove the encryption keys, I keep getting unexpected
database error (-2147159548) ox80040e21 when I run rskeymgmt -r
<installation id>
Can remove the keys manually?
ChandraWas wondering if you had found a fix for this problem? I've had the same
problem, and have found no solution.
Thanks
Marvin
"chandra@.cbmi.org.au" wrote:
> Hi,
> I am trying to recover a reporting services installation to a different
> server with a different name. At the moment I am battling a "this
> edition of reporting services does not support web farms". I think now
> I have remove all the encryption keys and then install just one key,
> with the associated installation ID in the config file.
> Anyway, I can't remove the encryption keys, I keep getting unexpected
> database error (-2147159548) ox80040e21 when I run rskeymgmt -r
> <installation id>
>
> Can remove the keys manually?
>
> Chandra
>|||Sorry, still don't have an answer :-)
very frustrating
Chandra
Marvin wrote:
> Was wondering if you had found a fix for this problem? I've had the same
> problem, and have found no solution.
> Thanks
> Marvin
> "chandra@.cbmi.org.au" wrote:
> > Hi,
> >
> > I am trying to recover a reporting services installation to a different
> > server with a different name. At the moment I am battling a "this
> > edition of reporting services does not support web farms". I think now
> > I have remove all the encryption keys and then install just one key,
> > with the associated installation ID in the config file.
> >
> > Anyway, I can't remove the encryption keys, I keep getting unexpected
> > database error (-2147159548) ox80040e21 when I run rskeymgmt -r
> > <installation id>
> >
> >
> > Can remove the keys manually?
> >
> >
> > Chandra
> >
> >

Manual Log shipping

Interested in creating a manual standby database.Will like to
implement this with Sql Server standard Edition available
Any ideas or recommendations

Thanks
TYHi

There was a couple of articles on this in SQL Server Professional Magazine
http://tinyurl.com/4ez3l
http://tinyurl.com/6rdth

You may also want to check out the simple log shipping solution in the
resource kit.

John

"Tyler Smith Watu" <watuni2000@.yahoo.co.nz> wrote in message
news:2f3438a4.0410010907.249cc962@.posting.google.c om...
> Interested in creating a manual standby database.Will like to
> implement this with Sql Server standard Edition available
> Any ideas or recommendations
>
> Thanks
> TY

Managing SQL Server Agent

Hi,
I would like to know what are the possibilities to mange the Sql server Agent in the Sql Server 2005 express edition whit the Sql server mangement studio express, because I can't see it .
thanks

Hi,

you can′t manage it, because it isn′t there:

Look at: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

Managing Remote SQL Server from Server Express

Hi,

Does anyone know if it's possible to manage SQL Server Standard Edition 2005 remotely using SQL Server 2005 Express?

Cheers.As you have posted a question in the article section it is being moved to SQL Server forum.

MODERATOR.

Management Tools in SQL SERVER 2005

Hi Team,

Is there any management tools in SQL SERVER 2005? I just installed my standard edition and also developer version in different computer, but seems that both versions doesn't support management tools such as query analyzer.

Can anyone explain to me...

Thanks.

Copy both to your harddrive and rerun setup and choose the repair option and when you get to select components choose Management tools the new Enterprise Manager is called Management Studio and install it in both. Then right click at the top of Management Studio to register the Standard Edition with the Developer Edition because it is the Enterprise Edition with no deployment restriction. Hope this helps.

|||

Thanks Caddre,

I found it.

Management Studio vs. Management Studio Express Edition

I am back doing development after a three year hiatus. Previously I was working with SQL Server 2000 and Enterprise Manager and I need to get up to speed quickly on version 2005.

The computer I am using already has Management Studio Express installed but we have full licensed copies of version 2005 enterprise edition available. I have two questions:

Are there features available in the full version of Management Studio that would compel me to switch from the Express Edition?

If so, how in the heck do I make the switch. Is it as easy as uninstalling the Express Edition and then installing the full version from the 2005 enterprise edition CD?

I already tried installing from the enterprise CD and got the error message cited in other threads about being blocked so I want to make sure I do this right.

Thanks very much for your help and I apologize for the newbie question...

Yes, there is functionality available in the full version of SSMS that is not available with the Express version.

And removing SSMSE and installing SSMS 'should' work just fine.

|||Thanks for the reply. It required a couple of tries to get rid of Management Studio Express edition because of the dependent applications it installs, but it looks like I got it out finally and was able to do the installations of the full version Management Studio from the Enterprise Edition CD. Thanks for your help!