Home Forums SQL Server 2005 Administering The configuration of the AdminConnection\TCP protocol in the SQL instance %% is not valid. RE: The configuration of the AdminConnection\TCP protocol in the SQL instance %% is not valid.

  • November 19, 2015 at 3:15 pm

    #1841206

    JeremyE (11/19/2015)

    Possible firewall blocking the traffic (software or hardware)? You could narrow it down to a SQL Browser issue if users cannot connect using SERVERNAME\INSTANCE but can connect using SERVERNAME,PORTNUMBER. If they can connect via the port number then it could be traffic is being blocked on UDP port 1434 (SQL browser port) or an issue with SQL Browser.

    Exactly what it was...I was just coming back to post my reply on my stupidity...

    I had looked at it initially and overlooked the person who set it up previously in testing had the wrong protocol.

    Flipped that and it worked.

    Thanks for the quick reply!

    Lee