I am developing a C# application, the user should be subscripted to use the program. The program should query if the username and password is correct from a remote database. I'm using MS SQL Server 2008 as the database. How can I first establish a connection, -do I need to change some permissions, open ports etc- and then how can I retrieve the query result? Can you give me a clear explanation or a link?
Thanks in advance.