i am confused between windows authentication and sql server login , how is windows authentication more secure? what domain name should we give in assigning sql server login account? where should we get the domain name? how would a client connect to the server instance if he is not in the local network?
how to create a connection between client and server ? could anyone please clear this ....thank you :-(
Here is a good link, which will provide you with a great overview, but overall, Windows security is more secure than using SQL Server authentication and simplifies user management. In terms of domain name, you will need to have a pre-built Windows domain prior to being able to use Windows authentication, otherwise you will not be able use this security method. If a client is not on your local network, you will need to configure your setup using mixed-mode security for your SQL Server's instances, as you will only be able to authenticate user's of this type via SQL Server security model.
Hope this helps!
MCITP - DBAdmin|MCTS - SQL Server 2005|MCP - SQL Server 2000