Question!

We are in the process of planning a implementation of SMS server, Project
server and SharePoint Portal Server. Can one SQL Server 2000 SP3a handle the
database requirements and traffic for these applications? We have
approximately 400 users and operate on a WAN. I would appreciate any real
world input. Thanks!Yes. SQL can easily handle thousands.
"Stacy Springer" <Stacy Springer@.discussions.microsoft.com> wrote in message
news:F7B4E072-D97C-4D88-B1FF-082190559FD7@.microsoft.com...
> We are in the process of planning a implementation of SMS server, Project
> server and SharePoint Portal Server. Can one SQL Server 2000 SP3a handle
the
> database requirements and traffic for these applications? We have
> approximately 400 users and operate on a WAN. I would appreciate any real
> world input. Thanks!

Question!

We are in the process of planning a implementation of SMS server, Project
server and SharePoint Portal Server. Can one SQL Server 2000 SP3a handle th
e
database requirements and traffic for these applications? We have
approximately 400 users and operate on a WAN. I would appreciate any real
world input. Thanks!Yes. SQL can easily handle thousands.
"Stacy Springer" <Stacy Springer@.discussions.microsoft.com> wrote in message
news:F7B4E072-D97C-4D88-B1FF-082190559FD7@.microsoft.com...
> We are in the process of planning a implementation of SMS server, Project
> server and SharePoint Portal Server. Can one SQL Server 2000 SP3a handle
the
> database requirements and traffic for these applications? We have
> approximately 400 users and operate on a WAN. I would appreciate any real
> world input. Thanks!

Question!

We are in the process of planning a implementation of SMS server, Project
server and SharePoint Portal Server. Can one SQL Server 2000 SP3a handle the
database requirements and traffic for these applications? We have
approximately 400 users and operate on a WAN. I would appreciate any real
world input. Thanks!
Yes. SQL can easily handle thousands.
"Stacy Springer" <Stacy Springer@.discussions.microsoft.com> wrote in message
news:F7B4E072-D97C-4D88-B1FF-082190559FD7@.microsoft.com...
> We are in the process of planning a implementation of SMS server, Project
> server and SharePoint Portal Server. Can one SQL Server 2000 SP3a handle
the
> database requirements and traffic for these applications? We have
> approximately 400 users and operate on a WAN. I would appreciate any real
> world input. Thanks!

Question on IP Addresses for SQL Cluster

I'm adding new nodes to an existing SQL Cluster Win2k SP1 SQL 2000 Ent.
SP3a.
Was wondering if I am going to have a problem since the IP addresses of the
new nodes are on a different VLAN.
Old node, Cluster IP & Virtual SQL IP are on 10.28.1 The new nodes are on
10.28.17. These IP addresses are on two different VLANs. Same domain.
I've had so many problems with getting the new nodes to join the cluster and
failover, I wanted to check this out in advance.
Pat Hall wrote:
> I'm adding new nodes to an existing SQL Cluster Win2k SP1 SQL 2000 Ent.
> SP3a.
> Was wondering if I am going to have a problem since the IP addresses of the
> new nodes are on a different VLAN.
> Old node, Cluster IP & Virtual SQL IP are on 10.28.1 The new nodes are on
> 10.28.17. These IP addresses are on two different VLANs. Same domain.
> I've had so many problems with getting the new nodes to join the cluster and
> failover, I wanted to check this out in advance.
There is a long technical explanation for why this can't work without
some serious reconfiguration of your system (router, switch & node
hardware), but the short answer is that the Cluster IP and the SQL IP
are static addresses. They cannot exist on a foreign network any more
than if you had separate physical networks instead of using VLAN tagging.
Save yourself (and your network admins) a boatload of trouble and make
sure that the nodes, cluster & SQL addresses are all on the same IP network.