Forum Replies Created

Viewing 15 posts - 271 through 285 (of 9,244 total)

  • RE: SPN for sql 2016 cluster

    Alejandro Santana - Tuesday, October 2, 2018 12:32 PM

    No, the 2 nodes don't need to have the same Service account.

    The...

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

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

    October 4, 2018 at 3:23 am

    #2008005

  • RE: Difference between AG && FCI

    joujousagem2006 1602 - Sunday, September 23, 2018 7:38 AM

    Hi,
    what  is the difference between AlwaysOn availability groups and AlwaysOn Failover cluster instances
    thanks

    please see...

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

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

    October 1, 2018 at 5:50 am

    #2007479

  • RE: Always on with an SQL Cluster and 2 nodes

    Joe Zonum - Friday, September 28, 2018 12:19 PM

    Hello all,

    I have searched everywhere and can't seem to find an example of setting...

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

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

    October 1, 2018 at 4:29 am

    #2007471

  • RE: Script to View Server Role Permissions

    Phil Parkin - Thursday, September 27, 2018 6:17 AM

    I have a script which creates a server role called dbareadonly. Here is part...

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

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

    October 1, 2018 at 4:27 am

    #2007470

  • RE: Failover - AG issue

    sizal0234 - Wednesday, September 26, 2018 11:58 AM

    Hi All,
    Issue: We have 2 instances say A01 AND A02.
    The client has network issue...

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

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

    October 1, 2018 at 4:24 am

    #2007469

  • RE: AlwaysOn Listener registering 2 DNS records

    SQLAddict01 - Sunday, August 19, 2018 10:56 AM

    We have a requirement that we are not allowed to make any changes in the...

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

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

    September 6, 2018 at 5:56 am

    #2004686

  • RE: Always on Install

    caz100 - Thursday, August 23, 2018 1:05 AM

    Hi 
    I am following these notes for always on install and have some basic queries:

    http://www.sqlservercentral.com/blogs/ganapathis-mssqllover/2017/02/20/alwayson-availability-groups-step-by-step-setup/

    For...

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

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

    September 6, 2018 at 5:51 am

    #2004683

  • RE: Setup 2 node windows cluster

    caz100 - Tuesday, August 28, 2018 3:26 AM

    HiWe have a requirement to setup a windows 2 node failover cluster with sqlserver installed outside...

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

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

    September 6, 2018 at 5:49 am

    #2004682

  • RE: Mirroring Failover

    Admingod - Thursday, August 30, 2018 10:56 AM

    I have question, 
    Server A is mirrored to Server B when the failover is done server...

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

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

    September 6, 2018 at 5:48 am

    #2004681

  • RE: SQLServr.exe cannot find ERRORLOG error(17058)

    elea.grig - Saturday, August 25, 2018 4:05 AM

    While running SQLServr.exe -sMSSQLSERVER command I get the error pictured above. How...

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

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

    September 6, 2018 at 5:43 am

    #2004678

  • RE: DAC connection vs single-user mode

    elea.grig - Saturday, August 25, 2018 3:19 AM

    Are sqlcmd -A and SQLServr.exe -f doing the same job? What is the difference between...

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

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

    September 6, 2018 at 5:41 am

    #2004677

  • RE: SQL Migration

    Sue_H - Tuesday, September 4, 2018 2:11 PM

    Andrew.weckermann - Friday, August 31, 2018 3:08 AM

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

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

    September 6, 2018 at 5:36 am

    #2004676

  • RE: Why QUOTENAME is important

    Good article, important to remember a simple check of permissions catches sql injection. Why give an account create table in the first place

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

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

    August 15, 2018 at 12:11 am

    #2001778

  • RE: SQL 2017 FCI with File Share Witness - permissions?

    robnsilver - Tuesday, July 3, 2018 1:01 PM

    I think you only need to grant permissions on the file share to the cluster...

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

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

    July 9, 2018 at 6:54 am

    #1996774

  • RE: Basic Availability Group Licensing ?

    mark 52160 - Friday, June 22, 2018 4:15 AM

    Hi, just wondering what the situation is re licensing with Basic availability groups in...

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

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

    July 5, 2018 at 4:45 am

    #1996371

Viewing 15 posts - 271 through 285 (of 9,244 total)