Post reply

Login

  • June 22, 2006 at 10:35 am

    #75000

    Hi,

    I just install SQL server in one of my new server, I created couple of logins, when people try to connect it says Microsft SQL Login Coonection fail error.

    When I installed I choose Windows authentication.

    Even on the same server when I login to Query Analyser I cannot login through SQL Authentication as sa ot anyother login id.

    Nita.

     

     

  • June 22, 2006 at 10:41 am

    #645320

    Well the logins which u have created are using windows authentification or sql server.

    If they are using sql server authentification then u need to select mixed mode rather than windows authentification only.

  • June 22, 2006 at 10:48 am

    #645322

    Thanks, Can I change this setting to mix and How?

  • June 22, 2006 at 10:52 am

    #645323

    yes.

    Open the enterprise manager>>Right Clik on ther server>>Go to Properties>>Security>>Here in authentication chose Sql Server and Windows

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

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