Visual Studio 11 beta installation disabled my abillity to connect remote MS SQL Server but not local databases by SPAvidin

I was having this problem when I had .NET framework 4.5 installed on my workstation with PANDA antivirus. When I uninstalled PANDA problem is resolved.

Moca.io Proxy was causing trouble for me. Uninstalled and all working fine now. ("remove non-IFS LSP")
I had same issue with SSMS 2012 but all worked fine on SSMS 2008 on the same box connecting to the same remote server.

I had the same issue and tried the same thing as [zpittman]
and I found that [Sendori.dll] got installed somehow and that was using LSP.
So after removing this Sendori and It works great.

Thank you [zpittman]

I have the same Problem.
I think its not a problem of VS2012. Just of .net4.5.
Everythink works fine if I work with VS2012 but with .net4.0 for my Project.
I can reproduce the error on every Client PC with .net 4.5 installed.
Please help.

I had this same issue and resolved it, here is how:
netsh winsock show catalog > lsp.txt

I opened the txt file that was created and found a fullsock.dll entry and that dll didn't exist in the directory the entry specified (old antivirus maybe?).

I used this open source program to remove the entry and was back in business :)

http://www.cexx.org/lspfix.htm

i had the same issue, i use "netsh WinSock Show Catalog" command to determine if a non-IFS BSP or LSP is installed on my computer, i found IDM, after i remove that everything goes fine.
follow this linke http://support.microsoft.com/kb/2568167 and go to More Information section for information about how to use the netsh command and find out which non-IFS is installed.

In my case i uninstalled Panda virus detection software and now it works normally. I can connect remote databases. May be some virus scanner could cause the problem.

Thanks!

I was having this same issue with the Visual Studio 2012 RC, but after following the workaround instructions I found an LSP provider installed by a program called StationRipper by Ratajik Software. Once I uninstalled StationRipper, everything started working normally again.

Thanks!

Thank you for reporting this issue. We investigated the issue and most likely the cause of the problem is non-IFS BSP/LSP installed on your machine interfering with our call to Winsock. Once installed BSP/LSP provider can intercept and modify inbound and outbound Internet traffic. Please refer to the following KB article for details and instruction on how to identify if you are running into the same issue: http://support.microsoft.com/kb/2568167.

For the background, the existing synchronous API code path was modified in .NET Framework 4.5 to add asynchronous support in ADO.NET. Ideally it would have been better if the modification to the existing code path could be avoided, but to add asynchronous support the change on the existing code path was inevitable.

If removing non-IFS BSP/LSP solved your issue, it will be helpful for us if you can share the information of the non-IFS BSP/LSP. If you don’t have an issue giving the information to us, please send us an e-mail with the information to adonet45beta@microsoft.com. We will share the list with Windows networking team so that they can follow up with the provider companies to see if they can move toWindows Filtering Platform which is a new interface introduced in Windows Vista.

If you don’t have non-IFS BSP/LSP on your machine or still have connectivity issue even after removing the provider, please let us know and we will do further investigation.

Thanks again for reporting this issue and if you have further questions, please don’t hesitate to contact us.
Thanks,

Young Gah Kim
Development Lead
ADO.NET Managed Providers and DataSet Team

Sorry that was TrustServerCertificate

I tried yesterday changing the Encrypt=True in vs 2010 and if I left the TrustCertificate=False I recieved an invalid certificate chain error. When I enabled TrustCertificate=True it connected.

Do you mean in 4.0 or 4.5?

Hi,
Thanks for reporting this issue. We are working on reproducing this issue in our lab but having difficult time. For those who have this issue and was successfully roll back to .NET Framework 4.0, would you please see if you can connect with encryption on? This information will help us to narrow down the issue.

Thanks,

Young Gah Kim
Development Lead
ADO.NET and DataSet Team

I have had the same issue when installing VS11. It is repaired after uninstalling VS11 and Net 4.5 and Repairing VS2010. After getting everything repaired, I installed JUST NET 4.5 from the VS11 Premium ISO image and had the same issues when connecting to a remote SQL express database so I'm guessing it has more to do with NET 4.5 than with VS11. End result is still can't use either.

I am having the same issue. For a remote server inside my network I have control over I can enable Named Pipes and it works fine if I change the network library to Named Pipes. This is not a solution however because it does not help on hosted networks where I cannot force them to enable named pipes.

This has also affected my VS 2010 installation.

Until now, there is no good solution.
The following post address the same issue:
http://social.msdn.microsoft.com/Forums/en-NZ/vssetup/thread/2d11b6f9-3ada-4682-b643-c721a97af4ba

Solution until now: uninstall .Net 4.5 beta or Vs 11Beta
THIS IS NO SOLUTION!

I like to use .net 4.5 (async, await ...) and VS 11.
Hopefully someone has an better idea.

I have the same issue - is there any progress on this?

I have attached the logfile of the following procedure...

- started VS11 beta
- go to SQL menu -> add sql server...
- selected my remote SQL server
- windows authentication
- pressed connect
- time out error...

message...

===================================

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.) (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=258&LinkId=20476

------------------------------
Server Name: xxxx\SQLEXPRESS
Error Number: 258
Severity: 20
State: 0


------------------------------
Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean& marsCapable)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject, Boolean withFailover)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.VisualStudio.Data.Tools.SqlEditor.DataModel.SqlConnectionStrategy.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.VisualStudio.Data.Tools.Package.Explorers.SqlServerObjectExplorer.ConnectionService.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Also, could you try running Visual Studio with the /log option? This might help us catch something.

Devenv.exe /log "C:\My Files\MyLog.txt"

http://msdn.microsoft.com/en-US/library/ms241272(v=VS.80).aspx


-Janet Yeilding
janety@microsoft.com

Sorry you're running into this issue. Can you help me understand the repro better? Are you connecting via Server Explorer or SQL Server Object Explorer? And you only experiencing this issue with remote servers?

Thanks,
Janet Yeilding
janety@microsoft.com

I also had this same issue. It was not resolved until I uninstalled VS 11 AND .NET Framework 4.5.

Thanks for your feedback. We are rerouting this issue to the appropriate group within the Visual Studio Product Team for triage and resolution. These specialized experts will follow-up with your issue.

Thank you for your feedback, we are currently reviewing the issue you have submitted. If this issue is urgent, please contact support directly(http://support.microsoft.com)