Couple Issues Relating to SQL Server Security/Login

Hello,
Is it possible to tell SQL Server Express to only use SQL Authentication? I
would like it so that there is just an sa SQL account on a SQL Server
instance. Is it possible to script the SQL Server Express setup to do just
that? I certainly understand that it can be more secure to use Windows
Security over SQL Authentication, however the password is very strong (64
characters in length randomized).
Sincerely,
James Simpson
Straightway Technologies Inc.There are only two authentication modes to login to SQL Server.
1- Windows (only) Authentication
2- Mixed Authentication
There is no 3- SQL (only) Authentication.
However, you can delete Windows Logins from the Security node in SSMS, so,
only users who has SQL Login accounts will be able to login to your SQL
Server. However this is a little bit risky as you'll have only one sysadmin
("sa" in your case) and if you somehow lose its password or something then
you'll be locked yourself and can not get in to your SQL Server. You must be
very very careful about this operation.
Ekrem ?nsoy
"James Simpson" <JamesSimpson@.discussions.microsoft.com> wrote in message
news:481D3155-0061-46F2-912C-8003D6C4A950@.microsoft.com...
> Hello,
> Is it possible to tell SQL Server Express to only use SQL Authentication?
> I
> would like it so that there is just an sa SQL account on a SQL Server
> instance. Is it possible to script the SQL Server Express setup to do
> just
> that? I certainly understand that it can be more secure to use Windows
> Security over SQL Authentication, however the password is very strong (64
> characters in length randomized).
> Sincerely,
> James Simpson
> Straightway Technologies Inc.|||Fair enough. I am not worried about losing the password per se since it wil
l
be an application that will be logging into SQL Server for me.
Sincerely,
James Simpson
Straightway Technologies Inc.