May 25, 2008 at 1:30 am
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 🙁
May 25, 2008 at 1:50 am
sam_invincible1 (5/25/2008)
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 🙁
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.aspx
Hope this helps!
Phillip Cox
MCITP - DBAdmin|MCTS - SQL Server 2005|MCP - SQL Server 2000
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply