Forum Replies Created

Viewing 15 posts - 1,996 through 2,010 (of 9,253 total)

  • RE: Logins & password

    ramana3327 (6/25/2015)


    Thank you.

    When you execute Revlogin

    How to get all logins @ same time. Looks we need each login name as parameter

    you'll find my script a lot easier 😉

  • RE: SPN issue

    Joy Smith San (6/24/2015)


    No Joie.

    setspn -S MSSQLSvc/[sqlinstance] [domain]\[svcaccount]

    I was running exactly the same command. Then it gave the message "Updated SPN...." but still logging this error in errorlog and...

  • RE: Issues with SQL Server 2008R2 Clustered Install on Server 2012

    Arthur.Bojilov 1605 (6/24/2015)


    Hello everyone!

    I hope you can help with the installation of SQL Server 2008R2 on Server 2012.

    Here is my setup.

    I am migrating a SQL 2008R2 two node physical cluster...

  • RE: New to clustering

    nzone7x (6/24/2015)


    Our environment has 4 nodes clustered, I do not know what you call the topology.

    the technology is known as Failover Clustering

    nzone7x (6/24/2015)


    4 nodes and each node has independent instances...

  • RE: SQL Server is listening on both ipv4 and ipv6 ips message in errorlog

    Joy Smith San (6/24/2015)


    Hi Experts,

    I installed two node sql server cluster annd during installation I configured for both IPV4 and IPV6.

    I can see the below messages logged in sql server...

  • RE: Logins & password

    which versions of sql server are you moving between?

    This is my script I use but wont work from sql2008 -> sql 2012 as the encryptor changed

    SET NOCOUNT ON

    SET CONCAT_NULL_YIELDS_NULL OFF

    DECLARE...

  • RE: Cannot remotely connect to sql server cluster with cluster name, works with virtual ip, 1433.

    Joy Smith San (6/25/2015)


    Hi,

    Able to access SQL Server cluster with "virtual IP,1433" from a remote application server.

    But it fails with the error "Server does not exist" when tried with...

  • RE: Replication/Mirroring which failover to apply on my scenario?

    alex_fajardo2002 (6/23/2015)


    Will the data changed on the mirror server be synchronized back to the principal server automatically? Or should I do it manually? I am very grateful to the advises...

  • RE: SPN issue

    Joy Smith San (6/20/2015)


    Joie Andrew (6/19/2015)


    What is the serviceaccount you are specifying to setspn? Is it a domain user account, a computer account, a virtual account? It sounds like you...

  • RE: Virtualizing a SQl 2008 2 Node Cluster

    hari.devadas 4119 (6/18/2015)


    Perry,

    We evicted Node 02 from the SQL 2008 Clusterand now on course for testing the P2V on Node 01 now.

    Why on earth have you done that at...

  • RE: SQL Server Failover - some disks are not brough online

    where is the storage presented from?

    have you checked the LUNs are properly exposed to both ESX hosts

  • RE: restore is failing

    charipg (6/17/2015)


    restore is failing with below error.

    Msg 60004, Level 16, State 1, Line 0

    Error starting process 'C:\Program Files\Quest Software\LiteSpeed\SQL Server\engine\SqlLiteSpeed.exe', Error: 0x3

    not getting any idea.any suggestion pls.

    Run a repair...

  • RE: Best Practice Drive Letter Question for SQL 2012 Cluster

    dan-404057 (6/22/2015)


    I have a 2 node Windows 2012 Cluster which runs a couple of SQL2012 FCIs. SAN backend for storage. I am using mount points for the Data/Log...

  • RE: AlwaysOn Read-Only Replica Routing Problem

    alex.sqldba (6/22/2015)


    Read Only Routing URLS are configured as follows:

    Ireland\Primary tcp://Ireland.dom.local:49891ALL

    Ireland\Secondary tcp://Ireland.dom.local:49841ALL

    This is only a small part of the config required, please supply the...

  • RE: Windows Server 2012 vs 2012 R2

    there are cluster updates between 2012 and 2012 R2, if it's a cluster then definitely 2012 R2

Viewing 15 posts - 1,996 through 2,010 (of 9,253 total)