Forum Replies Created

Viewing 15 posts - 2,881 through 2,895 (of 9,241 total)

  • RE: The Microsoft JET Database Engine cannot open the file

    myoda (10/7/2014)


    I understand what $ means in the UNC path

    What does it mean?

    myoda (10/7/2014)


    If its a permission issue, why does it work from the server where SQL server 2012 is...

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

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

  • RE: The Microsoft JET Database Engine cannot open the file

    sounds very much like a permissions issue. Do you understand what the $ means in the UNC path?

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

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

  • RE: SQL Server Authentication Error

    HanShi (10/7/2014)


    If you (or the application) are not able to use Windows accounts (i.e. Windows integrated security), you need to change the authentication setting of the SQL instance to "mixed...

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

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

  • RE: DR Recovery Back to Primary DC

    Talib123 (10/3/2014)


    Scenario

    AG failover to DR Node.

    Setup

    Server A – Primary Datacentre

    Sever B – Primary Datacentre

    Server Z – DR Datacentre

    Primary DC down. Manual Failover to DR Datacentre.

    Question.

    At the point of...

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

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

  • RE: SQL Server Authentication Error

    the message details the problem exactly. The instance is configured for Windows auth only, can you login with a windows account?

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

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

  • RE: Multi-Site Always On Failover Cluster Question for Experts

    Libby1981 (10/6/2014)


    Good Morning All:

    I have a question for SQL experts.

    We are implementing a multi-site (Windows Server Failover Cluster) WSFC to enable Always On between our primary and DR...

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

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

  • RE: Database Mirroring-What Do I Backup?

    plamannkathy (10/4/2014)


    Anyway I just need an answer to what type of maintenance do I provide for these databases?

    The system databases on each instance would be advisable. The principal database needs...

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

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

  • RE: How to apply patches in SQL server 2005 Active/passive cluster

    For SP4??

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

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

  • RE: How to apply patches in SQL server 2005 Active/passive cluster

    solomon.jernas (10/2/2014)


    SQL SERVER patches, not windows.

    Yes but which sql patches?

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

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

  • RE: default schema of windows group user

    He may be a member of another group

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

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

  • RE: default schema of windows group user

    Ok seems its changed in 2012 on, if there's a database user and a default schema is set then that is used. If not set then it's from the group,...

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

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

  • RE: default schema of windows group user

    thats what i said, check the user 😉

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

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

  • RE: How to apply patches in SQL server 2005 Active/passive cluster

    solomon.jernas (10/2/2014)


    HI

    How to apply patches in Sql server 2005 Active/passive cluster ,what are the steps need to be follow..

    We will be initiate production server..

    Please anyone help to us..

    Regards,

    solomon

    Which patch(es)...

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

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

  • RE: default schema of windows group user

    you dopn't set a default schema for a windows group, look at the default schema for the user

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

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

  • RE: AlwaysOn AG replicating much slower than mirroring

    DudeGuy (9/30/2014)


    I'm setting up AG replication over our WAN (1GB MPLS). Using sql stress, AG replication quickly falls behind. Network throughput plateaus at ~14Mbs.

    The problem ISN'T NETWORK

    using conventional mirroring, the...

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

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

Viewing 15 posts - 2,881 through 2,895 (of 9,241 total)