LinqPad timeout connecting to remote SQL Server

tags:

linqpad

views:

answers:

LinqPad timeout connecting to remote SQL Server

I'm trying to connect my hosting providers SQL Server with LinqPad. It works fine using SSMS, but times out when trying to fetch the database list. I am successfully authenticated (via the test)... [ and if i change the credentials, it fails]...

Is there a way to extend the timeout??

Thanks - Kevin

The timeout for fetching schema information in LINQPad is 4 minutes, so something is going badly wrong if it times out! On the dialog, did you click 'Display all databases in TreeView' or did you connect to specific database?

Joe Albahari 2010-10-01 01:08:54

Hey Joe... neither option works: display all in treeview times out at 30 seconds [I timed it this time]; and selecting 'Specify new or existing database' also times out after 30 seconds when you try to populate the dropdown list. I got it to work by selecting "Specify new or existing database" and then just typing in my db name. There are a LOT of db's on this server, so maybe it's timing out just trying to get the list of names. They show up 'instantly' in SSMS - so I'm not sure what's different... and the timeout is definitely 30 seconds.

Kevin 2010-10-01 06:10:47

Great product by the way!

Kevin 2010-10-01 06:16:05

I see - it's timing out when querying the list of databases, rather than populating the schema. What happens when you execute sp_MShasdbaccess on that server? Does it execute quickly or take forever?

Joe Albahari 2010-10-02 02:10:15

Hi Joe - I just ran sp_MShasdbaccess - and it completed in a whopping 5 minutes and 27 seconds. I re-confirmed that it times out in 30 sec from the connection settings form. Not sure what's going on - but I'm able to work around it by typing in my db name. Thanks for your help and for a great learning tool.

Kevin 2010-10-02 13:36:58

ansaurus

tags:

views:

answers:

LinqPad timeout connecting to remote SQL Server

related questions