Home » Blog » Topic » How to change authentication mode in SQL Server 2008?

How to change authentication mode in SQL Server 2008?

Andrew Jackson ~ Modified: September 24th, 2015 ~ ~ 1 Minute Reading

Home › Forums › How to change authentication mode in SQL Server 2008?

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • September 23, 2015 at 12:20 pm #722 Score: 0
    Andrew Jackson
    Moderator
    1 pt

    I am using SQL Server 2008 and want to change my authentication mode from Windows to SQL Server mixed mode, but it shows me an error. How to fix this error?

    Thanks In Advance

    September 24, 2015 at 12:01 pm #727 Score: 0
    Stephen West
    Moderator
    4 pts

    Try the following steps:
    1. Open SQL Server Management Studio and connect to your database server.
    2. Right Click on Database Server and click Properties.
    3. Set the Server Authentication to SQL Server and Windows Authentication Mode.

    September 29, 2015 at 7:15 am #763 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    Open the registry and search for key LoginMode under:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
    Update the LoginMode value as 2.

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.