Forum Replies Created

Viewing 15 posts - 2,971 through 2,985 (of 9,244 total)

  • RE: Error 18456: Login failed for user '<user_name>'

    have you checked this is not a keyboard issue. Since " and @ are reversed (amongst other chars) between english and US keyboards this can cause issues.

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

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

  • RE: SQL Server Agent Service Account Permissions

    what other errors do you see in the windows app event log?

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

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

  • RE: Mirror partner timeout

    no, it is configured at the mirror session level

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

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

  • RE: Sql Server File Placement

    if you're unable to split tempdb log from tempdb data files they should go on the same drive, this is also the default offered in the sql server installer

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

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

  • RE: Add node in a cluster -- Network configuration issue

    gary1 (9/8/2014)


    Hi ,

    I have installed SQL Server 2012 on Node1 successfully and trying add node on Node2 and its failing with below message. Please advise. I attached the screen shot.

    Here...

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

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

  • RE: Building Microsoft cluster in VM VS using VMware vmotion

    Clustering guest machines does indeed pose some restrictions when you use shared storage. In a stable virtual infrastructure, I would be more inclined to rely on VMWare DRS and VMotion...

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

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

  • RE: Is it *possible* to build a *three* node SQL Server 2012 cluster on VMware virtual machines?

    shew (9/8/2014)


    We are getting mixed information from various sources while researching the possibility of creating three node SQL Server clusters on VMware virtual machines.

    Is it *possible* to build a *three*...

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

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

  • RE: Error 18456: Login failed for user '<user_name>'

    par.anthony (9/5/2014)


    machine, or from my application code.

    The error I get is 'Login failed for user '<user_name>'

    please supply the state and severity id from the error message

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

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

  • RE: Log shipping planned failover with mirroring configured.

    dinsab11 (9/6/2014)


    I have log shipping and mirroring configured, now I need to failover (planned) log shipping. is there best steps to follow and keep mirroring in sync?

    Yes there are steps...

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

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

  • RE: Destroy cluster

    Scorz (9/5/2014)


    So I can evict the passive node from the sql and windows cluster and re-install a stand alone instance on the former passive node?

    If you evist the node the...

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

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

  • RE: Destroy cluster

    Scorz (9/4/2014)


    We have an active\passive cluster that needs to be dismantled but we want to keep the SQL instance. Can I just remove each node from the sql cluster...

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

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

  • RE: Changing server, user name and password

    changing the computer name will essentially change the sql instance name, this is likely the issue you are having. Supply the new servername or the IP address and retry the...

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

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

  • RE: Transaction Log Full

    sounds like the log is not large enough to cope with the longest active transaction 😉

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

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

  • RE: upgrade 2012 from 2008 to add to always on solution

    do you want the AlwaysOn solution to reatin a failover cluster instance as a replica? There are restrictions by doing this 😉

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

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

  • RE: upgrade 2012 from 2008 to add to always on solution

    an upgrade is perfectly viable as long as it's between supported editions. What is the state of each node for cluster membership? Is the current instance a Failover Cluster Iinstance...

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

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

Viewing 15 posts - 2,971 through 2,985 (of 9,244 total)