Re: C# error message SystemCertificates\Disallowed - C# Discussion Boards

11-Feb-13 5:13

In a C# 2008 windows application, I am getting the following error messages:

Process 9528 (\Device\HarddiskVolume2\Program Files (x86)\red\sampleclient.exe) has opened key \REGISTRY\USER\S-1-5-21-11-222-333\Software\Microsoft\SystemCertificates\TrustedPeople
Process 8880 (\Device\HarddiskVolume2\Program Files (x86)\red\sampleclient.exe) has opened key \REGISTRY\USER\S-1-5-21-11-222-333\Software\Microsoft\SystemCertificates\TrustedPeople
Process 9528 (\Device\HarddiskVolume2\Program Files (x86)\red\sampleclient.exe) has opened key \REGISTRY\USER\S-1-5-21-11-222-333\Software\Microsoft\SystemCertificates\My
Process 8880 (\Device\HarddiskVolume2\Program Files (x86)\red\sampleclient.exe) has opened key \REGISTRY\USER\S-1-5-21-11-222-333\Software\Microsoft\SystemCertificates\My
Process 9528 (\Device\HarddiskVolume2\Program Files (x86)\red\sampleclient.exe) has opened key \REGISTRY\USER\S-1-5-21-11-222-333\Software\Microsoft\SystemCertificates\Disallowed
Process 8880 (\Device\HarddiskVolume2\Program Files (x86)\red\sampleclient.exe) has opened key \REGISTRY\USER\S-1-5-21-11-222-333\Software\Microsoft\SystemCertificates\Disallowed

There is no code in the appliation to use registry, thus the only thing I think can be wrong is something about the connection string to the database.

Here is the connection string in the database to a sql server 2008 r2 database:

<connectionStrings>
<add name="eConnectionString" connectionString="Data Source=DEV;Initial Catalog=DEVDB;User Id=TESTUSER;Password=xxxxxx;"providerName="System.Data.SqlClient" />
</connectionStrings>

The account that is being used is setup for an applicaiton by using a sql server login. The account also has some kind of rights to windows.

Thus can you tell what how you think I can change the connection string to the database and/or tell me what you think can be wrong?

modified 11-Feb-13 12:30pm.

Abhinav S11-Feb-13 5:16

Abhinav S

11-Feb-13 5:16

Oops. Looked like your connection string has not pasted correctly.

In any case, to check your connection string, a very good resource is http://connectionstrings.com[^].

WP Apps - Color Search | Arctic | XKCD | Sound Meter | Speed Dial

Dave Kreskowiak11-Feb-13 5:49

Dave Kreskowiak

11-Feb-13 5:49

What makes you think those are errors? I don't see anything that says those are errors. Trace information...yes. But I have no idea what's generating them as the debugger doesn't normally output registry accesses by your code.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

classy_dog11-Feb-13 6:37

11-Feb-13 6:37

I am trying to determine what could be causing the registry keys to be open when I have no code form them.

I am thinking the problem can be one of the following:

1.objects are created? would you dispose of all the objects?
2. The connections to the database are linq to sql statements. Is there a way to close all the objects?
3. When I create a linq to sql database object, should I be disposing of each object after it is no longer needed?

Dave Kreskowiak11-Feb-13 7:26

Dave Kreskowiak

11-Feb-13 7:26

The first quesiton that should be answered is what is putting those message up?? THEN you can go digging around your code, if necessary.

Youre code doesn't have to do anything with the registry and your final .EXE can still appear to do stuff in there because of how Windows load your .EXE and its dependencies.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

jschell11-Feb-13 8:14

11-Feb-13 8:14

classy_dog wrote:
The account that is being used is setup for an applicaiton by using a sql server
login. The account also has some kind of rights to windows.

Not sure what that means. The URL indicates you are using a SQL Server user to log in.
The application cannot be running with that user because it isn't an OS user. Even if the name is the same it is still a different user.

classy_dog wrote:
and/or tell me what you think can be wrong?

What happens when you comment out all of the code that accesses the database?

classy_dog11-Feb-13 16:40

11-Feb-13 16:40

I will comment out the code that accesses the database. That way I will see if the application still runs.
So you are saying that the application can be passing a different value to the database?

When I debug the application, the information that is passed to the database is obtained from the app.config.

Is there somehow a way for an account that has sql server authenication to also have access to windows? If so, what kind of an access would that be?

jschell12-Feb-13 14:17

12-Feb-13 14:17

classy_dog wrote:
Is there somehow a way for an account that has sql server authenication to also
have access to windows?

A Windows user can have access to a SQL Server database.
A SQL Server user does not have access to windows.

classy_dog12-Feb-13 11:19

12-Feb-13 11:19

I wanted ention/ask the following:
1. I did find out that the username and password for both windows and sql server are the same name and value. Basically windows username and password are exactly the same as the sql server login. Could this cause a problem? if so, what would the problem be?
2. Since the value for connecting to the database comes from an app.config file, is there any way to comment out that connection string information and the vale and the application still works? I would think this would be possible if integrated security=true in the app.config file. I would think if integreated security is not set, and a user name and password is supplied, then the sql server login would be true, correct?

jschell12-Feb-13 14:20

12-Feb-13 14:20

classy_dog wrote:
I did find out that the username and password for both windows and sql server
are the same name and value

Which doesn't mean anything. There are two users, in two different contexts and thus they have different access abilities.

classy_dog wrote:
Since the value for connecting to the database comes from an app.config file, is
there any way to comment out that connection string information and the vale and
the application still works? I would think this would be possible if integrated
security=true in the app.config file

Phrased awkwardly but presumably if you are asking if you can remove the user/pwd from the connection string and user a windows user instead.

If so then yes.

classy_dog wrote:
I would think if integreated security is not set, and a user name and password
is supplied, then the sql server login would be true, correct?

Yes.

classy_dog12-Feb-13 16:18

How to sent/receive sms in C# application?

12-Feb-13 16:18

Thanks! you all answered my questions!

Anand Gunasekaran11-Feb-13 3:43

Anand Gunasekaran

11-Feb-13 3:43

I want develop a electricity billing application for my friend academic practical. So I have lot of doubt in sending / receiving sms in c# application. Can anyone help for this. Kindly help me.

thanking you.

José Amílcar Casimiro11-Feb-13 4:28

José Amílcar Casimiro

11-Feb-13 4:28

Research for some sms providers, that give you a web service interface. It is the most practical/easy way.

Abhinav S11-Feb-13 5:21

Abhinav S

11-Feb-13 5:21

If you have the right sms gateway, you will be able to build an application that can send / receive smses.

WP Apps - Color Search | Arctic | XKCD | Sound Meter | Speed Dial

jschell11-Feb-13 8:15

11-Feb-13 8:15

1. Find an SMS Provider
2. Research their protocols
3. Write code that uses their protocol
4. Test it
5. Write a API wrapper around 3 and then use that in your application.

Anand Gunasekaran11-Feb-13 23:21

Anand Gunasekaran

11-Feb-13 23:21

Thanks for your answers. Everything is fine.. Then I there is any possibility to read the sms from nokia pc suite.

Amir Mohammad Nasrollahi29-Jul-13 22:23

Amir Mohammad Nasrollahi

29-Jul-13 22:23

Here a sample[^] for you.

/* LIFE RUNS ON CODE */

Constructor issue

antrock10111-Feb-13 2:41

antrock101

11-Feb-13 2:41

Hello,

I'm having a few issues with my code, i'm following this tutorial http://www.homeandlearn.co.uk/csharp/csharp_s12p6.html Can anyone point me in the right direction. I've included my code below.

The best overloaded method match for 'System.Data.SqlClient.SqlDataAdapter.SqlDataAdapter(string, System.Data.SqlClient.SqlConnection)

<pre lang="c#">Argument 2: cannot convert from 'System.Data.SqlServerCe.SqlCeConnection' to 'System.Data.SqlClient.SqlConnection'

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace Game
{
    public partial class Form1 : Form
    {
        public OpenFileDialog dialog = new OpenFileDialog();
        System.Data.SqlServerCe.SqlCeConnection con;
        System.Data.SqlServerCe.SqlCeDataAdapter da1;
        DataSet ds1;



        public Form1()
        {
            InitializeComponent();
        }

        private void btn_sel_Click(object sender, EventArgs e)
        {
            
            //dialog.Filter = "*.sdf";
            dialog.ShowDialog();
            MessageBox.Show(dialog.FileName);
            loadconnection();

        }

        private void btn_close_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }

        public void loadconnection()
        {
            con = new System.Data.SqlServerCe.SqlCeConnection();
            con.ConnectionString = "Data Source=" + dialog.FileName + ""; //opening dialog (selected file)

            con.Open();


            ds1 = new DataSet();
            string sql = "SELECT * From tbl_games";
            da1 = new System.Data.SqlClient.SqlDataAdapter(sql, con);
            da1.Fill(ds1, "Name");

            con.Close();
        }

    }
}

Abhinav S11-Feb-13 2:51

Abhinav S

11-Feb-13 2:51

antrock101 wrote:
da1 = new System.Data.SqlClient.SqlDataAdapter(sql, con);

You have defined dal to be of type SqlCeDataAdapter.
You cannot assign it to an instance of SqlDataAdapter.

Thus you get an error.
Use one type of data adapter and there should be no error.

WP Apps - Color Search | Arctic | XKCD | Sound Meter | Speed Dial

antrock10111-Feb-13 3:43

antrock101

11-Feb-13 3:43

Thank you

I've entered

da1 = new System.Data.SqlServerCe.SqlCeConnection(sql,con);

Which appears to work however it requires a function that contains 2 arguments and i'm not entirely sure what it's trying to reference

Richard MacCutchan11-Feb-13 4:45

Richard MacCutchan

11-Feb-13 4:45

Why not look at the documentation[^] first?

antrock10111-Feb-13 4:55

antrock101

11-Feb-13 4:55

I have, but i'm having trouble getting this to work

Richard MacCutchan11-Feb-13 5:10

Richard MacCutchan

11-Feb-13 5:10

And you think we can guess what trouble that is? Please show the exact code you are using and what errors you receive. If you look closely at the link I gave you it shows exactly what parameters are required by the constructor. Have you done it correctly?