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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.