<div>
I work in php w/ms sql server and not .net. However, the answer is you can connect to whatever db you want. &nbsp;On a small site where you have your sql db on the same server as your site, it is best to use use localhost and not open up the port to your sql server to the outside.<br />
<br />
If you have your sql server on a different box than your web server, then you need to open your firewall to allow traffic to your sql server.<br />
<br />
<a href="https://msdn.microsoft.com/en-us/library/jj653752(v=vs.110).aspx" rel="ugc">https://msdn.microsoft.com/en-us/library/jj653752(v=vs.110).aspx</a><br />
<br />
<a href="https://technet.microsoft.com/en-us/library/cc646023(v=sql.110).aspx" rel="ugc">https://technet.microsoft.com/en-us/library/cc646023(v=sql.110).aspx</a><br />
<br />
If you need more specific help for .net questions, try requesting attention by clicking on the link in the bottom right of your question post and ask the moderator to help.
</div>


I work in php w/ms sql server and not .net. However, the answer is you can connect to whatever db you want.  On a small site where you have your sql db on the same server as your site, it is best to use use localhost and not open up the port to your sql server to the outside.

If you have your sql server on a different box than your web server, then you need to open your firewall to allow traffic to your sql server.

https://msdn.microsoft.com/en-us/library/jj653752(v=vs.110).aspx [https://msdn.microsoft.com/en-us/library/jj653752(v=vs.110).aspx]

https://technet.microsoft.com/en-us/library/cc646023(v=sql.110).aspx [https://technet.microsoft.com/en-us/library/cc646023(v=sql.110).aspx]

If you need more specific help for .net questions, try requesting attention by clicking on the link in the bottom right of your question post and ask the moderator to help.

<div>
<div class="content wysiwyg-content">
It looks like when a user logs in to a webpage with their credentials, that ASP connects to &quot;LocalSQLServer&quot; which is defined in machine.config.<br />
Is this hardcoded into one of the logon controls or can it be changed to use a server that I specify in my own web.config file?
</div>
</div>


It looks like when a user logs in to a webpage with their credentials, that ASP connects to "LocalSQLServer" which is defined in machine.config.
Is this hardcoded into one of the logon controls or can it be changed to use a server that I specify in my own web.config file?

,IIS, Asp.net login and LocalSQLServer

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Web applications are systems that run in browsers that perform functions normally associated with other client-based programs. One of the most commonly used web applications is email; instead of downloading individual emails to a local machine, the data is shown through a website. Other examples of web applications are collaborative systems like a wiki or an online game.