How do I connect to a SQL Server from Windows?
Altair EmployeeThese notes relate to the SQLSERVER libname rather than the ODBC libname which can also be used to connect to SQL Server databases.
To connect to a Microsoft SQL server using a Windows operating system you will need to install SQL Server Native Client 11.0. See https://www.microsoft.com/en-us/download/details.aspx?id=29065
and open the 'Install Instructions'. Scroll down the page until you find the section entitled:-
Microsoft® SQL Server® 2012 Native ClientMicrosoft SQL Server Native Client (SQL Server Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 2005, 2008, 2008 R2, and SQL Server 2012. SQL Server Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2012 features. This redistributable installer for SQL Server Native Client installs the client components needed during run time to take advantage of new SQL Server code name ‘Denali’ features, and optionally installs the header files needed to develop an application that uses the SQL Server Native Client API.
Make sure you select the correct connector to match your 64-bit Altair SLC installation as we no longer support 32-bit. Look for:
X64 Package (sqlncli.msi)
From the Windows Start menu type ODBC and start the ODBC data sources utility.
Under the User DSN tab (for single user) or under the System DSN tab (for all users) select
Sqlserver SQL Server Native Client 11.0
And then 'Configure'
Name 'sqlserver' (user specified choice)
Server <ENTER_YOUR_SERVER>
Next->
Choose 'With SQL Server authentication using a login ID and password …'
Login ID <ENTER_YOUR_SQL_USERNAME>
Password <ENTER_YOUR_SQL_PASSWORD>
Tick the Connect to SQL server to obtain default settings
Next->Next->Finish