The best way to enable is to set this at the time of installation, the other way is to modify the registry for the same.
For SQL Server 2005 Express Edition, there is not GUI tool available to configure the server. You need to go it manually. The first step is to change the login-mode.
Open registry editor and go to HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer
On the right, look for an entry named LoginMode. The default value, when installed is 1. Update it to 2.
The next step is to restart the service and login.
No comments:
Post a Comment