Re: Connection to SQL Server CE Windows Service via C# - Error 250

Encryption is not specified in the connection string. This is SQL Server
Compact 3.1 (2005).

I am explicitly provinding the Data Source and Password attributes in the
connection string.

I have since created a new database, with an empty password. I am able to
connect to it via the windows service under the Local Service account.

However, I would like to have the database password protected.

"Paul G. Tobey [eMVP]" wrote:

Is encryption specified in the connection string? How are you requesting
access, user name and password explicit in the connection string?

Paul T.

"Blue Fish" <BlueFish@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D21D3EBD-9561-40A9-A21D-C2C62A5020A7@xxxxxxxxxxxxxxxx
Operating System: Windows XP Professional (5.1, Build 2600) Service Pack 2

I'm using SQL Server Compact Edition as a private data store.

The reason I mentioned a permissions issue is that I can connect to the
same
DB via C# in a Windows application that is not running as a service under
the
Local Service account.

So my theory was that the Local Service account is somehow restircted in a
way that prevents it from accessing the appropriate encryption mechanism
to
connect to the DB.

"Paul G. Tobey [eMVP]" wrote:

Funny, I'd assume that the problem is that the operating system doesn't
support encryption. What is the connection string? What version of
Windows
CE is running and what's built into it?

Paul T.

"Blue Fish" <Blue Fish@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A3453930-4081-46F8-B488-337DDC5CC97E@xxxxxxxxxxxxxxxx
SQL Server CE 2005, Visual Studio 2005, C#

I have a windows service that I wrote that runs under the Local Service
account. I cannot connect to my SQL Server CE database. Every call to

_dbConnection.Open();

yields Error 25080 - The operating system does not support encryption.
Now
I assume that the issue is permissions, but does anyone know of how to
resolve this issue?






.

Relevant Pages

  • Re: Help Encrypting Connection String
    ... I have simply 'overridden' the LocalSqlServer connection string to point to my SQL Server DB. ... to encrypt the section and places it into web.config - the config file then refers to the reg key. ... I don't like to hardcode anything, in general, but I'd rather do that with an encryption key than the underlying data itself. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Encryption of Connection String
    ... I don't think ANY encryption is applied to the string by default. ... > Do you know what level of encryption IS applied to the connection string? ... >> to the SQL Server via SQL authentication the password is only ...
    (microsoft.public.sqlserver.security)
  • Re: Encrypt connection channel
    ... I assume that you are talking only about encryption during transmission, ... this question is not about how to store sensitive data in a database. ... > DMZ and SQL Server in secured zone? ... > 1 Encrypt the connection string that is used to make a connection, ...
    (microsoft.public.sqlserver.security)
  • Encrypt connection channel
    ... (Been reading other messages on this subject but could not find an answer, ... DMZ and SQL Server in secured zone? ... Encrypt the connection string that is used to make a connection, ... Encryption of sensitive sensitive query data that is exchanged between ...
    (microsoft.public.security)
  • Encrypt connection channel
    ... (Been reading other messages on this subject but could not find an answer, ... DMZ and SQL Server in secured zone? ... Encrypt the connection string that is used to make a connection, ... Encryption of sensitive sensitive query data that is exchanged between ...
    (microsoft.public.security)
Loading