Home » 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 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • 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 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.