Desinstall Via Protocol in Sql 2005 Cluster

Question

Desinstall Via Protocol in Sql 2005 Cluster

divadf

Grasshopper

Points: 19
More actions
June 6, 2008 at 12:35 am

#192017

My SQL server doesn´t start with this protocol installed (I don´t have VIA harware)
Solution:
I went into that option SQL server Configuration Manager, in there under SQL Native Client Configuration are Client Protocols and in there should be VIA, right click and disable.
But when the SQLserver service starts, VIA protocol change to enable.
Is possible desinstall VIA protocol from SQL installation in Cluster?
Thanks in advance

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

I don't believe it's possible to uninstall it. If you could, you'd never be able to connect that server to anything else.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Steve Jones - SSC Editor SSC Guru Points: 740332 More actions · Answer 2

I wouldn't mess with this. Uninstalling things from a cluster can be tricky, and I'm not sure it's worth messing with.

You don't want things enabled that you don't need, or even installed, but I'd be wary about removing them, especially something like this.

If you don't have an endpoint listening on here, you should be ok.

Chris Dieker Grasshopper Points: 16 More actions · Answer 3

divadf (6/6/2008)
My SQL server doesn´t start with this protocol installed (I don´t have VIA harware)
Solution:
I went into that option SQL server Configuration Manager, in there under SQL Native Client Configuration are Client Protocols and in there should be VIA, right click and disable.
But when the SQLserver service starts, VIA protocol change to enable.
Is possible desinstall VIA protocol from SQL installation in Cluster?
Thanks in advance

I have exactly the same problem, although I disable the VIA protocol, it's been set to "enable" as soon as I attempt starting the SQL Server, and this one then fails because of VIA.

Any idea to workaround this ?

Chris Dieker Grasshopper Points: 16 More actions · Answer 4

OK, found it.

You need to run the following command (with SQL2005):

[font="Courier New"]

cluster res "SQL Server" /removecheck: "Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLSERVER"[/font]

This then enables you to start your SQL Group. Once SQL Group is completely online, disable the VIA protocol on both nodes through SQL Server Configuration, and that should be it.