Need to add additional NIC to SQL Cluster

Hi
We recently built a W2K Advanced server, SQL Ent 2000 cluster.
Each node of the cluster had 2 NIC ports:
1 NIC was used for Cross over cable
Other NIC was used for LAN.
All standard build servers in our environment should have 2 NIC
connections - one going to our normal lan and the other nic connected to the
backup lan.
The powers at be we notified that the cluster was short of one NIC, but the
build was santioned to go ahead.
I now need to know what i need to do in order to add the additional nic to
the cluster and for everything to remain ok...
Please advise...
Cheers Ray
It will depend on the hardware, but basically you would buy a nic,
physically put it in the machine, load the drivers, and configure it with
the appropriate IP settings.
Don Wilwol
http://spaces.msn.com/members/wilwol/
<Ray> wrote in message news:O5M2z86DFHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hi
> We recently built a W2K Advanced server, SQL Ent 2000 cluster.
> Each node of the cluster had 2 NIC ports:
> 1 NIC was used for Cross over cable
> Other NIC was used for LAN.
> All standard build servers in our environment should have 2 NIC
> connections - one going to our normal lan and the other nic connected to
> the
> backup lan.
> The powers at be we notified that the cluster was short of one NIC, but
> the
> build was santioned to go ahead.
> I now need to know what i need to do in order to add the additional nic to
> the cluster and for everything to remain ok...
> Please advise...
>
> Cheers Ray
>
|||Add the nic. Put it on the backup network. In the cluster uncheck the box
for that new NIC that allows it to function in the cluster
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
<Ray> wrote in message news:O5M2z86DFHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hi
> We recently built a W2K Advanced server, SQL Ent 2000 cluster.
> Each node of the cluster had 2 NIC ports:
> 1 NIC was used for Cross over cable
> Other NIC was used for LAN.
> All standard build servers in our environment should have 2 NIC
> connections - one going to our normal lan and the other nic connected to
> the
> backup lan.
> The powers at be we notified that the cluster was short of one NIC, but
> the
> build was santioned to go ahead.
> I now need to know what i need to do in order to add the additional nic to
> the cluster and for everything to remain ok...
> Please advise...
>
> Cheers Ray
>

need programmer to build a DTS...

I need to get a dts package built in sql 2000. Basic tasks are:
* Users login to site and upload excel files to their own directory
* Need to validate the data within the excel files
* Then import that data into an existing database
* If a record already exists in db, then update it with new data
* original files to be zipped and moved to another folder after import
* exceptions logged or emailed
I haven't built a dts before and am looking to hire someone to build it
out. Usually go to elance but thought I could get some direction here...Hi
Read some info
www.sqldts.com
<dan@.globenettravel.com.au> wrote in message
news:1152108021.520182.221220@.a14g2000cwb.googlegroups.com...
>I need to get a dts package built in sql 2000. Basic tasks are:
> * Users login to site and upload excel files to their own directory
> * Need to validate the data within the excel files
> * Then import that data into an existing database
> * If a record already exists in db, then update it with new data
> * original files to be zipped and moved to another folder after import
> * exceptions logged or emailed
> I haven't built a dts before and am looking to hire someone to build it
> out. Usually go to elance but thought I could get some direction here...
>

Need Help.

I m using SQL SERVER EXPRESS edition for storing user login information. I have use built in login controls in my application. Login is working properly, user are also created but i also want to assign roles to users and modify their details programmatically.

How can i do this ? Plzzzzzzz Help. Its urgent.

These resouces should help point you in the 'right' direction:

Security -Giving Permissions through Stored Procedures
http://www.sommarskog.se/grantperm.html

SQL Server 2005 Security
http://msdn.microsoft.com/msdnmag/issues/05/06/SQLServerSecurity/