I am not using the SA account when I log in using windows authentication it seems to pick up my domain and active directory ID which is "us\app1dxd" it appears greyed out as well as the password on the login screen so you can't change it.
If you go into the management studio and right click on the server name in the left hand pane go to properties security the radio button for sql server and Windows authentication mode is selected.
It is normal because the BOL says if you install SQL Server with Windows Authentication the sa account gets disabled, the account remains disabled even when you change to mixed authentication you have to enable the account after changing to mixed authentication.
http://msdn2.microsoft.com/en-us/library/ms144284.aspx
No comments:
Post a Comment