login - Vertical Elastic Query Azure Database unable to authenticate -

-

i did create external datasource, identical guide described here .the process pretty simple, illustration.

create master key encryption ... create database scoped credential ...

not covered in article how create login , user. on master database did execute

create login <externaldbname> password = '<somepassword1>';  create user externaldbname login externaldbname;

and on externaldb

create user externaldbname login externaldbname;

then continued guide

create external data source ... create external table ..

all executed successfully. when try select external database, error raised

msg 46823, level 16, state 2, line 10 error retrieving data 1 or more shards. underlying error message received was: cannot open database externaldb requested login. login failed. login failed user externaldbname.

i able login given credential externaldb if using visual studio. there special permission needs granted or might wrong?

issue resolved. database name in external data source definition not same (typo) actual database name.


Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5);
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:
Read more