Connecting to specific db with SQL Azure

Joe · March 2017

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 · March 2017

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

Joe · April 2017

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

Yuriy · February 2018

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

Connecting to specific db with SQL Azure

Comments