SMO 2012 Server Connection very slow until you run IE one time

Answered SMO 2012 Server Connection very slow until you run IE one time

  • Wednesday, August 29, 2012 4:28 PM
     
     

    There seems to be an issue with SMO 2012 if the user has never run IE on the machine.

    We have written a simple program that declares (but does not open) a connection with the following code

        Private Sub foo()

            Dim conn As New Microsoft.SqlServer.Management.Common.ServerConnection

        End Sub

    On multiple Server 2008r2 machines running Remote Desktop Services we have tested this code.  If a user has never run IE, this code consistently takes 10-15 seconds.  If the user runs IE once (they do not have to go through any of the setup wizard) and then closes IE, this code takes less than .5 seconds.

    Can anyone explain why this is?

    Is there any thing we can do in our software to fix the issue?  Currently we are asking our customers to run IE one time.

    Thanks,

    -Todd

All Replies

  • Wednesday, August 29, 2012 7:20 PM
    Moderator
     
     Answered

    Could you please report this issue to SQL Server  feedback https://connect.microsoft.com/SQLServer/Feedback

    Please include additional details like

    1) OS version

    2)  SQL Server version, SQL tools version

    3) is this issue reproducible on interactive desktop session / through RDP session only

    Thanks

    Sethu  Srinivasan  [MSFT]

    SQL Server