Timeout trying to connect to a database

Yossu

I've just created a new database on my hosted server, and can connect fine to it using SQL Server Management Studio. However, when I try to connect via LinqPad, I get a message "Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding" when I try to open the dropdown next to "Specify new or existing database." If I click the "Display all in a TreeView" then the Test button is enabled, and if I click it, it tells me the connection was successful.

Anyone any ideas? I've obviously entered the right connection info, it just won't populate the dropdown. I've successfully connected to other database on this shared hosting before, so it's not that.

Thanks for any help you can give

Yossu

Anyone?

JoeAlbahari

LINQPad calls dbo.sp_MShasdbaccess to populate the dropdown list.

What happens in SSMS if you execute dbo.sp_MShasdbaccess?

Yossu

Hello,

When I run that, it just shows the databases on my local server. It doesn't show any databases on remote servers, even though I have access to various ones, including other database in the same hosted server.

Thanks for the reply. Any other suggestions?

Yossu

In case it helps anyone, it turns out that the answer was to enter the database name manually, and not use the dropdown to get the databases.