Thursday, September 18, 2008 7:05 PM
My machine cannot connect to any of our SQL Server 2005 boxes using SQL Native client. The Microsoft OLE DB Provider for SQL Server works fine. I can also use other machines to connect to the same servers without issues, so I'm sure the problem is specific to my machine. Here's the error I get:
Could not retrieve table list.
Login timeout expired
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. SQL Network Interfaces: Error getting enabled protocols list from the registry [xFFFFFFFF]. (Microsoft SQL Native Client)
I'm running Vista SP1. My SQL Native Client is SP2 CU8. So are the servers. I have Visual Studio 2008 Pro installed.
Here's the other info from the MSSMS About page:
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.3053
Operating System 6.0.6001
Any ideas on how to fix this?
Friday, September 19, 2008 4:56 PMModerator
This looks like a registry is corrupted.
ProtocolOrder should be REG_MULTI_SZ with default
ProtocolsSupported should be REG_MULTI_SZ with default
(make sure each protocol uses one line)
Or, you can try uninstall/reinstall SNAC.
Friday, September 19, 2008 5:03 PM
That fixed it!
Tuesday, December 09, 2008 4:23 AMI had an issue that was fixed by your posted solution. Thank you so much!