RE: SQL SERVER and IIS on the same machine?

2001-04-22 Thread Sicular, Alexander
absolutely not. do not put database and webserver on the same box. not good for security or performance. i have both on my laptop for development stuff but that's it. good luck , alex -Original Message- From: Michael Lugassy [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 22, 2001 5:40 A

Re: SQL SERVER and IIS on the same machine?

2001-04-22 Thread gunawan
I think the most important issue is "Security". If we put IIS and SQL Server on the same machine it could be a dissaster whenever your IIS is being hacked. By separating ISS and SQL Server we make difficult for hacker to exploit what ever we have. Mostly we use local ip address between IIS and SQ

RE: SQL SERVER and IIS on the same machine?

2001-04-22 Thread Kelly Matthews
It really depends I did it for a long time. Never had major problems. HOwever when I finally moved SQL to it's own server I did have performance improvements, used less memories and had fewer errors. Not that there was a major problem while SQL was on the same server it just performs better when i

Re: SQL SERVER and IIS on the same machine?

2001-04-22 Thread zac
Adrian Cooper wrote: > Even redundancy isn't a reason to run two seperate servers, because if either > of > the servers and/or the ODBC/OLEDB connection across the network goes down, the > entire site is down anyway. I believe that the separation is done to ensure data integrity when the web ser

Re: SQL SERVER and IIS on the same machine?

2001-04-22 Thread Michael Lugassy
- Original Message - From: "Mark Woods" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, April 22, 2001 11:31 AM Subject: Re: SQL SERVER and IIS on the same machine? > one of the sites I'm involved in serves about 8 million pages a mo

RE: SQL SERVER and IIS on the same machine?

2001-04-22 Thread Phil Ewington
Hi Michael, We have been using IIS 5.0 & SQL 7.0 on the same machine for about a year. No real problems, but now our traffic levels are much higher we have had to upgrade the memory to 1GB. We will be looking into moving the SQL to it's own server soon. For lower traffic sites I do not see a prob

Re: SQL SERVER and IIS on the same machine?

2001-04-22 Thread Adrian Cooper
- Original Message - From: "Michael Lugassy" <[EMAIL PROTECTED]> Sent: Sunday, April 22, 2001 10:40 AM > Our hosting company told me they don't support SQL SERVER > and IIS on the same NT machine. > "Even Microsoft doesn't recommened it", they claim. I seperate IIS and SQL Server 2000

Re: SQL SERVER and IIS on the same machine?

2001-04-22 Thread Mark Woods
one of the sites I'm involved in serves about 8 million pages a month, well over half of them requiring a database connection (most of these will have more than one query) and the site runs on a dual processor pentium III with win2000 and SQL Server 7 - no problems. Just make sure you spend a l