The ODBC drivers are installed with Sage 100, look in the 32 bit ODBC Administrator for SOTAMAS90. You can install the 64bit ODBC driver - you may need that for MS SQL and SSRS - look in the \Sage100AdvancedERP2015\MAS90\wksetup\Prerequisites\64Bit ODBC folder.

Wait... what is SFAServ?

it is what FASServ once was before 2016.1
I guess. I am new here.

are there any documents or examples of this set up. I am lazy(or rather in a hurry) and don't want a lot of extra reading if I don't need it. Thanks for the info you have already provided. I am already better off.

Oh you're talking about Sage Fixed Assets (FAS) - I guess you should scoot over in this forum: sagecity.na.sage.com/.../

Thank you again. Sorry for posting in the wrong forum.

I'm not sure you understand about MS SQL Studio, by which I think you mean SQL Server Management Studio. You don't need an ODBC for that, you can just build queries and views right in SSMS. You can learn a lot just by asking SSMS to query data for you. Right-click on a table and select 'Select Top 1000 Rows' and you'll get an instant query for that table. You'll have a lot of homework to do to learn your way around well but there's plentiful help available in the SQL arena.

Now, if you want to hook up Excel, or Access or some other program to the database then you'll need an ODBC. But those programs link right into the Windows ODBC facilities.

How to I connect with SSMS? What instance or port?

SSMS 12.0.4213.0
MDAC 6.3.9600.17415
MSXML 3.0 4.0 6.0
Win 2012 R2

You connect using the server name in the Server name field.

negative. I get my MSSQLSERVER instance only. I don't see any dbase connections or dbs listed.