Timeout expires when deploying assemblies in SQL Server 2005 June CTP

I am encountering a timeout expired error when deploying a .NET assembly in SQL Server 2005 using Visual Studio.NET. I already enabled SQL Server for CLR. Whenever I run the CREATE ASSEMBLY command in SQL Management Studio, my query just ends up executing without stopping.

Can anybody help?

[294 byte] By [bass_player] at [2008-2-8]

«« Using VSTS Beta 2 - Strange error COM+ in Add-in
»» Adding an image to a Crystal Report from a memorystream.

# 1

Which build of VS are you using? Also how large is your assembly?

MilindLele at 2007-9-9 >

top of Msdn Tech,SQL Server,.NET Framework inside SQL Server...

# 2

I am using VS.NET 2005 Beta 2 with SQL Server 2005 June CTP. The assembly is pretty small - a mere 7KB. I am running everything on a single machine for testing purposes.

bass_player at 2007-9-9 >

# 3

Did you try increasing the timeout? Project Properties -> Database -> Connection String -> Browse -> Add New reference -> Advanced and then change the timeout.
Also click on test connection to ensure that the connection is to a valid database and SQL Server is currently running.

Thanks,
-Vineet.

VineetRao-Microsoft at 2007-9-9 >

# 4

I already did all of these. The connection is successful when I clicked the Test Connection button, I changed the Connection Timeout to a very high value, I Deployed the assembly usnig both VS.NET 2005 Beta 2 and SQL Server Management Studio but still come up with the same error.

bass_player at 2007-9-9 >

# 5

Can you please change the time out value from Tools->Options->Database Tools->Query and View Designers?

This typically happens when the server does not respond in time -- for whatever reason. Changing the timeout value here (rather than for the connection) will allow VS to wait longer before giving up. :-)

Let me know if that helps.

MilindLele at 2007-9-9 >

# 6

I've already done this but still of no luck.

bass_player at 2007-9-9 >

# 7

Can you try connecting to some other SQL Server or Some other database? Also, try to add a SQL Server connection in server explorer and do simple things like adding a T-SQL stored procedure from server explorer.

Thanks,
-Vineet.

VineetRao-Microsoft at 2007-9-9 >

# 8

You know what, I just restarted my server and everything worked out fine. Have you encountered such scenario before? I didn't do anything except restart the server and now it's working.

Any hints?

bass_player at 2007-9-9 >

# 9

Milind Lele - MSFT wrote:
Can you please change the time out value from Tools->Options->Database Tools->Query and View Designers?

I am using RTM versions (or in reality, SP1) and this is the part that was hindering our remote SQL Server from completing the deployment. Thanks for the tip, was looking all around the database project's properties itself.

icelava at 2007-9-9 >

SQL Server

.NET Framework inside SQL Server

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

it's Archive about 'Timeout expires when deploying assemblies in SQL Server 2005 June CTP...'

Timeout expires when deploying assemblies in SQL Server 2005 June CTP

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Site Classified