I'm trying to connect SQL Server Management Studio to Salesforce so I can see tables and columns but unable to connect. Do I need any ADO.net connector or Salesforce plugin for this to work? Do I need to change port number or any other setting? I'm using password+token in the password field. I know Real Force is a recommended way to connect and I'm able to do so but would like to connect it with SQL management studio as well if possible.
Salesforce does not use SQL Server, so you can't just connect from SQL Server Management Studio. A quick Google search found at least one product that claims to allow you to connect from Management Studio: https://www.devart.com/news/2015/odbc-salesforce.html.
I've also used a product called DBAmp to connect to Salesforce from SQL Server, but I don't think it gives you features like viewing table structure.
To view tables and fields, I'd recommend looking at Schema Builder, part of Salesforce's Setup.