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
- Athentication Windows
-SQL Authentication
Microsoft SQL Server 2005
Last Comment
ydramu
with windows authentication u can logon using the windows credentials and with the other you need to provide the sql server username and password
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.