With a few exceptions (for example, SSAS cubes), Tableau’s “Fast Data Engine” (we normally just call it the Data Engine) can create a Tableau Data Extract (TDE – a columnar database) from just about any data source. So, “yes”. You can make an extract out of your SQL Server database.
Become a Viz Whiz on the Forums! Support the Community and master Tableau.