Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jimsurf
Starting Member
18 Posts |
 Posted - 2009-08-17 : 14:41:21
|
| I am working for a company that is planning on opening a public website on a server that also has SQL Server 2005 on it. I am pretty sure that this is a security nightmare. I believe that the web server should be on a different physical box than SQL, but I can't seem to find a microsoft article that outlines the best practice for this configuration. If anybody knows a link, I would really like to see it. The way I understand it, you should have a web server locked down on everything except port 80, then a separate network connection to SQL locked down to port 1443. This is for SQL Server 2005, and ASP.Net 3.5. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-08-17 : 14:56:12
|
Are you using SQL Server Express? It's free to use, otherwise you need a CAL for every person accesing the database.Or you have to have a processor license.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
jimsurf
Starting Member
18 Posts |
Posted - 2009-08-17 : 15:04:04
|
| It's not express. I believe we are using a processer license, But that is not really related to the question I am asking. Regardless of the licensing, I am just trying to ascertain the best practices for server configuration. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-17 : 15:43:13
|
| it's a performance nightmare. don't do it. MSSQL expects all of the memory (except for some left over for the OS) and most of the attention of the CPU. additionally, web server and mssql are both I/O intensive apps. |
|
|
|
jimsurf
Starting Member
18 Posts |
Posted - 2009-08-17 : 16:15:05
|
| Thanks for the heads up on performance. I think I read something about that elsewhere as well, but I am really trying to find a configuration / installation guide that explains the separate server configuration if anybody knows where to find it. |
|
|
|
|
|
|
Installation of SQL on a web server