Authentication over internet - Windows or SQL?

  • Hi,

    I am familiar with SQL Server but I am new to all of its administration stuff. I am developing an internet application using ASP.Net, Windows 2003 server and SQL Server. I have a question regarding users and authentication. For an internet application do I have to use SQL Server authenticaiton? In a documentation I read 'SQL Server Authentication may be required for connections with clients other than Windows clients.' But when users request for a dynamic webpage, it is my Windows 2003 server that connects to the SQL Server database. So I was thinking Windows authentication is enough. Am I right? If not, can you please explain.

    Thanks

  • Hopefully, your clients are not attempting to open connections to your DB, regardless of OS they are on.  Only your application, residing on your server, needs to do that.  Unless some part of your application resides on a machine that does not use windows, you only need windows authentication.

  • Thanks Val.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply