Hello,
I need to establish connection to my SQL Server database using SAS DI Studio.
After reading the documentation, I verify that a need to create a new library. So, I open the "New Library Wizard" to do that.
However I need to specify a libref, I suppose that "sqlsvr" is the valid one and after selecting the "Next" option, a new pop-up appears in order to introduce server and connection details.
But in this pop-up, I can't change those details, neither create a new one.. And if I choose "Next" again, an error message appears: "Database server filed is required", something that I expected.
Can you help me? There's something missing?
Kind regards,
Tiago
I guess I 've found the problem.
First, I need to create a Data Source Server and after that I can create a library associated to the server.
Now I can specify server and connection details!
Kind regards.
I guess I 've found the problem.
First, I need to create a Data Source Server and after that I can create a library associated to the server.
Now I can specify server and connection details!
Kind regards.
That is correct. You first create a server definition under Server Manager for your SQL Server. Under the server definition you create a server connection (you can have muliple connections per server if required). In the server connection you define your SQL connection string.
Finally you can now create one or more data library definitions that reference the server definition you have already created.
Please mark your post as answered as it saves us time looking through unmarked posts that have actually been answered.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.