Showing posts with label 64-bit. Show all posts
Showing posts with label 64-bit. Show all posts

Monday, March 26, 2012

easy questions related with A-P cluster

Hi everyone,

I'm just a newbie with clustering.

We've got a 64-bit A-P cluster running with Sql25k 64-bit too.

Each node own two local network adapters. One of them (the one currently is Active) own three IP and the another one only one.

Why? From CLUADMIN I see as one of these three is set as Cluster IP Address in Active Resources. So I see the following configuration for the Active node:

Adapter 1: IP public for Active Directory

Adapter2:IP1 (reserved or ?)

IP2 (used as SQL IP Address 1 in Active Resources)

IP3 (used as Cluster IP Address in Active Resources)

Passive node:

Adapter 1: IP public for Active Directory

Adapter2:IP (only have one ?)

Is this correct/necessary? Does anyone have similar configuration?

Thanks for your time,

Does anyone have any idea?|||

This issue has already solved.

Ip1: physical node

Ip2: virtual cluster

Ip3: virtual Sql

sql

easy questions related with A-P cluster

Hi everyone,

I'm just a newbie with clustering.

We've got a 64-bit A-P cluster running with Sql25k 64-bit too.

Each node own two local network adapters. One of them (the one currently is Active) own three IP and the another one only one.

Why? From CLUADMIN I see as one of these three is set as Cluster IP Address in Active Resources. So I see the following configuration for the Active node:

Adapter 1: IP public for Active Directory

Adapter2:IP1 (reserved or ?)

IP2 (used as SQL IP Address 1 in Active Resources)

IP3 (used as Cluster IP Address in Active Resources)

Passive node:

Adapter 1: IP public for Active Directory

Adapter2:IP (only have one ?)

Is this correct/necessary? Does anyone have similar configuration?

Thanks for your time,

Does anyone have any idea?|||

This issue has already solved.

Ip1: physical node

Ip2: virtual cluster

Ip3: virtual Sql

Friday, March 9, 2012

Dynamically change the sender email address on a SQL2005 Windows 2003 server 64-bit box using da

We currently use xp_smtp_sendmail to send the emails on a sql2000 32-bit box. We are trying to move our databases to a new sql2005 64-bit box. One solution is to replace xp_smtp_sendmail with database mail since xp_smtp_sendmail does not work on 64-bit box. The only problem is that we need to change the sender email dynamically based on the query results and I don't know how to accomplish this by using database mail. Does anyone have an idea? We are not restricted to database-mail solution though.

Thanks for help.

EXECUTE msdb.dbo.sysmail_update_account_sp
@.account_name = 'AdventureWorks Administrator',
@.email_address = 'dba@.Adventure-Works.com'


See SQL Server 2005 Books Online topic:
sysmail_update_account_sp (Transact-SQL)
http://msdn2.microsoft.com/fr-fr/library/ms188381.aspx


EXECUTE msdb.dbo.sysmail_update_account_sp
@.account_name = 'AdventureWorks Administrator',
@.email_address = 'dba@.Adventure-Works.com'

|||Thanks. This answers my question.

Dynamically change the sender email address on a SQL2005 Windows 2003 server 64-bit box using da

We currently use xp_smtp_sendmail to send the emails on a sql2000 32-bit box. We are trying to move our databases to a new sql2005 64-bit box. One solution is to replace xp_smtp_sendmail with database mail since xp_smtp_sendmail does not work on 64-bit box. The only problem is that we need to change the sender email dynamically based on the query results and I don't know how to accomplish this by using database mail. Does anyone have an idea? We are not restricted to database-mail solution though.

Thanks for help.

EXECUTE msdb.dbo.sysmail_update_account_sp
@.account_name = 'AdventureWorks Administrator',
@.email_address = 'dba@.Adventure-Works.com'


See SQL Server 2005 Books Online topic:
sysmail_update_account_sp (Transact-SQL)
http://msdn2.microsoft.com/fr-fr/library/ms188381.aspx


EXECUTE msdb.dbo.sysmail_update_account_sp
@.account_name = 'AdventureWorks Administrator',
@.email_address = 'dba@.Adventure-Works.com'

|||Thanks. This answers my question.