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

Try to configure the service to run under a user account.

--
Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com

"Blue Fish" <BlueFish@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:8CCF2322-377A-4231-877E-F5361371D4A8@xxxxxxxxxxxxxxxx
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: Smart Card Service
    ... > I am trying to start the smart card service on a windows XP ... > service is the NT Authority \ Local Service Account. ... Mike Brannigan ...
    (microsoft.public.security)
  • Re: Smart Card Service
    ... > I am trying to start the smart card service on a windows XP ... > service is the NT Authority \ Local Service Account. ... Mike Brannigan ...
    (microsoft.public.windowsxp.security_admin)
  • Smart Card Service
    ... I am trying to start the smart card service on a windows XP professional ... service is the NT Authority \ Local Service Account. ... What could be the reason for the failure of this service to start? ...
    (microsoft.public.windowsxp.security_admin)
  • Smart Card Service
    ... I am trying to start the smart card service on a windows XP professional ... service is the NT Authority \ Local Service Account. ... What could be the reason for the failure of this service to start? ...
    (microsoft.public.security)