Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Visual Studio Code to ...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Visual Studio Code to CDS Connection

(0) ShareShare
ReportReport
Posted on by Rdobryanskyy1 5

Hi Guys,

I am using XRMToolbox and it is fantastic. I know it might sound ridiculous but I am using OSX but not windows. For this reason I need to have a virtual machine. With the latest SQL4CDS plugin, I was able to use SQL language to select stuff. Now question, 

How can I connect to the SQL DB of CDS Dynamics With Visual Studio Code?

I tried the SQL Server connection, but got errors:

mssql: Failed to connect: Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 35 - An internal exception was caught)
---> System.Net.Internals.SocketExceptionFactory+ExtendedSocketException (00000005, 0xFFFDFFFF): nodename nor servname provided, or not known
at System.Net.Dns.InternalGetHostByName(String hostName)
at System.Net.Dns.GetHostAddresses(String hostNameOrAddress)
at Microsoft.Data.SqlClient.SNI.SNITCPHandle.Connect(String serverName, Int32 port, TimeSpan timeout, Boolean isInfiniteTimeout, String cachedFQDN, SQLDNSInfo& pendingDNSInfo)
at Microsoft.Data.SqlClient.SNI.SNITCPHandle..ctor(String serverName, Int32 port, Int64 timerExpire, Object callbackObject, Boolean parallel, String cachedFQDN, SQLDNSInfo& pendingDNSInfo)
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover, SqlAuthenticationMethod authType)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken, DbConnectionPool pool)
at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at Microsoft.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
at Microsoft.Data.ProviderBase.DbConnectionFactory.<>c__DisplayClass45_0.<TryGetConnection>b__1(Task`1 _)
at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.SqlTools.ServiceLayer.Connection.ReliableConnection.ReliableSqlConnection.<>c__DisplayClass30_0.<<OpenAsync>b__0>d.MoveNext() in D:\a\1\s\src\Microsoft.SqlTools.ManagedBatchParser\ReliableConnection\ReliableSqlConnection.cs:line 314
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.SqlTools.ServiceLayer.Connection.ConnectionService.TryOpenConnection(ConnectionInfo connectionInfo, ConnectParams connectionParams) in D:\a\1\s\src\Microsoft.SqlTools.ServiceLayer\Connection\ConnectionService.cs:line 550
ClientConnectionId:00000000-0000-0000-0000-000000000000

Any advices?

  • Rdobryanskyy1 Profile Picture
    Rdobryanskyy1 5 on at
    RE: Visual Studio Code to CDS Connection

    unfortunately still haven't found any solutions on this.

  • Suggested answer
    MarkMpn Profile Picture
    MarkMpn 10 on at
    RE: Visual Studio Code to CDS Connection

    From this part of your error message:

    nodename nor servname provided, or not known
    at System.Net.Dns.InternalGetHostByName(String hostName)

    it looks like the server name in your connection string is incorrect - can you share your connection settings? (send me a message via Twitter/LinkedIn if you prefer)

  • Rdobryanskyy1 Profile Picture
    Rdobryanskyy1 5 on at
    RE: Visual Studio Code to CDS Connection

    Hi Mark,

    It is very-very nice to e-meet you. And THANK YOU for such a wonderful tool. You are doing SUCH a great job!

    Yes I have TDS enabled. But still have issues.

  • Suggested answer
    MarkMpn Profile Picture
    MarkMpn 10 on at
    RE: Visual Studio Code to CDS Connection

    Hi, I’m the author of SQL 4 CDS, glad it’s working well for you!

    By default SQL 4 CDS translates your SQL query into one or more FetchXML queries and executed those via the Dataverse API rather than using a direct SQL connection.

    If you have the preview TDS endpoint enabled you should be able to connect as you want though. Have you enabled the TDS endpoint for your environment in the admin portal?

  • Rdobryanskyy1 Profile Picture
    Rdobryanskyy1 5 on at
    RE: Visual Studio Code to CDS Connection

    Hi,

    Yes, I am working with the Online version. The data is accessible via XRMToolbox with SQL4CDS plugin, so if it is easily accessible from there, it should be accessible from OSX as well.

  • Wahaj Rashid Profile Picture
    Wahaj Rashid 11,319 on at
    RE: Visual Studio Code to CDS Connection

    Hi,

    Thank you for your query.

    Are you working on online version? If yes, how did you get the Database credentials? Database is not exposed in the online version, it is not accessible.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans