Friday, March 23, 2012

How to change from Windows to SQL Server Authentication?

Hi

I want to know how can I change Login from Windows Authentication to SQL Server Authentication. I'm using SQL Server Express Edition and SQL Server Management Studio Express to connect to the Sql Server. I selected Windows Authentication during the installation of the SQL Server Express and now i want to cahnge to SQL Server Authentication using sa account.

Your help will be highly appreciated.

1. In Object Explorer choose Properties for your SQL Server instance. Then choose "Security" tab and check "SQL Server and Windows Authentofocation"

2. Enable sa login, because it's disabled by default

|||Thank you Konstantin.

No comments:

Post a Comment