Wednesday, May 30, 2012

How to create SqlServer Login when not asked at time of installation

No need to reinstall sqlserver .Just login with your window authentication.go into security folder->logins->add new login ->sa ->select authenication as sqlserver->password.Now u can have sqlserver login.













Enable SqlServer Authentication (Mixed Mode)



Enable MixedMode
Enable sa
Be sure to restart the SQL Service after changing the authentication mode for the changes to take effect.