multiple web site to access the same SQL Server database

Each SQL Server database should correspond to one IP address. I assume web
server and database server are in separate machines. Here's 2 cases:
case 1: A single web site have data access to the SQL Server database.
case 2: There are multiple web sites need to have data access to the same
SQL Server database.
Obviously, case 2 will create more network traffic than case 1. Then how
should do we about that? Use more than one SQL Server (i.e. different IP
address)? But what IP address should use in connection string in web pages'
Please advise!
Thanks!Hi,
If you want to distribute the work load amoung multiple SQL servers I
believe you would have to use some form of clustering technology such as
Microsoft Cluster Service. Then you can use the IP address of the virtual
SQL Server. There are limitations to this solution so be sure to investigate
and make sure that it fits your requirement.
Hope this helps
Chris Taylor
"Matt" <mattloude@.hotmail.com> wrote in message
news:e92o1DZoDHA.1632@.TK2MSFTNGP10.phx.gbl...
> Each SQL Server database should correspond to one IP address. I assume web
> server and database server are in separate machines. Here's 2 cases:
> case 1: A single web site have data access to the SQL Server database.
> case 2: There are multiple web sites need to have data access to the same
> SQL Server database.
> Obviously, case 2 will create more network traffic than case 1. Then how
> should do we about that? Use more than one SQL Server (i.e. different IP
> address)? But what IP address should use in connection string in web
pages'
> Please advise!
> Thanks!
>
>