Monday, May 4, 2009

How to enable Sql Server Authentication in Sql server.

Usually, while installing the sql server, we select the option to use the Windows authentication mode to connect to sql server. But for some scenarios we need Sql server authentication mode to access the database. How to changes? Below are the steps to follow to enable sql server authentication for sql server.
  1. Login to sql server with windows authentication.
  2. Right click on the server (your sql server name), select properties.
  3. In the section, select a page, select security and in the server authentication section select the radio button SqlServer and windows Authentication mode, then click ok.
  4. After your changes saved, then go to Security -- users -- add a user for sql authentication.
  5. Needs restart of the Sql Service instance to reflect the changes.

No comments:

Post a Comment