SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Problems when connecting to MS SQL Server databases

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 6
Accepted Solution

Problems when connecting to MS SQL Server databases

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


Accepted Solutions
Solution
‎10-25-2016 10:18 AM
Occasional Contributor
Posts: 6

Re: Problems when connecting to MS SQL Server databases

Posted in reply to tiagomsoares

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.

View solution in original post


All Replies
Solution
‎10-25-2016 10:18 AM
Occasional Contributor
Posts: 6

Re: Problems when connecting to MS SQL Server databases

Posted in reply to tiagomsoares

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.

Super User
Posts: 3,257

Re: Problems when connecting to MS SQL Server databases

Posted in reply to tiagomsoares

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. 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 329 views
  • 1 like
  • 2 in conversation