# Hello, How to connect to Microsoft SQL Server using Matillion **URL:** \ **Category:** Academy And Certification\ **Created:** [July 12, 2023, 2:05pm UTC](https://matillioncommunity.discourse.group/t/hello-how-to-connect-to-microsoft-sql-server-using-matillion/1002 "2023-07-12T14:05:46Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![karishma.shah27](https://avatars.discourse-cdn.com/v4/letter/k/fbc32d/32.png) [@karishma.shah27](https://matillioncommunity.discourse.group/u/karishma.shah27)\ **Post date:** [July 12, 2023, 2:05pm UTC](https://matillioncommunity.discourse.group/t/hello-how-to-connect-to-microsoft-sql-server-using-matillion/1002/1 "2023-07-12T14:05:46Z")
I am new to Matillion and trying to follow along with the Migration course from Matillion academy https://academy.matillion.com/certifications.   The course includes migrating the data from Microsoft SQL Server to Snowflake. I have Matillion instance hosted on Azure cloud. I am not able to connect to MSSQL.   Any help is appreciated.   Thank you, Karishma ---
**Author:** ![Joe-Community-Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/joe-community-manager/32/897_2.png) [@Joe-Community-Manager](https://matillioncommunity.discourse.group/u/Joe-Community-Manager)\ **Post date:** [July 12, 2023, 2:35pm UTC](https://matillioncommunity.discourse.group/t/hello-how-to-connect-to-microsoft-sql-server-using-matillion/1002/2 "2023-07-12T14:35:47Z")
Hello [@karishma.shah27](https://matillioncommunity.discourse.group/u/karishma.shah27)​ Welcome to the Matillion Community! If you're looking to load your data from MSSQL into Snowflake, you can use the out-of-the-box Database Query component we have in the product. With the right credentials for your MSSQL database, you should be able to upload any table into Snowflake using this specific component. For this specific task, we recommend following our documentation page where we have information about the [Database Query component](https://documentation.matillion.com/docs/en/2147237). Also, this [specific section](https://academy.matillion.com/guides/1edb4b68-7aa9-11eb-b90d-06cf503dca07/tasks/0569e718-1936-11eb-bf30-06c0361096e5) of the Matillion Academy course (Migration) will give you a really good indication of one way to carry on with this process. I hope this helps, please do keep us posted. Kind regards, Joe ---
**Author:** ![karishma.shah27](https://avatars.discourse-cdn.com/v4/letter/k/fbc32d/32.png) [@karishma.shah27](https://matillioncommunity.discourse.group/u/karishma.shah27)\ **Post date:** [July 12, 2023, 2:44pm UTC](https://matillioncommunity.discourse.group/t/hello-how-to-connect-to-microsoft-sql-server-using-matillion/1002/3 "2023-07-12T14:44:06Z")
Hello Joe,   Thank you for your response.   I am using the Database query component itself. I am getting an unknown host error. I reviewed the documentation and found that there are some prerequisites i.e. whitelisting an IP address. prerequisites - https://docs.matillion.com/data-productivity-cloud/batch/docs/microsoft-sql-server-batch-pipeline/#set-frequency   I have not whitelisted the IPs yet. Is this the reason I am getting an error?   Regards, Karishma     ---
**Author:** ![Joe-Community-Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/joe-community-manager/32/897_2.png) [@Joe-Community-Manager](https://matillioncommunity.discourse.group/u/Joe-Community-Manager)\ **Post date:** [July 12, 2023, 3:49pm UTC](https://matillioncommunity.discourse.group/t/hello-how-to-connect-to-microsoft-sql-server-using-matillion/1002/4 "2023-07-12T15:49:46Z")
Hello,   It sounds like that may be the cause of the error yes.   Kind regards, Joe