@AnandVyas Thank you but I've tried those steps, making the adjustments for the MS SQL Server, and still no success. The odd thing is that there is no documentation that I have found that speaks specifically to MS SQL Server.
When I get to the connection properties page of the New Server Wizard, what would I input for the Datasrc field to reflect the MS SQL Server and the specific database on that server that I want to connect to?
@dobby - What OS does your SAS server run on? The setup is very different on Windows compared to Unix.
@SASKiwi My SAS is running from Windows Server 2016.
@dobby - I suggest you try getting a LIBNAME working first. I'd also suggest trying the DSN-less approach and put everything in your connection string. Here is an example of what we do:
libname sqlsrvr odbc noprompt = "server=MyServerName;DRIVER=SQL Server;Trusted Connection=yes;" qualifier = "MyDatabase" schema = "MySchema";
All you need to do is replace MyServerName, MyDatabase and MySchema with yours. Once you get the LIBNAME working, you copy and paste the connection string into the Management Console Server connection properties. Please note the use of Windows Authentication (Trusted Connection=yes) to avoid supplying a userid and password. I hope this is how your SQL Server is set up.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.
Find more tutorials on the SAS Users YouTube channel.