Connecting to specific db with SQL Azure

Joe

Hi,

I am unable to connect to a SQL Azure db which requires to specify the database. I can select only "Display all in TreeView" and "select specific database" is grayed out. I can connect to the DB with SQL Management studio ONLY if a I select the db. So my LINQPad connection fails because I can't select a DB ! Any solution for this ?

JoeAlbahari

Are you adding a standard LINQ-to-SQL connection? What version of LINQPad are you using?

Joe

Version is 5.10 and yes I select default linq to sql. Checking from another machine and there it works, very strange,.

Yuriy

I've faced the same problem. How did you manage to solve this? LinqPad is the most preferable tool for me, I don't want to move to MS SQL Studio...

LinqPad v5.26.01
Connection - default (linq to sql)
Provider - SQL Azure
My user has restricted access to several DBs from the server, not the direct access to master db