Connecting to specific db with SQL Azure

Joe
Joe
in General
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 ?
· Share on Facebook

Comments

  • JoeAlbahari
    JoeAlbahari
    Are you adding a standard LINQ-to-SQL connection? What version of LINQPad are you using?
    · Share on Facebook
  • Joe
    Joe
    Version is 5.10 and yes I select default linq to sql. Checking from another machine and there it works, very strange,.
    · Share on Facebook
  • Yuriy
    Yuriy
    edited 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
    · Share on Facebook

Categories