Can't back up Encryption Key

I am trying to backup Encryption Key for my reporting service. Configuration tool, prompts for a encryption key file location and a strong password. When I provide the same and click OK, I get the following error:

ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070A91

> System.Runtime.InteropServices.COMException (0x80070A91): Password doesn't meet the requirements of the filter dll's (Exception from HRESULT: 0x80070A91)
End of inner exception stack trace
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[]& encryptedBytes, String password)

I have tried with passwords with different combination but none of them seem to help. Any ideas?

It looks like your system has a password complexity filter installed. If you search on the error message, you will see a number of articles explaining how you can build and install one; I would check to see if that's the case first.

In the absence of a password filter, the RS WMI provider will use the local Windows password policy rules on Windows 2003

-Tudor

|||

Hi quantum_csfb

Have you had any luck resolving this?

I am getting the same error.

I am running XP Pro SP2.

Thanks.

|||

Gr8 :-)

Of course this was the thing.
Using a password that complied with the windows police in complexity worked fine

Many Thx

|||

Hi

I am also having the same problem of encryption key backup with same error message. I checked the Windows password policy and am adhering to that but still the same problem persists.

Any other suggestions?

Can't back up Encryption Key

I am trying to backup Encryption Key for my reporting service. Configuration tool, prompts for a encryption key file location and a strong password. When I provide the same and click OK, I get the following error:

ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070A91

> System.Runtime.InteropServices.COMException (0x80070A91): Password doesn't meet the requirements of the filter dll's (Exception from HRESULT: 0x80070A91)
End of inner exception stack trace
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[]& encryptedBytes, String password)

I have tried with passwords with different combination but none of them seem to help. Any ideas?

It looks like your system has a password complexity filter installed. If you search on the error message, you will see a number of articles explaining how you can build and install one; I would check to see if that's the case first.

In the absence of a password filter, the RS WMI provider will use the local Windows password policy rules on Windows 2003

-Tudor

|||

Hi quantum_csfb

Have you had any luck resolving this?

I am getting the same error.

I am running XP Pro SP2.

Thanks.

|||

Gr8 :-)

Of course this was the thing.
Using a password that complied with the windows police in complexity worked fine

Many Thx

|||

Hi

I am also having the same problem of encryption key backup with same error message. I checked the Windows password policy and am adhering to that but still the same problem persists.

Any other suggestions?

Can't back up Encryption Key

I am trying to backup Encryption Key for my reporting service. Configuration tool, prompts for a encryption key file location and a strong password. When I provide the same and click OK, I get the following error:

ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070A91

> System.Runtime.InteropServices.COMException (0x80070A91): Password doesn't meet the requirements of the filter dll's (Exception from HRESULT: 0x80070A91)
End of inner exception stack trace
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[]& encryptedBytes, String password)

I have tried with passwords with different combination but none of them seem to help. Any ideas?

It looks like your system has a password complexity filter installed. If you search on the error message, you will see a number of articles explaining how you can build and install one; I would check to see if that's the case first.

In the absence of a password filter, the RS WMI provider will use the local Windows password policy rules on Windows 2003

-Tudor

|||

Hi quantum_csfb

Have you had any luck resolving this?

I am getting the same error.

I am running XP Pro SP2.

Thanks.

|||

Gr8 :-)

Of course this was the thing.
Using a password that complied with the windows police in complexity worked fine

Many Thx

|||

Hi

I am also having the same problem of encryption key backup with same error message. I checked the Windows password policy and am adhering to that but still the same problem persists.

Any other suggestions?

can't access server - lost sa password

We have what we think is msde running on a box. No one knows the sa password.
I am in the domain admin group on Windows and the Windows admin group but
when I right click on BUILTIN\administrator, I don't get the "properties"
menu selection. I also can't create a new login.
A few weeks ago I was able to create a new login and a new database. I'm not
sure what happened. My windows login is not there anymore but I would have
thought I could use the BUILTIN\administrator login to admin the server.
Any ideas on how I can get control of the server?
Thanks,
Dan D.
Although I hate tools like these but try this tool if it works for you ...
http://www.nextgenss.com/sqlcrack.htm
Harman Sahni
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:E449D233-29E8-4ED0-AC95-2B4BF0FDC6D3@.microsoft.com...
> We have what we think is msde running on a box. No one knows the sa
password.
> I am in the domain admin group on Windows and the Windows admin group but
> when I right click on BUILTIN\administrator, I don't get the "properties"
> menu selection. I also can't create a new login.
> A few weeks ago I was able to create a new login and a new database. I'm
not
> sure what happened. My windows login is not there anymore but I would have
> thought I could use the BUILTIN\administrator login to admin the server.
> Any ideas on how I can get control of the server?
> Thanks,
> --
> Dan D.
|||Thanks but I figured out the sa password. I'll keep this for future reference.
"Harman Sahni" wrote:

> Although I hate tools like these but try this tool if it works for you ...
> http://www.nextgenss.com/sqlcrack.htm
> Harman Sahni
>
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:E449D233-29E8-4ED0-AC95-2B4BF0FDC6D3@.microsoft.com...
> password.
> not
>
>
|||Dan
Log in SQL Server with Windows Authentication and run EXEC sp_password NULL,
'NewPass', 'MyUser
'
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:2264F204-A7B6-422A-95AC-0517B560C27C@.microsoft.com...
> Thanks but I figured out the sa password. I'll keep this for future
reference.[vbcol=seagreen]
> "Harman Sahni" wrote:
...[vbcol=seagreen]
but[vbcol=seagreen]
"properties"[vbcol=seagreen]
I'm[vbcol=seagreen]
have[vbcol=seagreen]
server.[vbcol=seagreen]

Cannot run SQLServerAgent jobs after changing SA password

I am new to SQL Server 2000. When I set a password for SA all the SQLServerAgent jobs fail with a login error and will not start. I have tried to change the SQLAgent service login via the Control Panel/Services, but it will not accept SA as a valid login, when I browse logins, only the NT logins seem to appear. The jobs are owned by my normal login and not by SA.

This is probably a simple change, but I am going round in circles trying to locate the 'how to' documentation.SQLServerAgent service needs to run under a Windows account...|||Check your SQL Server connection settings in SQL Server Agent properties (Windows Auth. or SQL server Auth.).|||Thanks. I did not see the SQL agent connection properties with a login and password. All is now well.

Cannot Run SP3

I cannot install SQL 2000 SP3, when I run setup it cannot verify the windows
account logged on and then I try to use the sa password and it cannot verify
that password. I am using the correct password, there are no errors in the
event viewer and the DB is running and accessible. I am running this on
Windows 2000 SP4. Any ideas?
Thanks,
DerekYes i had a client with this problem before , check this article out:
http://support.microsoft.com/?kbid=814844
HTH
Dylan kruger
"Derek" <derekb@.nospamderekb.com> wrote in message
news:u51JTwTjDHA.3204@.tk2msftngp13.phx.gbl...
> I cannot install SQL 2000 SP3, when I run setup it cannot verify the
windows
> account logged on and then I try to use the sa password and it cannot
verify
> that password. I am using the correct password, there are no errors in the
> event viewer and the DB is running and accessible. I am running this on
> Windows 2000 SP4. Any ideas?
> Thanks,
> Derek
>

cannot repair database.

I startup sqlserver2005 in single user mode (sqlservr.exe -m under dos
mode).
open a new dos prompt to enter sqlcmd -Usa, and give password of sa to enter
sqlcmd.
type the following clause,
DBCC CHECKDB ('CK', REPAIR_ALLOW_DATA_LOSS);
go
I got 'repair statement not processed, database need to be in single user
mode' error messsage.
WHY? which one step I lost?
--FrankFrank Lee wrote:
> I startup sqlserver2005 in single user mode (sqlservr.exe -m under dos
> mode).
> open a new dos prompt to enter sqlcmd -Usa, and give password of sa to enter
> sqlcmd.
> type the following clause,
> DBCC CHECKDB ('CK', REPAIR_ALLOW_DATA_LOSS);
> go
> I got 'repair statement not processed, database need to be in single user
> mode' error messsage.
> WHY? which one step I lost?
> --Frank
>
You don't need to start up SQL Server with the -m switch.
Go into Management Studio, right click on the CK database, click on
properties.
In the resulting dialog select the "Options" page. In the right pane,
scroll down to "State" and change "Restrict Access" to a value of "Single".
This will put the DATABASE into single user mode.
Alternatively, you could use ALTER DATABASE:
ALTER DATABASE CK
SET SINGLE_USER;
GO
and
ALTER DATABASE CK
SET MULTI_USER;
GO
to change it back.
Rob|||ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/92d4714b-95bf-46af-b05e-759a7164f937.htm
--
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Frank Lee" <Reply@.to.newsgroup> wrote in message
news:uzHfXT1DGHA.3988@.TK2MSFTNGP12.phx.gbl...
>I startup sqlserver2005 in single user mode (sqlservr.exe -m under dos
>mode).
> open a new dos prompt to enter sqlcmd -Usa, and give password of sa to
> enter sqlcmd.
> type the following clause,
> DBCC CHECKDB ('CK', REPAIR_ALLOW_DATA_LOSS);
> go
> I got 'repair statement not processed, database need to be in single user
> mode' error messsage.
> WHY? which one step I lost?
> --Frank
>|||>
> You don't need to start up SQL Server with the -m switch.
> Go into Management Studio, right click on the CK database, click on
> properties.
> In the resulting dialog select the "Options" page. In the right pane,
> scroll down to "State" and change "Restrict Access" to a value of
> "Single".
> This will put the DATABASE into single user mode.
> Alternatively, you could use ALTER DATABASE:
> ALTER DATABASE CK
> SET SINGLE_USER;
> GO
> and
> ALTER DATABASE CK
> SET MULTI_USER;
> GO
> to change it back.
>
> Rob
Thanks. It works for me.