Click here to Skip to main content
15,881,380 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I know in general we have dedicated servers for applications and databases and a business logic server in between (3-tier).

What I want to know, can we deploy an application on a dedicated SQL server, means both resides on same server.

Like we have windows as a platform to run applications and web browser to run websites.

In the same way is it possible considering SQL server as platform to deploy .NET applications.
Posted
Comments
Sergey Alexandrovich Kryukov 24-Apr-15 0:26am    
"Deploy .NET application on SQL server" sound gibberish. What would it supposed to mean?
Aren't you mixing up SQL server with HTTP server, some server host, or something else?
—SA

1 solution

Yes you can.

It will have a toll on performance as now the same computer will serve orders for both SQL Server and the application of course.

When requests are made to a server application, although they reside in the same domain name and/or IP Address, the SQL Server orders have a port number unique to it (usually port number 1433).

When you host a web application, it will be served by default on port 80.

That way, services don't mix up or anything: because orders with port number 80 go to the web server and those with port number 1433 go to SQL.
 
Share this answer
 
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900