Learning SAS? Welcome to the exclusive online community for all SAS learners.

How do I set a LIBNAME to SQLServer

Reply
Occasional Contributor
Posts: 8

How do I set a LIBNAME to SQLServer

I recently installed the University Edition. In attempting to create a LIBNAME to a MS SQLServer database, I get the following error: 

ERROR: The SQLSVR engine cannot be found.
ERROR: Error in the LIBNAME statement.
 
Since the SQLSVR engine cannot be found, this sounds like SAS/ACCESS. It appears all the components of the VM installed, and SAS/ACCESS is listed as being included. Any suggestions on how to troubleshoot this? Or does all data need to be local? 
 
Thanks.
Super User
Posts: 17,905

Re: How do I set a LIBNAME to SQLServer

SAS UE doesn't support access to servers at this time.

 

There's a hack available, on here, if you search. 

Occasional Contributor
Posts: 8

Re: How do I set a LIBNAME to SQLServer

I had already search the forums. 

Super User
Posts: 9,687

Re: How do I set a LIBNAME to SQLServer

Occasional Contributor
Posts: 8

Re: How do I set a LIBNAME to SQLServer

Thank you, KSharp, for your link. I'll see if I can use this work around in our environment. 

Ask a Question
Discussion stats
  • 4 replies
  • 470 views
  • 1 like
  • 3 in conversation