Hello SYREXOKONNA0,
Judging by your Proc Setinit output, it appears you have one of the necessary products (SAS/ACCESS Interface to Microsoft SQL Server) licensed to enable a connection Microsoft SQL Server
This product is ODBC based. Therefore, in order to connect to the DBMS, you will need to setup an ODBC Data Source (DSN) in the ODBC Data Source Administrator outside of SAS on the machine where Foundation SAS is installed. Based on your description it sounds as if the Foundation SAS machine is your PC, but you will need to confirm this before setting up the DSN. If Foundation SAS is running on a server, then the configuration of the DSN will need to be done on the server.
The driver will be supplied by SAS (SAS Access to SQL Server), so there will be no need to install that. What you will need to do is access the ODBC Data Source that is of the same bit as your Foundation SAS installation (i.e. 64 bit SAS --> 64 bit ODBC Data Source Administrator) and configure your DSN. This will require that you know site specific information such as the server name where the SQL Server database resides, what type of authentication is required to access the database, either the SQL Server login credentials or the Windows authentication credentials, etc.
Once you have created the DSN of the appropriate bit, connection from within SAS is relatively easy. All you will need to do is issue a Libname that follows a similar structure to the one below:
libname test sqlsvr dsn='the dsn name you created' user='your user id' pw='your password' schema='your schema';
Note: if you use Windows authentication, the user and pw parameters are not needed in the Libname. Additionally, the default schema for SQL Server is dbo, so if you issue the Libname successfully, but do not see the tables, a good starting schema would be 'dbo';
If you are not familiar with setting up ODBC DSN's using the Microsoft ODBC Data Source Administrator, I suggest calling or emailing SAS Technical Support to open a track with them. SAS Technical Support is free of charge to sites that have paid for a SAS license. Please be aware that Technical Support can only help you get this connection made if you have the site-specific information necessary to create the DSN.
I hope this helps!
... View more