Need help to connect a Microsoft SQL server to DOMO
How can I connect MS SQL server with Windows authentication mode only?
Should I ask the server owner to change the selection from Windows Authentication mode to SQL Server and Windows Authentication mode?
Answers
-
Yes, SQL accepts mixed mode (Windows Authentication and SQL), which sounds like what you would want.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Does it mean I have to change the SQL setting not DOMO?
I tried one of the SQL server username and pw in the other app and it connected and worked fine. But the same username and pw failed the connection in DOMO. Why?
0 -
Which connector are using in Domo? If you are using the Microsoft SQL Server Connector, you are going to want to look at this KB article and make sure you have all of the prerequisites addressed, particularly whitelisting IP addresses and ensuring your company's firewall has the appropriate ports open.
https://domohelp.domo.com/hc/en-us/articles/360043436173-Microsoft-SQL-Server-Connector
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 557 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 571 Beast Mode
- 11 App Studio
- 28 Variables
- 579 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 352 Distribute
- 92 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 88 Community Announcements
- 4.8K Archive