I have a WP site with a custom post type. My client wants me to include data from an external database running on MS SQL Server. I was given Windows Authentication access to the server and database by our IT dept, but I do not have any login info.
I'm confused about how to connect and how to access the data I want when I do. Does anyone have experience with this sort of thing?
Here is how connect to MSSQL server using Windows Authetication access
The same as before but from Microsoft MSDN
Sorry but never tried this before, but maybe the links above can help you.
Do you know if any other website uses that database? If so you could check that site's config files to find out how it connects to the DB.