Prior to connecting to an MS SQL Server instance from a Mac machine, there are some configuration settings that need to enabled on the SQL Server database.
I want to learn SQL on my Mac. What's the best way to get started? Head over to SQlite.org and download the C source code file, named sqlite-autoconf-3130000.tar.gz or similar, from the SQLite. Microsoft SQL Server for mac, Microsoft Office 2007, Microsoft Photo Editor 3.01, Microsoft SQL Server 2008 SP3. SQLPro Studio is the Premier application for editing and viewing mysql, postgres, oracle and microsoft sql server databases on mac os x.
1. The SQL Server database should be configured to accept TCP/IP connections. Many SQL Server installations are set up to only allow shared memory or named pipe access. You can setup the TCP/IP option using a tool like the SQL Server Configuration manager. Under Network Configuration there should be an option for Protocols. One of those protocols is TCP/IP . Make sure to enable TCP/IP.
2. If the user connecting to the database does not have a valid user id and password for the windows domain used by SQL Server, mixed mode authentation would need to be enabled on the SQL Server instance, and an administrator would need to create a SQL Server user id and password for the user connecting to the instance.
The easiest way to connect to MS SQL Server from Mac is with a JDBC (Java Database Connectivity) driver. There are two options for JDBC driver. Once is the open source jTDS driver. The other is the JDBC driver from Microsoft.
RazorSQL can use either of these drivers to connect to SQL Server, and the jTDS driver comes pre-installed with RazorSQL. If you are looking for a client program to query, edit, browse, and manage your SQL Server instance, check out RazorSQL. Free trials can be downloaded from here: https://razorsql.com/download.html
If you would like to proceed with writing your own programs to access SQL Server, check out the documentation for the jTDS driver to get started:
http://jtds.sourceforge.net/
http://jtds.sourceforge.net/
Microsoft Sql Server 2012 Free Download For Mac
If you need an editor for developing your Java JDBC program, check out EditRocket, available here:
https://editrocket.com/
https://editrocket.com/