SQL Server Error with CE filter

  • 5
  • Problem
  • Updated 4 years ago
  • Solved
I keep getting this error when I try to connect to my SQL Server (2012) using SQL Server Management Studio (version 2012, Express with advanced services, 64 bit).
I am using Windows 7, I have Visual Studio 2012 installed... if you need specs I can get them to you.

http://serverfault.com/questions/4230...

Once uninstalled, without even rebooting, it worked fine.

Any ideas? Other posts say there is a big difference between the .NET Framework 4.0 and 4.5. Is that it?

:-Dan
Photo of Dan Watkins

Dan Watkins

  • 14 Posts
  • 0 Reply Likes
  • frustrated

Posted 6 years ago

  • 5
Photo of Chad

Chad, Official Rep

  • 121 Posts
  • 10 Reply Likes
Dan,

I'm going to have to consult some brains bigger than mine on this question. Please give me some time while I circulate your issue amongst some of our developers and networking gurus.

Two questions for you: what version of Covenant Eyes are you using? Right click on the Eye icon in the task bar and then click on About Covenant Eyes to find the version number. Also, what antivirus, firewall or other filtering software is installed?

Hopefully, I'll have some info for you in a day or two.

Chad Hadfield
Photo of Drew Clauson

Drew Clauson

  • 6 Posts
  • 1 Reply Like
I'm having the same issues. Are there any updates on this?
Photo of Dan Watkins

Dan Watkins

  • 14 Posts
  • 0 Reply Likes
CE version: don't have it currently, but it was whatever was the most current when I submitted this request. (For Windows 7, 64 bit)

Microsoft Forefront:
Forefront Endpoint Protection Version: 2.0.657.0
Antimalware Client Version: 3.0.8107.0
Engine Version: 1.1.9302.0
Antivirus definition: 1.147.1566.0
Antispyware definition: 1.147.1566.0
Network Inspection System Engine Version: 2.1.8904.0
Network Inspection System Definition Version: 17.36.0.0
Photo of Drew Clauson

Drew Clauson

  • 6 Posts
  • 1 Reply Like
After calling tech support, I found that moving to the beta "WFP" version resolves this issue.
Photo of Alaina

Alaina

  • 259 Posts
  • 8 Reply Likes
Thanks, Drew. That's excellent!

Dan, that version would be the one at the top of the downloads page. It currently says "Covenant Eyes for Windows 8 (Beta)" but it works on XP and up. They're in the process of updating that title and the information page attached to it.

If you decide to try it, could you let us know if it fixes the problem for you?
Photo of waltricejr

waltricejr

  • 1 Post
  • 0 Reply Likes
I experienced this same issue, glad to hear it may be fixed in the Beta.

Microsoft made code changes in the networking for ADO, which breaks with Winsock Base and Layered Service Providers (of which Covenant Eyes is one) that are not compliant with the newer file handles.

Technical details here: http://support.microsoft.com/kb/2568167
Photo of Alaina

Alaina

  • 259 Posts
  • 8 Reply Likes
Thanks, waltricejr! That sounds about like our VP of Technology's response when I mentioned this thread to him after my last post.

The Beta moves us out of the LSP which he agreed was where the problem is most likely occurring, so any version of Covenant Eyes 5.0 or above should solve the conflict.

If you're still having a problem after upgrading, please let us know. Knowing what anti-virus you're using would be helpful as well.
Photo of waltricejr

waltricejr

  • 1 Post
  • 0 Reply Likes
This is broken again in the new beta, 5.0.3.290. Same symptoms as before.
Photo of Dan Watkins

Dan Watkins

  • 14 Posts
  • 0 Reply Likes
I can confirm waltricejr. Mine is broken still, with same version of CE, 5.0.3.290.

:-Dan
Photo of Cedric

Cedric

  • 1 Post
  • 0 Reply Likes
Still broken with CE Beta 5.0.3.698
Photo of John Wa

John Wa

  • 88 Posts
  • 3 Reply Likes
Any updates on this issue please? I can't install CE on my office laptop used for programming because of this bug.
Photo of Chad

Chad, Official Rep

  • 121 Posts
  • 10 Reply Likes
Hello John,

My recommendation would be to try the latest Windows 8 download (v.5.0.3.310) available on the downloads page in My Account on the Covenant Eyes website.

Even if you are not using a Windows 8 computer, this version will work on your Windows machine as long as it is at least XP. This version does not rely on the LSP stack.

Please let us know how this works for you. If you need any assistance please call our Customer Support Team toll-free at 877-479-1119.

Chad
Photo of John Wa

John Wa

  • 88 Posts
  • 3 Reply Likes
I installed version 5.0.3.310, and when attempting to login with SQL Server Management Studio 11.0.3128.0 to our SQL server on Windows Azure (remote address), I got this error:

TITLE: Connect to Server
------------------------------

Cannot connect to *************.database.windows.net.

------------------------------
ADDITIONAL INFORMATION:

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.) (Microsoft SQL Server, Error: 258)

For help, click: http://go.microsoft.com/fwlink?ProdNa...

------------------------------

The wait operation timed out
Photo of John Wa

John Wa

  • 88 Posts
  • 3 Reply Likes
Any clue why this bug still isn't fixed in the beta version 5.0.3.310? Is there any way possible to get CE to work on a computer using SQL Server Management Studio? This is obviously very difficult for those of us who want accountability, but can't because we use certain programming tools.
Photo of Matt Gardner

Matt Gardner

  • 5 Posts
  • 0 Reply Likes
So, I had a version of CE installed that let me use SQL Server Management Studio, but I had to uninstall CE while I was on a trip to China because of their firewall issues. When I came back, I installed the Windows 8 most current beta version (5.0.4.49), and now I can't use SQL Server Management Studio. I installed a CE version that allowed use of the SQL Server Management Studio back in probably April. Now it doesn't work and I stumbled across this forum.

Is there any way to get my hands on that previous version? It would probably be version 5.0.2.414, based on the release notes. Looks like tech support is down for today because of weather issues, so I'll give them a call tomorrow and let you know what I can find.
Photo of Drew Clauson

Drew Clauson

  • 6 Posts
  • 1 Reply Like
I put a copy of the installer that I'm using successfully on dropbox: https://www.dropbox.com/s/ibtpgdh22y6...

Note that I'm on Windows 7 64 bit. Didn't know if you are on Window 8 or not.
Photo of Matt Gardner

Matt Gardner

  • 5 Posts
  • 0 Reply Likes
Thanks, Drew! I'll install it right now. I really appreciate it!
Photo of Matt Gardner

Matt Gardner

  • 5 Posts
  • 0 Reply Likes
Drew, I got it installed and it works just as beautifully as if I hadn't gone to China.
Photo of Drew Clauson

Drew Clauson

  • 6 Posts
  • 1 Reply Like
I have the file for CE 5.0.2.414 that I can forward to you that works for me. I put it in my public dropbox for you.

https://www.dropbox.com/s/ibtpgdh22y6...
Photo of Drew Clauson

Drew Clauson

  • 6 Posts
  • 1 Reply Like
Meant to reply to Matt Gardner's note on this one, sorry.
Photo of John Wa

John Wa

  • 88 Posts
  • 3 Reply Likes
I also installed this version, and SQL Management Studio now connects successfully. I've finally got CE running on my development laptop, thank you so much!
Photo of Chad

Chad, Official Rep

  • 121 Posts
  • 10 Reply Likes
Hi Matt & Drew,
If either of you needs help downloading version 502.414 please feel free to call our Customer Service Team at 877.479.1119. Our offices are closed today (1/6/14) due to weather, but we should be in the office on tuesday.

Chad
Photo of Matt Gardner

Matt Gardner

  • 5 Posts
  • 0 Reply Likes
Thanks, Chad. I grabbed the version from Drew and it works well.
Photo of John Wa

John Wa

  • 88 Posts
  • 3 Reply Likes
Ugh, I wrote last night that version 5.0.2.414 allowed SQL Management Studio to work, which is true. But what I found is that now, I cannot run a solution from Visual Studio 2012. When I click to start the project in debug mode, I get this error:

"Windows Azure Tools for Microsoft Visual Studio

There was an error attaching the debugger to the IIS worker process for URL 'http://127.255.0.0:82/' for role instance 'deployment22(1564).MyApps.Web.WindowsAzure.Local.MyApps.Web_IN_0'. Unable to start debugging on the web server. Unable to connect to the web server. Verify that the web server is running and that incoming HTTP requests are not blocked by a firewall."

Grr! Why can we not get CE to work with a development computer? I have intentionally not learned how CE works, but it seems strange that we have so many problems with these development programs on a computer that has CE installed.

CE, how can we get this working for all these development programs?
Photo of Matt Gardner

Matt Gardner

  • 5 Posts
  • 0 Reply Likes
Hi John.

I don't use Windows Azure for development; I just develop locally using a debugger attached to a local IIS process. Here's what I think is happening, although I don't know how to fix it:

-CE hijacks all HTTP requests and forces them to go through the logger so that everything is monitored

-Your local debugger is trying to connect directly to the IIS process on Azure and thus trying to bypass CE, which CE will not allow

CE developers need to allow exceptions for certain debugging programs, although if not done right, it could open a can of worms I'd rather not deal with...

Is there a way for you to develop locally and then upload your stuff to Azure later?

Just a thought.
Photo of John Wa

John Wa

  • 88 Posts
  • 3 Reply Likes
Matt, thanks for the informative reply. Didn't realize that's what Azure was doing. Our solution uses databases on Azure, for both Dev and Production. So we are tied to it. I can only assume this will become more and more popular as cloud infrastructures become more prevalent, and those who develop on those infrastructures will evidently not be able to use CE. Sad, but I guess it is what it is until CE finds a solution. Thank you.
Photo of Drew Clauson

Drew Clauson

  • 6 Posts
  • 1 Reply Like
Ditto to Matt - I don't use Azure, but do use local IIS debugger so it's probably something related to Azure directly. It's interesting to know that CE uses Azure, although like Matt, the less I know about the tech behind it the better.
Photo of Alaina

Alaina

  • 259 Posts
  • 8 Reply Likes
Hi, guys!

I saw your discussion and thought that our developers would find it interesting, which they did. Regarding the previous conversation, we don't track or filter HTTP traffic on localhost, but if the debugger is using the network to communicate with your web service by some other protocol/port, Covenant Eyes might be in the way.

John, our guys would be interested in coordinating with you to run a Wireshark session on your computer to see what's going on. Is that something that you would be up for?
Photo of John Wa

John Wa

  • 88 Posts
  • 3 Reply Likes
Hope the conversation is helping! Sure thing. Let me know how we need to go from here.
Photo of John Wa

John Wa

  • 88 Posts
  • 3 Reply Likes
I have no idea what your guys' availability is, but I could hop on a meeting tomorrow, just about any time after 10:30am CT or so.
Photo of Alaina

Alaina

  • 259 Posts
  • 8 Reply Likes
Thanks, John! I am checking with them on their availability.

Also, what version of Windows are you running? It sounds like they might have an idea of a fix for you, but it depends upon which version of Windows you're running.