DebbieCoates
Programmer
Can anyone help me I have seriously messed up my SQL Security on my local SQL server. i am trying to set it back but I cant. i tried Deleting my sql Server registration, then adding it again, but that didn't work.
what I did was change it to SQL and windows authentication, however, when I try to set it back to windows it wont let me.
What I want is to have my local sql server set to windown authentication, with one logon which is sa, but i am getting really confussed trying to achieve this, any help would be appreciated
what I did was change it to SQL and windows authentication, however, when I try to set it back to windows it wont let me.
What I want is to have my local sql server set to windown authentication, with one logon which is sa, but i am getting really confussed trying to achieve this, any help would be appreciated