Viewing 15 posts - 7,591 through 7,605 (of 9,253 total)
This has all changed between versions SQL Server 2008 and SQL Server 2008 R2
which edition are you using?
Licensing all physical CPU's in the Host machine at Enterprise level in 2008...
October 12, 2010 at 9:19 am
Halcyon (10/11/2010)
Evening Perry,can I confirm the steps:
1) Windows Cluster
2) SQL Server Cluster
3) Then add MSDTC to the SQL Server application
That's the steps you need to follow
Halcyon (10/11/2010)
October 12, 2010 at 4:48 am
Create a clustered DTC resource and put it into the same resource group as your clustered SQL Server instance.
Then create a mapping to the DTC resource for the SQL Server...
October 11, 2010 at 12:01 pm
Duran (10/11/2010)
Just to be clear, if I have 5 SQL instances on a cluster, I'd need 5 separate drives, each with their own drive letter? 5 SQL instances cannot put...
October 11, 2010 at 11:06 am
Minto Minto(quendans) (9/30/2010)
login failed for user .the user is not associated with a trusted sql server connection :error 18452
what are the severity and state values for this message?
October 10, 2010 at 9:50 am
Shared disk arrays can take many different formats. You could have a linux based server with disks shared over iSCSI, you may have a storage area network using fibre channel...
October 9, 2010 at 7:21 am
you will need new disk resources to install the SQL 2008 instance, you wont be able to share the SQL 2005 disk resources!
October 9, 2010 at 7:18 am
Halcyon (10/7/2010)
I would take the sql server application offline and then power down passive node, active node.Perry, your opinion?
Yes for a clean shutdown, the domain controller (which I guess is...
October 7, 2010 at 7:59 am
Go into failover cluster manager and expand the cluster. Right click Storage and select Add Disk!
October 7, 2010 at 3:45 am
Marios Philippopoulos (10/6/2010)
Perry Whittle (10/6/2010)
Marios Philippopoulos (10/6/2010)
I just need a bit more ammunition to convince the SA team to make these changes.
Point them to the Microsoft KB and ask them...
October 6, 2010 at 11:16 am
ogrishman (10/5/2010)
Hi,
I've created a test SQL Server clustering environment. I use SQL Server 2008 R2 on Windows Server 2008 R2 to do the experiment. Now I have one domain controller(also...
October 6, 2010 at 10:48 am
Duran (10/6/2010)
when I try to add the extra disk, I just get an error saying that no suitable drives for clustering were found.
is the drive online and formatted?
October 6, 2010 at 10:45 am
yeah, i'm sure i've seen those before. MS recommendation though as far as I've read is still not to team the heartbeat and minimise all traffic by disabling DNS and...
October 6, 2010 at 10:43 am
Marios Philippopoulos (10/6/2010)
I just need a bit more ammunition to convince the SA team to make these changes.
Point them to the Microsoft KB and ask them to follow MS best...
October 6, 2010 at 10:09 am
shouldn't need a reboot. Your public connection is set for mixed communication anyway.
October 6, 2010 at 9:48 am
Viewing 15 posts - 7,591 through 7,605 (of 9,253 total)