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

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: Using Widows Authentication and accesssing SQL with SQL Authentication
    ... I am providing SQL authentication in my connection string. ... followed the following link to specify the connection string. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Execute permission denied
    ... note that your connection string has conflicting ... Windows authentication are specified. ... with SQL authentication using the WebUser login, ...
    (microsoft.public.sqlserver.security)
  • Re: Login failed for user NT AUTHORITYANONYMOUS LOGON
    ... To do this with Windows 2000 machines you must have Kerberos security set up. ... authentication credentials of the original client to each of the servers. ... User enters remote sql server name, data base name, ... connection string would be as below. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: sqlxml bulk load permission error
    ... is the server configured for Mixed authentication ... (Windows and SQL Server Logins), ... Server login (so you would specify it in a connection string when the server ...
    (microsoft.public.sqlserver.xml)
  • RE: Logon failed for user (null)..... error
    ... My connection string is fine for using Windows ... Authentication right? ... Also- All users no matter what domain they are on should ...
    (microsoft.public.sqlserver.security)