Re: login failed for user ... Not Associated with a trusted SQL Se

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Well I changed my connection string but the error message is still the same,
I think now it's rigth

mConnection = new SqlConnection("data source=FGUL506907WXP;initial
catalog=IDPS;Integrated Security=SSPI");

It uses windows authentication.

Does someone have an connection string example between a windows CE device
and a remote SQL server 2000

I don't know what to do and it very urgent.


"Sue Hoegemeier" wrote:

> In your connection string, you are specifying parameters for
> both SQL authentication and Windows authentication - it
> needs to be one or the other. If you use Windows
> authentication, you don't specify a user id and password.
> You can find some examples at:
> http://www.carlprothman.net/Default.aspx?tabid=86#SQLClientManagedProvider
>
> -Sue
>
> On Tue, 2 Aug 2005 07:56:11 -0700, Christian F CLY
> <ChristianFCLY@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> >Hello,
> >
> >I'm trying to connect a mobile computer runing under windows CE to a
> >database located on a windows XP desktop.
> >The mobile computer application is written in C# under Visual Studio .NET
> >2003.
> >
> >My problem occurs when I execute mConnection.Open();
> >
> >A SqlException is caught with this message :
> >Login failed for user '(null)'. Reason : Not associated with a trusted SQL
> >Server connection.
> >
> >here is the connection string :
> >mConnection = new SqlConnection("User ID=sa;data source=" + mSqlServer +
> >";Integrated Security=SSPI;initial catalog=IDPS;Password=xxxx;persist
> >security info=false;Trusted_Connection=yes");
> >
> >What can I do to correct it ?
>
>
.

Relevant Pages

  • Re: Newbie Question - "trusted SQL Server connection"
    ... you want to use Windows authentication. ... which is the windows authentication information you are passing. ... removing this from your connection string if your intention is to use SQL ... > - generate a data set ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • RE: MSDASQL and ImportMixedTypes
    ... your application is running against Windows ... Jet component has already been installed your system. ... the error message ""Cannot find installable ISAM" in OleDBConnection. ... Please make sure your connection string is correct. ...
    (microsoft.public.data.odbc)
  • Re: connection string help
    ... Since you are using Windows authentication, this connection string will only ... work for you if the account you are running under (your ID for WinForms, ... Microsoft MVP - Windows Client ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: General questions about LDAP, GC and access permissions
    ... Windows Communication Foundation) they are authenticated with the regular ... this is done by examing what groups the user is a member of. ... Since the regular windows authentication is used, ... trusted domain in an external forest. ...
    (microsoft.public.windows.server.active_directory)
  • Re: IIS 7 and WindowsIdentity
    ... I think the key problem is how to create the Windows Account ... Configuring Windows Authentication ... Microsoft is providing this information as a convenience to you. ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.aspnet.security)