Viewing 15 posts - 4,096 through 4,110 (of 9,253 total)
rajborntodare (6/7/2013)
"The operation failed because either the specified cluster node is not the owner of the resource, or the node is not a possible owner of the resource"
Open the...
June 10, 2013 at 4:27 am
June 10, 2013 at 12:09 am
Check the share "testing_backup". On the properties go to the share permissions tab and set permission for sql service accounts for both instances (if not the same).
Then go to security...
June 7, 2013 at 12:00 am
Deque (6/6/2013)
Of course, that requirement is one of the major reasons why BizTalk Server gets it's own instance in our environment.
If an app logon absolutely requires sysadmin for support purposes...
June 6, 2013 at 10:17 pm
Also once you have installed an instance name as a clustered instance you cannot install a stand alone instance of the same name into any node in the cluster, whether...
June 5, 2013 at 1:44 pm
For sql server 2005 run the patch from the active node when you have an agreed period of downtime.
June 4, 2013 at 9:39 am
Using -f implies the -m parameter so just use either\or.
To ensure that no applications connect and take the single connection I prefer the following startup command
[Code]Sqlservr -c -m"SQLCMD"[/code]
May 29, 2013 at 12:27 am
sqlfriends (5/21/2013)
we have two nodes for the cluster. each cluster we installed two sql instances, one is prod, one is qa.
Does it mean we have...
May 28, 2013 at 3:18 pm
I use a logon trigger to acheive this, blocking an AD group accessing via certain applications, but the trigger could quite easily just block the group.
May 28, 2013 at 11:37 am
you have 2 adapters connected to the same network range, is teaming an option. You should have at least one adapter connected to a separate heartbeat network.
May 28, 2013 at 9:18 am
If you really want to do it like you detailed then ensuring the same patch level is essential, however you will definitely have issues with encryption using the SMK which...
May 28, 2013 at 9:11 am
To mirror in a workgroup can be acheived with minimal effort using this post.
However, it's a little more complex, but the best way is to use certificates as detailed here.
May 28, 2013 at 8:51 am
Rather than virtualise the existing server, just deploy and configure a new VM, retrieve your existing backups from the old server. You'll also need to script out any objects such...
May 23, 2013 at 5:58 am
arun.zakaria (5/23/2013)
So currently the failover is disabled
How have you disabled failover?
arun.zakaria (5/23/2013)[hrand we are trying to unistall the cluster. However the drop down does not show anything.
You're running the...
May 23, 2013 at 3:14 am
arun.zakaria (5/22/2013)
We have two SQL servers configured as a failover cluster. One of them is a physical and the other is a VM.
Perfectly reasonable I don't see any...
May 22, 2013 at 4:54 pm
Viewing 15 posts - 4,096 through 4,110 (of 9,253 total)