[MS Design Tools] - Catastrophic failure.....help!!

[RyanGlas]

For some reason I am having issues connecting to my SQL Database online. When I am finally able to view the tables in the database I go to "open table" and select "return all rows". Then out of nowhere I get a message saying. "An unexpected error happened during this operation. [MS Design Tools] - Catastrophic failure" Does anyone know what this means??

Also when I click ok on that another message comes up.


"The connection to SQL Server 'server name' has been broken. The connection to the SQL Server is broken. Do you want to try reconnecting to it?" I select yes and it's ok for a minute. The strange thing is that my internet connection is not broken during this time. This issue just started this morning. Any ideas on what is going on.

I do have the server pack 3 installed as well.

thank you!

 

[MaffewW]

Hi RyanGlas

My guess is that it is actually something to do with the internet connection not sqlserver, due to the fact that the sql connection is broken. You could have your internet connection go down even for a second when returning data and that may cause this error, and you may think that your internet connection is ok but [perhaps could be browsing cached web pages on your temp internet files.

maybe theres something you can download to monitor the line, even if to rule it out?

 

[RyanGlas]

Yah it has to be something like that. However, it only happens once I am trying to open a table and it never did this prior to the other day. Do you think that SQL is sending something somewhere on my hard drive when it is doing this that my network doesn't like and disconnects for a split second.

 

[MaffewW]

thats my best guess (though ram rather than the hard drive). If its a real issue do a google search on 'monitor internet connection', theres a few freeware tools which may help

 

[bratten]

Hi,

If you have a firewall, disable it and try to again to see if that´s the problem.

Regards

Andreas

 

[SQLBill]

I'm not sure disabling the firewall is the best answer. Check to see what port SQL Server is listening on (default is TCP 1433) and see if that port is being blocked at the firewall. If it is being blocked, you may have to request that your IP be allowed through on that port.

-SQLBill

 

[RyanGlas]

Well I checked the port and the firewall. There was a firewall on my connection. I allow the IP to go through that and also tried just disabling the firewall. I was still getting the same message. It's only when I try to open up a table or create a new table. I am able to rename the tables and import/export data on the server. Any other sugestions. My last resort is just wiping out everything and reinstalling XP. However, it is doing this on my desktop and laptop and that would just be a nightmare.

 

[SQLBill]

How many connections does your SQL Server allow at one time? Is it possible your connection is being KILLed because of too many connections? Is the SQL Server set for auto-close? It might be closing during the operation.

-SQLBill

 

[muddylemon]

I'm having the exact same problem - it just started this week. I've tried reinstalling SQL Server (just the client tools), reinstalling Windows 2k, reinstalling VS.Net, etc.

I've found a couple of other threads online that describe the problem - but no solutions! If anyone figures it out I'd love to know. Thanks.

 

[muddylemon]

AHA! Just one minute after i posted that I decided to just turn off my Norton Internet Security - and tada - it works just fine. Apparently, a change had occured... sometime last week that was blocking the MS Design Tools Dll's from venturing out past the walls of my computer.

Thanks for the tips above - led me in the right direction.