SQLServer Error: 22046, Encryption Error Using CryptProtectData
May 3, 2007
I created a ransactional publication.
Starting the LogReader Agent produce the error
'Unable to start execution of step 2 (reason: Error authenticating proxy NETRTLSRVSvcSQLLogReader, system error: Logon failure: unknown user name or bad password.). The step failed.'
This is the result of the SQL Agent Error
[298] SQLServer Error: 22046, Encryption error using CryptProtectData. [SQLSTATE 42000]
We are running SQL Server 2005 - 9.00.3042.00 (Intel X86) in a cluster environment.
If I change the Step 2 of the Agent Job (Type=Replication Transactional-Log Reader) to "Run AS" SQL Agent Service Account , everthing works fine.
There seems to be a problem with the access to the generated proxy/credential
Why it doesn't work with the special SvcSQLLogReader domain Login ?
Hello and thank you all in advance for any assistance provided. I have a two node SQL 2005 cluster running (1 node is failover). I have a job that I am trying to run using a proxy account. The credential account that is used within the proxy is a domain account and I have ensured that the passwords are all correct. The problem I am experiencing is that whenever I try to run a job, it fails with the following message:
Unable to start execution of step 1 (reason: Error authenticating proxy ROCHARR ("just an example"), system error: Logon failure: unknown user name or bad password.). The step failed.
This is also displayed in my SQLAGENT.OUT log file:
SQLServer Error: 22046, Encryption error using CryptProtectData. [SQLSTATE 42000]
In the event viewer, I also recieve failure audits when I run the job that look like this:
Logon Failure:
Reason: Unknown user name or bad password
User Name: ARR
Domain: ROC
Logon Type: 8
Logon Process: Advapi
Authentication Package: Negotiate
Workstation Name: HOSTA
Caller User Name: ITUSER
Caller Domain: ROCH
Caller Logon ID: (0x0,0x22EF57C8)
Caller Process ID: 5780
Transited Services: -
Source Network Address: -
Source Port: -
Now I have made sure that the "ITUSER" is trusted for delegation since that is the account that is running the SQL Server Agent Service. I have all the proxy settings configured correct in the job itself, so it shouldn't be that. Any assistance is greatly appreciated as I am going crazy with this.
When trying to create a publication or subsubscription running under a Windows Domain account the following error message appears:
Replication-Replication Distribution Subsystem: agent ECHOECHO-InsDB-INS_CMS_PUB-HARPO-58 failed. Unable to start execution of step 2 (reason: Error authenticating proxy DETINIsrvRep_user, system error: Logon failure: unknown user name or bad password.). The step failed.
Further in the SQL logs we find that the above message is due to:
[298] SQLServer Error: 22046, Encryption error using CryptProtectData. [SQLSTATE 42000]
It appears that when Credentials for the agent proxy are being created that this message occurs. So when the SP that tries to run the agent (snapshot or distrobution) is called it always returns incorrect password details.
The Credentials do appear to be created, they are visible via SQL Studio, but you can't see the password. Changing the password via SQL Studio does not work as the Credentials are recreated every time.
I have checked the following:
MSDTC is running correctly The Domain Account has the correct privileges to run these services Regenerated the Service Master Key Created Master Keys in each database effected by replication Ensure SQL Service accounts have access to decrypt the Service Master Key I can create a Publication and Subscription using the local system account on the cluster
I've received this error twice over 2 days in the SQL Agent error log during off-hours from a server which has not had any changes to it in the last few months (once at 3:32AM and the next day at 3:46AM. I've been able to tie it to log-shipping backup jobs (all of which run under the SQL Service domain account) which run every minute. It seems to be only momentary, as the next attempt a minute later is successful.
I get the same set of messages for each database for the same time which look like this:
Date 07.03.2008 3:31:51 AM Log SQL Agent (Current - 10.03.2008 6:15:00 PM)
Date 07.03.2008 3:31:52 AM Log SQL Agent (Current - 10.03.2008 6:15:00 PM)
Message [298] SQLServer Error: 258, Unable to complete login process due to delay in login response [SQLSTATE 08001]
Date 07.03.2008 3:31:52 AM Log SQL Agent (Current - 10.03.2008 6:15:00 PM)
Message [382] Logon to server '(local)' failed (SubSystemStepHistoryLogger)
I can't find any documentation on these errors on the web or MSDN site. Can I chalk this up to possibly "winking" connection to our domain controller? We've never had these messages before, and our LAN department swears that there have been no upgrades to the network or domain controller servers recently.
I have created a DTS package on my SQL 7.0 SP3 server which simply reads a table on another SQL 7.0 server and populates a local table with the information that has been read.
Whenever I try to execute the DTS package (via Run or scheduling it) I get the following error:
------------------------------------------------------------------------- ... DTSRun: Executing... DTSRun OnStart: Delete from Table [AfterSalesAccessories].[dbo].[model_derivative] Step DTSRun OnError: Delete from Table [AfterSalesAccessories].[dbo].[model_derivative] Step, Error = -2147217887 (80040E21) Error string: The property 'Use Encryption for Data' is not supported. Error source: Microsoft Data Transformation Services (DTS) Package -------------------------------------------------------------------------
I have not selected the encryption option and can't see what I'm doing wrong. Has anybone else seen this ? I've looked on Technet but no joy.
I have a commercial application built for Pocket PC's that connects to SQL Server 2005 via TCP/IP over wireless networks. In installations for our sales people we installed SQL 2005 Express on their notebooks for demonstrations. In one of these installs we are getting the following error message: "An error occurred - SQL Server requires Encryption On". We do not use encrypted connections and I have verified encryption is turned off in the Options tab in SQL 2005 login screens.
Here is the connection string we use in the app.config file on the Pocket PC's: <add key="connStr" value="Data Source=192.168.0.19,1433;Initial Catalog=SQL0018;User ID = User01;Password=PW01"/>
Other apps on the notebook are connecting to this same SQL Server without any issues. Thank you in advance for any help here,
I have a commercial application built for Pocket PC's that connects to SQL Server 2005 via TCP/IP over wireless networks. In installations for our sales people we installed SQL 2005 Express on their notebooks for demonstrations. In one of these installs we are getting the following error message: "An error occurred - SQL Server requires Encryption On". We do not use encrypted connections and I have verified encryption is turned off in the Options tab in SQL 2005 login screens.
Here is the connection string we use in the app.config file on the Pocket PC's: <add key="connStr" value="Data Source=192.168.0.19,1433;Initial Catalog=SQL0018;User ID = User01;Password=PW01"/>
Other apps on the notebook are connecting to this same SQL Server without any issues. Thank you in advance for any help here,
I have a commercial application built for Pocket PC's that connects to SQL Server 2005 via TCP/IP over wireless networks. In installations for our sales people we installed SQL 2005 Express on their notebooks for demonstrations. In one of these installs we are getting the following error message: "An error occurred - SQL Server requires Encryption On". We do not use encrypted connections and I have verified encryption is turned off in the Options tab in SQL 2005 login screens.
Here is the connection string we use in the app.config file on the Pocket PC's: <add key="connStr" value="Data Source=192.168.0.19,1433;Initial Catalog=SQL0018;User ID = User01;Password=PW01"/>
Other apps on the notebook are connecting to this same SQL Server without any issues. Thank you in advance for any help here,
SQL Server could not connet to the database service for server configuration. The error was: [Microsoft][SQL Native Client] Encryption not suppprted on the client. Refer to sever logs and setup logs for more information. For details on how to view setup logs, see :how to View Setup Log Files" in SQL Server Books Online.
I have SQL 2005, and Reporting Service has been uninstalled and reinstalled, go through each step of confiugration until Encryption Key, for some reason, the backup button is grayed out, only "restore" button is clickable, as well as Delete, but we never backup the key before, so this is really strange since we do not have backupkey, so we cannot restore.
we tried "Delete", then we got the following error:
ReportServicesConfigUI.WMIProvider.WMIProviderException: The encrypted value for the "LogonCred" configuration setting cannot be decrypted. (rsFailedToDecryptConfigInformation) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()
Browse report manager and reportserver also got the same error, run rskeymgmt -d, does not help either
I have tried reinstalling the sqlncl.msi - re-booting etc without success.
I'm on windows vista beta 2 build 5384.
Brand spanking new machine (less that 48 hrs old) and I can't beleive my bad luck with sql express. My xp pro machine works fine.
Hers's the error:
TITLE: Microsoft SQL Server 2005 Setup ------------------------------
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=29515&EvtType=lib%5codbc_connection.cpp%40Do_sqlScript%40OdbcConnection%3a%3aconnect%40connect%40x15
------------------------------ BUTTONS:
&Retry Cancel ------------------------------
Here's the log:
Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Professional (Build 5384) Time : Sat Jul 01 08:01:37 2006
Machine : JOHN-PC Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.2047.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : JOHN-PC Product : Microsoft SQL Server Native Client Product Version : 9.00.2047.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : JOHN-PC Product : Microsoft SQL Server VSS Writer Product Version : 9.00.2047.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : JOHN-PC Product : SQL Server Database Services Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. -------------------------------------------------------------------------------- Machine : JOHN-PC Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.1.2047.00 Install : Failed Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_SQL.log Last Action : InstallFinalize Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. Error Number : 29515 --------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
SQLSetup0001_JOHN-PC_SQLNCLI_1.log snippet (right at the end) says:
<snipped>
MSI (s) (AC:64) [20:59:38:014]: Product: Microsoft SQL Server Native Client -- Configuration failed.
MSI (s) (AC:64) [20:59:38:014]: Product: Microsoft SQL Server Native Client. Version: 9.00.2047.00. Language: 1033. Configuration change completed with status: 1603.
</snipped>
and at the end of SQLSetup0001_JOHN-PC_Core(Local).log
<snipped>
Running: ReportChainingResults at: 2006/5/30 20:59:42 Error: Action "ReportChainingResults" threw an exception during execution. One or more packages failed to install. Refer to logs for error details. : 1706 Error Code: 0x800706aa (1706) Windows Error Text: The endpoint format is invalid.
Source File Name: sqlchainingsqlchainingactions.cpp Compiler Timestamp: Mon Jan 16 02:06:13 2006 Function Name: sqls::ReportChainingResults::perform Source Line Number: 3245
Can anyone advise. I'm willing to take a "you'll have to re-build your machine" response if I have to. But I just need to know if this really is required.
A customer of my program is getting the SQL CE error message "The operating system does not support encryption".
I've seen several threads on this issue, but none of them seem to apply to my problem. This is a Windows Forms application, so no device and no web service.
The OS is a German Windows XP - so there shouldn't be any issues regarding strong encryption. It even runs in Windows 2000 in our test VPC.
Hi, i need to know how to encrypt a field in the sql server database. I want to hide some text field in a user defined table. thanks in advance. regards mihir
I've SQL Server Reporting Services 2005 configured on my system, but now I'm NOT Able to start the report server. I get this error on http://<serverurl>/Reports/Home.aspx:
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) Get Online Help
The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B)
I don't want to loose any data. Please help me resolving this error.
FYI, I've modified the SQL Reporting Services account LogOnAs info, in Properties of "SQL Server Reporting Services (MSSQLSERVER)" Service, in Windows Service Managment.
Earlier I had .useraccount as username, I modified it to domainnameuseraccount. And then suddenlt everything broke for reporting server.
I currently have SQL2005 Std, using 2 separate domain accounts for both SQL server and SQL agent. When accessing the MSDB stored packages folder from mgmt studio, I get the following error:
Client unable to establish connection. Encryption not supported on SQL server.
I did google for this error, but have tried all suggestions, including updating the MsDtsSvr.ini.xml file with the servername. I am using a default instance.
Also, I am only able to access the MSDB folder if I set the SQL service account to the local admin account. I have also set the SQL service account to be part of the local admins group, but without any luck.
Hi everybody I am using bcp to insert data from csv file to sql server . The problem that i am facing is that, The heading in the csv file is populating in the tables also the datas are not inserting. I dosent want the first row in the csv which holds the heading to insert in the table Does anybody know to solve this problem I am using this code
CREATE procedure usp_ImportMultipleFilesBCP @servername varchar(128), @DatabaseName varchar(128), @filepath varchar(500), @pattern varchar(100), @TableName varchar(128) as declare @query varchar(1000) declare @max1 int declare @count1 int Declare @filename varchar(100) set @count1 =0 create table #x (name varchar(200)) set @query ='master.dbo.xp_cmdshell "dir '+@filepath+@pattern +' /b"' insert #x exec (@query) delete from #x where name is NULL select identity(int,1,1) as ID, name into #y from #x drop table #x set @max1 = (select max(ID) from #y) --print @max1 --print @count1 --select * from #y While @count1 <= @max1 begin set @count1=@count1+1 set @filename = (select name from #y where [id] = @count1) set @Query ='bcp "'+ @databasename+'.dbo.'+@Tablename + '" in "'+ @Filepath+@Filename+'" -S' + @servername + ' -T -c -r -t,' set @Query = 'MASTER.DBO.xp_cmdshell '+ "'"+ @query +"'" --print @query EXEC ( @query) --insert into logtable (query) select @query end
Hi, I want to transfer database objects from One Database to other including all keys that exists between tables using SqlServer SMO .I had tried with MSDN Code but i am facing with some error i.e.,
ERROR : errorCode=-1073548784 description=Executing the query "DROP USER [UserName] " failed with the following error: "Cannot drop the user 'UserName', because it does not exist or you do not have permission.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
I tried with MSDN Code:
'Reference the AdventureWorks database Dim db As Database db = srv.Databases("AdventureWorks") 'Create a new database that is to be destination database. Dim dbCopy As Database dbCopy = New Database(srv, "AdventureWorksCopy") dbCopy.Create() 'Define a Transfer object and set the required options and properties. Dim xfr As Transfer xfr = New Transfer(db) xfr.CopyAllTables = True xfr.Options.WithDependencies = True xfr.Options.ContinueScriptingOnError = True xfr.DestinationDatabase = "AdventureWorksCopy" xfr.DestinationServer = srv.Name xfr.DestinationLoginSecure = True xfr.CopySchema = True 'Script the transfer. Alternatively perform immediate data transfer with TransferData method. xfr.ScriptTransfer() or xfr.TransferData()
Hi Iam Fed up with sqlconnection open error. Can Any one help me in isolating the problem. I am creating a asp.net application . I want to pull the data from sql server and display in a grid. The sql server is running in a different machine.(connected thru lan) The IIS and application is running in one machine For the sqlconnectionstring i have given it as like this server=POO01;uid=sa;pwd=newsql;database=CPI_CIVIL_TRANS; I Get an error as "sql server does not exists or access denined" I search google for this problem , but could not find a solution. Iam struck up with the work because of the problem. Thanks In Advance For help. Jai Ganesh.J
Here's a really wierd one for you all. I have two "virtual" SQL Servers running on a Clustered NT Server. I can connect to one server using its IP address by configuring my client to talk using TCP/IP. However, when I try to connect to the second server using its IP address after configuring my client library accordingly. I get an error message like this:-
Unable to connect to server IP address Server: Msg 11, Level 16, State 1 [Microst][ODBC SQL Server Driver][TCP/IP Sockets] General network error. check your network documentation.
Next, I tried to create an ODBC source and here's the message from the ODBC Administrator.....
Connection failed: SQLState:'01000' SQL Server Error: 10060 [Microst][ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen [connect()] Connection failed: SQLState: '08001' SQL Server Error: 11 [Microst][ODBC SQL Server Driver][TCP/IP Sockets] General network error. check your network documentation.
hi....... i create a trigger after delete which work perfactly fine on one sqlserver2005 machine but not at another.......machine having sqlserver2005 this trigger effect 15 tables from which i am deleting data...when trigger fires..... now it cause following error when i fire ir on another machine error source: .net sql client data provider error message:maximun stored procedure,triggers,functions,or view nesting level exceeded (limit 32) plzzzz give da solution.....its really frustrating me.... thanks in advance
I am running sqlserver 6.5 and I trying to copy over one db into another, it goes thru the scripting and then it gives me the error message Error 10004 [DB-Library] unable to connect. How can I resolve this?
Quite often a scheduled program run causes the following error and program fails. If I run it a couple of times then it goes away for some days but re-appears again sporadically. Any thoughts what to look for and how to fix this? Help is appreciated.
I have tried accessing a remote database in one of by stored procs using linked servers and also using OpenDataSource method. In both the cases , I am getting login failed error.
Following is the stored proc :
CREATE PROCEDURE TEST AS
SELECT * FROM OPENDATASOURCE( 'SQLOLEDB', 'Data Source=blrkec3432s;User ID=xyz;Password=xyz').LMC.dbo.STATE GO
I get the following error message when I install sqlserver 2005.
TITLE: Microsoft SQL Server 2005 Setup ------------------------------
The installer has encountered an unexpected error. The error code is 2380. Error opening file for write: 5. GetLastError: SOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1Setup.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=2380&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroup%40Do_sqlGroup%40x5
------------------------------ BUTTONS:
&Retry Cancel ------------------------------ Anybody got an idea?
Dear i am using visual studio.net.......... when i connect database (in sqlserver) using sqldataAdapter with datagrid in visual basic.net every thing work properly........... but when i use the same in asp.net then i get an error message on the resultant explorer page give below.
Server Error in '/studentData' Application. --------------------------------------------------------------------------------
Login failed for user 'RAMIZSARDARASPNET'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'RAMIZSARDARASPNET'.
Source Error:
Line 85: 'Put user code to initialize the page here Line 86: Dim ds As New DataSet() Line 87: SqlDataAdapter1.Fill(ds) Line 88: DataGrid1.DataSource = ds.Tables(0) Line 89: DataGrid1.DataBind()
-------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.0.3705.0; ASP.NET Version:1.0.3705.0
Plz solve my problem and Reply me on ramiz_ch@hotmail.com Plz solve my problem and Reply me on ramiz_ch@hotmail.com Plz solve my problem and Reply me on ramiz_ch@hotmail.com
