Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

In DB Connect to Micrsoft SQL Server unable to find related database

XihanJin
5 - Atom

So I am using a Connect In DB tool to read data from Microsoft SQL Server. I have set the connection in ODBC Admin and connect it to the Microsoft SQL Server. And I find a place where I can choose different databases. But the database that I need to connect is not showing up. The structure in the SQL Server is SQL Server/System Databases/master, so I could only choose master here. But the database I need is SQL Server/<other databases>/<the database>. How could I change reading System Databases to <other databases>?

2 REPLIES 2
cjaneczko
13 - Pulsar

You change it in your ODBC admin configuration where I have squiggled out mine with the black pen. Tick off the "Change the default database :" and enter the database you want to connect to.

 

image.png

XihanJin
5 - Atom

Sorry, this is my fault. I should have used the OLEDB connection rather than ODBC connection.

Labels
Top Solution Authors