Forum Replies Created

Viewing 15 posts - 256 through 270 (of 1,366 total)

  • RE: Unable to change SQL Server 2014 Listening Port

    Hope this is the only instance on your machine.

    January 7, 2017 at 11:34 pm

    #1921261

  • RE: File Upload

    Eirikur Eiriksson (1/3/2017)

    VastSQL (1/3/2017)

    Thanks Guys.

    The file is uploaded to application server itself initially and then data gets inserted into multiple tables once the validation is complete. The validation checks in...

    January 3, 2017 at 3:48 am

    #1920318

  • RE: SQL Server Clustering

    balu.arunkumar (12/30/2016)

    Hi,

    I'm new to SQL server clustering. I have two nodes of active-passive clustering.

    Node1 IP : 10.XX.XX.XX

    Node2 IP : 10.YY.YY.YY

    I don't have access

    When intial stage SQL service is running...

    January 3, 2017 at 12:42 am

    #1920309

  • RE: File Upload

    Thanks Guys.

    The file is uploaded to application server itself initially and then data gets inserted into multiple tables once the validation is complete. The validation checks in many tables taking...

    January 3, 2017 at 12:36 am

    #1920308

  • RE: Cluster Node Down

    Perry Whittle (11/8/2016)

    most common reason ive seen for node dropping out of the cluster is co-stop on the ESX host, but normally get a different message.

    What is the current status...

    November 9, 2016 at 12:54 am

    #1911338

  • RE: Cluster Node Down

    Perry Whittle (11/7/2016)

    VastSQL (11/6/2016)

    Perry Whittle (11/4/2016)

    is this a virtual machine?

    Yes

    VMware?

    Hyper-V?

    How many virtual NICS are exposed to the cluster nodes?

    Have you run a cluster validation?

    Thanks Perry. It runs on VMWare,2 NICS...

    November 9, 2016 at 12:52 am

    #1911337

  • RE: Cluster Node Down

    goher2000 (11/7/2016)

    check if you can reach to your LOGONSERVER from nodes.. , type set on command line and look for LOGONSERVER and try to ping it with servername,...

    November 7, 2016 at 1:03 am

    #1910843

  • RE: Cluster Node Down

    goher2000 (11/6/2016)

    check you DNS server/network.

    Check for what?? The name is registered or not? We have checked that and its all there

    November 6, 2016 at 11:34 pm

    #1910830

  • RE: Cluster Node Down

    goher2000 (11/6/2016)

    Are you local admin on both nodes

    Yes

    November 6, 2016 at 11:33 pm

    #1910829

  • RE: Cluster Node Down

    goher2000 (11/4/2016)

    open these ports

    Windows Server Clustering –

    TCP/UDPPortDescription

    TCP/UDP53User & Computer Authentication [DNS]

    TCP/UDP88User & Computer Authentication [Kerberos]

    UDP123Windows Time [NTP]

    TCP135Cluster DCOM Traffic [RPC, EPM]

    UDP137User & Computer Authentication [NetLogon, NetBIOS]

    UDP138DSF, Group Policy [DFSN, NetLogon, NetBIOS...

    November 6, 2016 at 1:46 am

    #1910786

  • RE: Cluster Node Down

    Perry Whittle (11/4/2016)

    is this a virtual machine?

    Yes

    November 6, 2016 at 1:45 am

    #1910785

  • RE: Restarting SQL Server Instance from SSMS Error

    nickm_GR (10/14/2016)

    Just installed a new SQL Server 2014 instance. When I try to restart the sql server instance in SSMS by right-clicking and choosing restart, I get the following error:

    TITLE:...

    October 16, 2016 at 1:43 am

    #1906774

  • RE: Unable to connect to the Report Server from SSMS

    ramana3327 (10/8/2016)

    Hi,

    I tried both ways. Even RDP to the machine where the Report serverices are running also not working

    Did you try pinging to that server?

    October 9, 2016 at 12:37 am

    #1905546

  • RE: Unable to restore over a database consistantly

    Why cant you enable trace flags and find the root cause of Deadlock?

    Run the commands in same batch. Make the DB in Single_User with rollback immediate, then restore and then...

    October 9, 2016 at 12:36 am

    #1905545

  • RE: Deadlock on a "queued DELETE"

    Pingala (9/28/2016)

    I am not sure how many rows are in a particular "queued" delete operation. Does indexing help?

    Indexing might help. Post deadlock info here.

    Might be the reason that you...

    September 28, 2016 at 6:29 am

    #1903606

Viewing 15 posts - 256 through 270 (of 1,366 total)