topic Not able to connect to SAS remotly using SAS EG 4.3 in SAS Enterprise Guide

Not able to connect to SAS remotly using SAS EG 4.3

Ram4sas — Fri, 24 Jan 2014 06:21:25 GMT

Hi All,

not able to connect to SAS server remotly using SAS EG 4.3 and getting below error.

Error================================

Unspecified error: -2147417848(0x80010108)

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

SAS.EG.SDS.SDSException: Unspecified error: -2147417848(0x80010108) ---> System.Data.OleDb.OleDbException: Unspecified error: -2147417848(0x80010108)

at System.Data.OleDb.OleDbDataReader.ProcessResults(OleDbHResult hr)

at System.Data.OleDb.OleDbDataReader.GetRowHandles()

at System.Data.OleDb.OleDbDataReader.ReadRowset()

at System.Data.OleDb.OleDbDataReader.Read()

at SAS.EG.SDS.Model.Server.GetServerLibraries()

--- End of inner exception stack trace ---

at SAS.EG.SDS.Model.Server.GetServerLibraries()

at SAS.EG.SDS.Model.Server.PopulateLibraries(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 ------------------------------

Re: Not able to connect to SAS remotly using SAS EG 4.3

jakarman — Sat, 25 Jan 2014 13:44:30 GMT

Is this the first time trying to connect or has something changed?

It is saying something wrong when buidling op libraries/tables. Could be the metdata is inconsistent about that or you have been locked out.

This will require a analyses what is working and what is not. Isolating tot the issue.

- can you login same user with SMC?

- Are collegues working?

- can you start a SAS session using the scritps in the config/Levx submaps

Your platform admin should help. Will be a dog-tail-run when that is you.

Re: Not able to connect to SAS remotly using SAS EG 4.3

ChrisHemedinger — Sat, 25 Jan 2014 20:46:03 GMT

The error code indicates that the SAS session was lost/disconnected. You might need to check the SAS workspace server logs (an admin job) to see what's going on. SAS Technical Support can help lead you through that.

Chris