Connecting to Microsoft SQL server

[Raj]

Can anyone share step by step process to connect to the Microsoft SQL server

so I can pull data from the database

[ShankerV]

Hi @Raj 

The below link will help with steps.
https://help.alteryx.com/2021.2/SQLServerConnections.htm

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks
Shanker V

[Raj]

I have already gone through many links but needed some simpler method

[Hamder83 · Accepted solution]

Hi @Raj 

How do you login to the server? Which kind of credentials?

i use Input Data -> Setup connection -> Data Sources -> Quick connect ->
Host = server ip

Auth:
windows or sql directly 

if sql directly then enter username and password for sql user.

And test - and it should work. 

if not, what error do you geT?

[Felipe_Ribeir0]

Hi @Raj 

I suggest you to take a look at some videos about it, it will be easier to understand and repeat what they did.

https://www.youtube.com/results?search_query=sql+server+connection+alteryx