Post reply

i have geting the error "Login failed for user ''(null)''. Reason: Not associated with a trusted SQL Server connection

  • July 25, 2005 at 4:58 am

    #152485

    Hi All

    When the application is on the same computer as an instance of SQL Server 2000 then okay this is working fine but When the application is on a separate client, a network IPC, such as TCP/IP or Named Pipes, is used to communicate with SQL Server. then i have geting problem.

    Please give me solution.

    Thanks

    Ajay Sharma

     

  • July 25, 2005 at 5:39 am

    #576724

    #1.  Please don't double post.  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=17&messageid=203884

    #2.  This is due to the fact that whomever is running the application from another computer doesn't have permissions.  Assumption:  You are running in windows-only mode.  To correct this you may need to done 1 or both of the below

    A.  Change to mixed mode and see if that fixes the problem (See BOL for more information)

    B.  Add the user/group to the SQL server (See BOL for more information)

     



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • July 26, 2005 at 11:07 am

    #577252

    When the networks are not trusted, you cannot use windows authentication. You have to use SQL authentication.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply