Skip to content

Data Virtualization - MongoDB instead of Azuresql #4

@eliassal

Description

@eliassal

Hi, I am following instructions to the letter and would like to test with MongoDB which I have on a linux machine. I can access the mongodb DBs and collections from RoboT 3 or APIs but when trying to configure the external table in sql I get

Msg 110064, Level 16, State 62, Line 25
110064;Windows authentication failed. Possible network configuration issue. Please contact your system administrator.

Here are the steps I did

CREATE DATABASE SCOPED CREDENTIAL MongoDB   
WITH IDENTITY = 'myname', Secret = 'mypassword'
GO

I get the error when I execute

CREATE EXTERNAL DATA SOURCE MongoDBSource
WITH ( 
LOCATION = 'mongodb://mylinux:27017',
PUSHDOWN = ON,
CREDENTIAL = MongoDB
);
GO
OR (read this on the blog of Anthony Bulk  MS MVP at Sierra Systems)
CREATE EXTERNAL DATA SOURCE MongoDBSource
WITH ( 
LOCATION = 'mongodb://mylinux:27017',
CREDENTIAL = MongoDB,
CONNECTION_OPTIONS = 'sl=false;'
);
GO

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions