What are the challenges you face when working across database platforms? Take the survey

SmartAssembly times out connecting to Database

I get a error more frequently now when using msbuild to obfuscate our builds here's the snippet from the log, there seems to be no problems with the SQL box itself and we have a ping checker and SQL connect/disconnect with out any problems. Also I cant seem to find the timeout settings (look like they are set to 2 seconds) can I change this anywhere?

[MSBuild output] Messaging.proj(14,3): error : SmartAssembly build failed:
[MSBuild output] Messaging.proj(14,3): error : Unable to connect to the SQL database:
[MSBuild output] Messaging.proj(14,3): error : 'Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=1702; handshake=1174; '
[MSBuild output] Messaging.proj(14,3): error :
[MSBuild output] Messaging.proj(14,3): error : Connection string:
[MSBuild output] Messaging.proj(14,3): error : Server=VS004-SQL2008;Integrated security=SSPI;database=master;Connect Timeout=2
[MSBuild output]

Anyone else seen this? Really annoying!


Sign In or Register to comment.