topic Re: The library could not be assigned by SAS Server in SAS Enterprise Guide

The library could not be assigned by SAS Server

vishu — Wed, 09 Mar 2016 13:09:05 GMT

Hello,

need immediate solution

i have some sas tables & code in particular sas library but im getting this error.

Thank You.

Re: The library could not be assigned by SAS Server

jklaverstijn — Wed, 09 Mar 2016 13:19:19 GMT

Hi Vishu,

Did you click the "Show details" button? Often this gives good insight as to what the underlyhing issue is. Please share that info with us.

Regards, Jan.

Re: The library could not be assigned by SAS Server

LinusH — Wed, 09 Mar 2016 13:19:05 GMT

What about checking "Show details"?

What kind of library is it?

It's not pre-assigned?

Does this happen for every user?

Authorization?

Search the metadata server & object spawner log for any more clues.

Re: The library could not be assigned by SAS Server

vishu — Wed, 09 Mar 2016 14:22:03 GMT

yes i checked with show details checkbox.

it shows

[Error] Error trying to establish connection: Unable to Initialize: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

--------------------------- Technical Information Follows ------------------------------

SAS.EG.SDS.SDSException: <?xml version="1.0" ?><Exceptions><Exception><SASMessage severity="Error">Error trying to establish connection: Unable to Initialize: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.</SASMessage></Exception></Exceptions>
   at SAS.EG.SDS.Model.Library.Assign()
   at SAS.EG.SDS.Model.Library.PopulateDatasets(Collection& collection)
   at SAS.EG.SDS.Model.Broker.PopulateCollection(Collection collection)
   at SAS.EG.SDS.Model.Collection.DoPopulate()
   at SAS.EG.SDS.Model.Collection.Populate()
   at SAS.EG.SDS.Views.View.DoPopulate(DisplayOperation& op)

------------------------------ End of Technical Information -----

This issue is occuring for every user as Linush said..

thnx Linush & Jklaverstijn

Re: The library could not be assigned by SAS Server

jklaverstijn — Wed, 09 Mar 2016 14:36:50 GMT

Well there you have it. For some reason (many possibilities) you cannot get to the data in SQL Server as specified in the metadata. You will probably need to work with your trusted DBA to figure this one out. One hint I can give you:

Run this code from within EG. Insert the actual name of the library between the quotes:

libname test metalib library="<your library metadata name>"  libdebug;

This will give you the current info used to assign the library from metadata.

Hope this helps,

- Jan

Re: The library could not be assigned by SAS Server

vishu — Wed, 09 Mar 2016 14:44:03 GMT

GETTING THIS ERROR

ERROR: The METALIB engine cannot be found.

ERROR: Error in the LIBNAME statement.

Thank U

Re: The library could not be assigned by SAS Server

LinusH — Wed, 09 Mar 2016 14:58:46 GMT

Oh, it should read:

libname test meta library="<your library metadata name>"  libdebug;

Re: The library could not be assigned by SAS Server

jklaverstijn — Wed, 09 Mar 2016 15:08:26 GMT

Ah yes. Typo while reading off another screen. That was severely untested code. Sorry for that.

Re: The library could not be assigned by SAS Server

vishu — Thu, 10 Mar 2016 11:22:59 GMT

there any solution last one is not working ....thank u

Re: The library could not be assigned by SAS Server

LinusH — Thu, 10 Mar 2016 11:30:02 GMT

It was just a test.
Have this ever worked? If so, what has changed?
As @jklaverstijn said, the SAS Admin and SQL Server DBA should work close together to solve this.
If there's anything wrong in the meta data, it's hard for us to trouble shoot. So if you can't find what's wrong, maybe it's simpler to register the schema and library from scratch based on the guides available in the documentation and published papers.

Re: The library could not be assigned by SAS Server

SASKiwi — Thu, 10 Mar 2016 18:40:17 GMT

Try assigning a test LIBNAME without involving metadata. Does it work? If it does then your problem is with the metadata version. If it doesn't work then you need to get this right first before considering your metadata definition.

libname test "<your data library path>" ;

Re: The library could not be assigned by SAS Server

jklaverstijn — Tue, 15 Mar 2016 10:32:08 GMT

Hi Vishnu,

We cannot provide a solution based on what we know. And it requires knowledge of your local installation. The best approach imho is still to run

libname test meta library="<your library metadata name>" libdebug;

Print out the log and take that to your local (database) support people.

Good luck,
- Jan.