Forum Replies Created

Viewing 15 posts - 1,936 through 1,950 (of 9,244 total)

  • RE: New problem "Name resolution not yet available" on SQL Server 2014

    Arestas (7/6/2015)


    I don't have any access to AD or DNS.

    A windows server failover cluster requires an Active Directory domain and a valid DNS server. It is possible to implement clustering...

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

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

  • RE: New problem "Name resolution not yet available" on SQL Server 2014

    can you tell us a bit more about your environment, is this a test system?

    Who installed\controls the domain controller(s) and DNS server(s)?

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

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

  • RE: Using xp_cmdshell to grant fulladmin (read/write/xecute/full control) to a sql user

    when running as a sql server account the job will impersonate the service account at the OS level. If the service account has permission to the folder then it will...

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

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

  • RE: SA Password Reset\Recovery

    that document doesn't do anymore than what you say you were doing except that your directly modifying the service startup.

    Inconsistencies I can see are you start a default instance of...

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

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

  • RE: Swapping drive letters in SQL 2012 cluster

    feersum_endjinn (7/6/2015)


    Hi Perry,

    It was more of a drive-letter swap. The reason was that new, faster storage has been provisioned so data on the old drive was moved to the new....

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

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

  • RE: The Database Mirroring endpoint cannot listen for connections due to the following error: '10049(The requested address is not valid in its context.)'.

    yes, until the IP is bound to the adapter you cannot use it, but as I said you're still pushing all that traffic down the 1 NIC!

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

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

  • RE: cluster

    giri10488 (7/6/2015)


    can u pls tell me what is the role of sql dba in cluster environment?

    which things he has to monitor & how?

    main role of dba if one node goes...

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

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

  • RE: alwayson

    thank you for the link Jacob

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

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

  • RE: The Database Mirroring endpoint cannot listen for connections due to the following error: '10049(The requested address is not valid in its context.)'.

    Arestas (7/6/2015)


    Well, no.

    To use the IP you wanted to use you would need to add this to your NIC IP address list

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

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

  • RE: The Database Mirroring endpoint cannot listen for connections due to the following error: '10049(The requested address is not valid in its context.)'.

    Arestas (7/6/2015)


    Well, no.

    Figured already that if i use the Ip of the networkcard (10.0.255.170) instead of a virtual ip (10.0.255.83) all work as a charm. Problem here is that...

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

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

  • RE: Stairway to AlwaysOn Level 7: Combining FCIs with Availability Groups

    Mike Good (7/1/2015)


    Interesting and well written, but I disagree with your slant.

    Thanks for the feedback

    Mike Good (7/1/2015)


    Much of this article is based on assumption that your DR instance is...

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

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

  • RE: Upgrading SQL 2005 32bit to SQL 2012 64bit - replacing single domain server

    the server you're putting sql server onto, is it a domain controller

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

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

  • RE: Swapping drive letters in SQL 2012 cluster

    I've moved what I would call the static folders before and yes theyre in registry keys in the sql instances hive. Why are you changing drive letters, why not retain...

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

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

  • RE: Separate one Availability Group to several AVs?

    if DB1, DB2 and DB3 aren't logically grouped then use separate groups for them. If theyre logically grouped, for instance all belonging to one application then use 1 ASO group.

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

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

  • RE: Pointing servername\instancename at an AG listener

    romanoplescia (7/3/2015)


    Howdy all

    I have a question about whether something is possible. I've started working at an organisation that has a sql 2005 cluster with a named instances on it, lets...

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

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

Viewing 15 posts - 1,936 through 1,950 (of 9,244 total)