Hi

Im about to install SQL Server 2012 but needs some advice. 

I have a server with IIS. There is a web application that uses the sql server. 

What should i do when i only want that application to use the database?

And so that you can only connect to the database from the same computer as the SQL server?

Regards

if you want your application only to connect to your database then use a specific user that have permissions and use these credentials to connect to the database.

If you want to restrict other to connect to your database disable the option remote connection to your database.

Hello,

You can disable remote Connections, see Configure the remote access Server Configuration Option, and you can disable network protocoll like TCP, see Enable or Disable a Server Network Protocol; local application uses "Shared Memory" protocol to Access SQL Server.