Forum Replies Created

Viewing 15 posts - 2,581 through 2,595 (of 9,244 total)

  • RE: Clustered Disk error in Sql clustering

    sej2008 (12/19/2014)


    How cluster or AD will recognize NIC is for ISCSI.

    By disabling Netbios resolution, disabling DNS registration and not stting a default gateway the cluster service should automatically discover the...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: What role\permission is needed to grant db_owner?

    to grant DB_Owner you must be a member of the DB_Owner database role or sysadmin server role

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL2014 Trying to get SQL Server to listen on a different port isn't working

    could you also post the output of this run from a command prompt

    netstat -anp TCP

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL2014 Trying to get SQL Server to listen on a different port isn't working

    what happens if you try connecting with

    computername, portnumber

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL 2014 cluster setup fails with component error 0x84CF0004 while updating permission setting for folder

    did you ensure to install to a subfolder under each mount point?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How to configure File share storage for windows clustering

    see the section on quorum at this link[/url]

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Problems while sql clustering on windows 2008 R2

    what is it you are trying to achieve?

    Are you trying to setup a clustered instance of sql server or an alwayson availability group?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Clustered Disk error in Sql clustering

    try this[/b[/url] for starters, it references sql 2008 but the priniciples are the same to configure the iSCSI LUNs

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: can you do Alwayson setup without any storage

    sej2008 (12/18/2014)


    Hi all I would like to know whether you can configure

    HAGAlwayson without wfc shared storage???

    what quorum type setting is needed???

    To configure a Windows Server Failover Cluster using a disk...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Clustered Disk error in Sql clustering

    you've setup a heartbeat network which you don't actually require, but where is your iSCSI NIC to segregate the iSCSI network traffic?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Not able to connect to two sql instances on vmware

    could you confirm the Operating System version on the 2 cluster nodes?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: monday morning sanity check - re-establish mirror.

    snomadj (12/15/2014)


    I need to 'break' and re-establish a faulty mirror.

    Log is quite big due to not correctly mirroring for a few days.

    My plan is:

    a) break mirror.

    b) backup log - to...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: unable to remove disconnected mirror in order to re-establish mirroring.

    i seem to remember this was an issue in 2008.

    The quick fix is to stop the sql server services on the mirror and remove the database files (or rename...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL SERVER 2012 ALWAYS ON

    you didnt use the "Remove secondary database" option then?

    Haver you tried this on the secondary where the database was deleted from?

    ALTER DATABASE thedb SET HADR OFF

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Clustered Disk error in Sql clustering

    attaching new LUns to a Windows server 2008 on will automatically offline the disks as part of the Diskpart offline policy. This is mainly to avoid the situation where more...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 2,581 through 2,595 (of 9,244 total)