Connecting to the MSSQL server from your ASP.net scripts is a very easy thing. How you connect to the MSSQL server with your ASP.Net script? The MSSQL database is on a separate server so you will need to use the server IP in your connection string.
Â
Driver={SQL Server};Server=your_database_server_ip;Database=some_database;User ID=some_user;
Password=some_password;