Connecting to specific db with SQL Azure
Options
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 ?
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 ?
Comments
-
Are you adding a standard LINQ-to-SQL connection? What version of LINQPad are you using?
-
Version is 5.10 and yes I select default linq to sql. Checking from another machine and there it works, very strange,.
-
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
