topic Problems when connecting to MS SQL Server databases in SAS Data Management

Problems when connecting to MS SQL Server databases

tiagomsoares — Fri, 21 Oct 2016 09:19:03 GMT

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

Re: Problems when connecting to MS SQL Server databases

tiagomsoares — Fri, 21 Oct 2016 10:21:46 GMT

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.

Re: Problems when connecting to MS SQL Server databases

SASKiwi — Sun, 23 Oct 2016 22:14:39 GMT

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.