Conflict Resolution options disabled

I am using SQL Server 2000 and Enterprise Manager. I have a publication and
I am trying to follow some instructions for configuring conflict resolution.
I open the Publication properties, go to the Articles tab, open an Article by
clicking the ellipses, and then go to the Resolver tab. All of the controls
on the Resolver tab are disabled. Is there something else I must do first to
enable conflict resolution on at the Database or Publication level?
Some settings are database specific. Most likely what has happened is the
article you are trying to change the resolver type to is published in a
different publication. To make this work you will have to drop it from
existing publication, change the resolver type and then put it back in.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Michael" <Michael@.discussions.microsoft.com> wrote in message
news:454325A9-2D83-4664-9ECB-9143C5257BDF@.microsoft.com...
>I am using SQL Server 2000 and Enterprise Manager. I have a publication
>and
> I am trying to follow some instructions for configuring conflict
> resolution.
> I open the Publication properties, go to the Articles tab, open an Article
> by
> clicking the ellipses, and then go to the Resolver tab. All of the
> controls
> on the Resolver tab are disabled. Is there something else I must do first
> to
> enable conflict resolution on at the Database or Publication level?

CONFIGURE REPORT SERVER - Initialization button disabled / Key not valid for use in specified st

Hi There,

I am trying to setup a RS with Configure Report Server tool. (Windows 2003 Server / SQL 2005)

* All the items are with green check points except Encryption Keys (Blue exclamation point) and initialization wich is disabled. * Event log shows a lots of errors: Report Server Windows Service (SQL2K5) cannot connect to the report server database. * Browsing the Web Reports Server is returning the errror: Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B)

Can someone give me a ideea where to dig next?

Regards,

Toronto,

Canada

Which edition of RS are you using? The initialization button could be disabled because your edition doesn't support scale-out deployment. Does the disabled button show a check mark or a cross?

When you browse http://<server>/reportserver, are there any errors in the log file? Also review what's on the database setup panel. Perhaps try to reapply the settings on the panel. (The cannot connect to report server database error is suspicious considering the database setup panel shows green check mark.)

|||

EDITION:

Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Initialization button show a cross.

(The cannot connect to report server database error is suspicious considering the database setup panel shows green check mark.) - I totaly agree with you here - this is a paradox.

The database button is green with the check sign and the log is full of:

Report Server Windows Service (SQL2K5) cannot connect to the report server database.

Encryption Keys is blue with exclamation sign. Buttons backup and change disabled, delete and restore available.

Is there any way to post some screenshots of these?

Regards,

Toronto

|||

Scale-out is only supported for Developer, Enterprise and Evaluation edition, so you'd expect the Initialization to be disabled. (However, it should not be a cross.)

The database button is green means that the connection information is set in rsreportserver.config file. It is possible that the connection information is incorrect. Although, if you used the config tool to configure this panel, you should end up with a good connection information. Perhaps you can review http://msdn2.microsoft.com/en-us/ms159133.aspx. After reapplying the settings, check if your RS catalog databases is granted the correct permissions. Perhaps you can also check from the SQL profiler if your database is getting hit, and if the logons are denied.

|||

RS service is running under the same Windows account wich is designated for SQL server service. This account is part of Administrators group on OS and on SQL instance.

Does RS service require a distinct account?

I have loged in the server with the Windows account above mentioned.

I have accesse the RS database and the RSTemp database with no problem.

What else is missing?