Link to home
Create AccountLog in
Avatar of GustavoMichels
GustavoMichels

asked on

In the SQL 2005 - what is the difference between a Authentication Windows to a SQL Authentication?

When connecting to SQL 2005 Server, what is the difference between :

- Athentication Windows
-SQL Authentication
Avatar of Aneesh
Aneesh
Flag of Canada image

with windows authentication u can logon using the windows credentials and with the other you need to provide the sql server username and password
Avatar of cuziyq
cuziyq

Back in the old days, SQL Server had its own method of authentication and did not rely on having a domain to validate against.  If you use SQL Authentication, a single user name and password will allow anyone to connect to the server that knows the password.
ASKER CERTIFIED SOLUTION
Avatar of ydramu
ydramu
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account