Starting last Friday developers starting having trouble with in some cases SSIS and in others SSMS.
For instance one developer would start BIDS and a devenv.exe process would start but it would not load the application for 30 minutes to an hour.
I had them unplug the network cable and BIDS launched immediately.
Another developer can launch BIDS but not SSIS. A ssms.exe process starts for every attempt but the SSMS Application does not launch.
I had the developer disconnect the network cable and SSMS started immediately.
I have the same problem with BIDS(SSIS) on a Windows Server.
If I run an SSIS Package I get unusual errors, SSIS can't connect to Server even after I have tested the connection, etc.
A Manager can open SSIS but it just freezes.
Some developers are not affected at all.
I have check for something common that is installed on the PC's/Server but I could not find anything.
My thought would be to disable the service(s) but that is not applicable in this situation.
I suspect some sort of network tool that is interfering with SQL Server.
I have checked the Event Viewer but there are not any entries.
Any help would be greatly appreciated.
For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/