InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 23:00:02 GMT20http://www.sqlservercentral.com/Forums/Topic506310-149-1.aspx[quote][b]sam_invincible1 (5/25/2008)[/b][hr]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 :-([/quote]Hi,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. http://msdn.microsoft.com/en-us/library/ms144284.aspxHope this helps!Phillip CoxMCITP - DBAdmin|MCTS - SQL Server 2005|MCP - SQL Server 2000Sun, 25 May 2008 01:50:35 GMTPhillip Coxhttp://www.sqlservercentral.com/Forums/Topic506310-149-1.aspxi 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 :-(Sun, 25 May 2008 01:30:55 GMTsam_invincible1