June 6, 2006 at 7:28 am
Hi
I have a SQL 2005 server I am testing on, and I tried to apply SP1 onto it.
I had a problem when I couldn't remember the authentication (sa password).
So cancelled in the proper way. Now my server won't start. I get the "could not spawn FRunCM error in eventvwr, and I believe this is related to me having the VIA protocol enabled.
So I believe I need to disable this protocol, but I can't find it.....
Please can anyone help?
Many Thanks
June 9, 2006 at 8:00 am
This was removed by the editor as SPAM
May 14, 2007 at 9:55 am
To disable the VIA protocol go into the SQL server configuration manager on the server and look under network configuration -> protocols. For more info look at this ms article:
http://blogs.msdn.com/sql_protocols/archive/2005/10/31/487090.aspx
October 15, 2007 at 9:38 am
I also cannot start SQL Server database engine and have the same error with message SQL Server could not spawn FRunCM thread. However, VIA protocol is not enabled.
A previous error in the log states that 'TDSSNIClient initialization failed with error 0x2740 status code 0x1.
What does that mean??
October 17, 2007 at 7:01 am
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.
October 17, 2007 at 8:35 am
As it turned out, a Windows Server 2003 security update changed the firewall settings. To reset, right click on your internet connection and select the Advanced tab, then Settings button, then the Exceptions tab. Click Add port. For name: SQL Server, port: 1433, TCP selected. Click OK. Click Add port. For name: SQL Server Browser, port: 1433, UDP selected. Click OK until you are out of the program. Worked for me.
January 2, 2008 at 11:22 pm
I have disabled the VIA services but still not able to start sql server 2005
March 12, 2009 at 4:03 pm
Under SQL Server 2008, I had to disable VIA in two locations before SQL Server would start.
In SQL Server Configuration Manager:
1. SQL Native Client 10.0 Configuration -> Client Protocols
2. SQL Server Network Configuration -> Protocols for Network MSSQLSERVER
March 12, 2009 at 4:03 pm
Under SQL Server 2008, I had to disable VIA in two locations before SQL Server would start.
In SQL Server Configuration Manager:
1. SQL Native Client 10.0 Configuration -> Client Protocols
2. SQL Server Network Configuration -> Protocols for Network MSSQLSERVER
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply