SQL Server Authentication Mode

[DebbieCoates]

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 windows authentication, with one logon which is sa, but i am getting really confussed trying to achieve this, any help would be appreciated

at the momment, on my database in my users i have dbo in name, but not login, what i want is a user called dbo with the sa password.

 

[SQLBill]

The SA account is NOT a Windows Account. If you change your authentication to Windows ONLY and the only account is SA, you will NOT be able to log in to SQL Server. Major HOSED situation.

You cannot make a DBO user either. That is a SQL Server reserved 'owner'.

What you can do is give a Windows Login access to SQL Server with the permissions you want.

You cannot create a Windows Login in SQL Server. All you can do is ADD a Windows Login to SQL Server.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875