SQL Authentication vs Windows Authentication 1

[manmaria]

How do I know what kind of authentication is issued for all the users we have in DB?

Thanks,

 

[ptheriault]

To find out what mode was set up during install.
Right click on the server and select properties.
On the security page it will show you which option is selected. If you are wondering how a certian user is authenticating just check the login name in the security folder. If the name is not prefixed with 'domain\' then it is a SQL authentication. If you see Domain\name then it's Windows authentication.
If your server is running in Mixed mode you could have users authenticating differenlty in the same db.
I hope this answers your questions

- Paul
- Database performance looks fine, it must be the Network!