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
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.
Wednesday, August 29, 2012 7:20 PMModerator
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
Sethu Srinivasan [MSFT]