I have an application that uses remote connections to a SQL Server database. I currently use SQL Server Authentication. Someone has suggested that the more secure method for connecting to a database is using Windows Authentication. From my research on your site and elsewhere, it appears that Windows Authentication is only for making connections to the SQL Server when the script is running on the same host as the server instance.
Can anyone give me a little more information or confirm what I've found?
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
I have an application that uses remote connections to a SQL Server database. I currently use SQL Server Authentication. Someone has suggested that the more secure method for connecting to a database is using Windows Authentication. From my research on your site and elsewhere, it appears that Windows Authentication is only for making connections to the SQL Server when the script is running on the same host as the server instance.
Can anyone give me a little more information or confirm what I've found?
Thanks
Windows Authentication works only on Windows. It doesn't care if the SQL Server is local or remote. Both ways are ok.