Connecting client applications to sql server

  • 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 🙁

  • 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