Hi...I'm unable to start Table Sever :( , getting this logs in SASTS , kindly assist if anyone having any idea

[Jaydeep]

2012-12-03T05:09:08,129 INFO  [00000003] :SYSTEM@abc - SAH061001I SAS Table Server (2171), State, starting

2012-12-03T05:09:08,145 INFO  [00000039] :SYSTEM@abc - New out call client using cached connection (1) for user sastrust@saspw.

2012-12-03T05:09:08,177 ERROR [00000007] :SYSTEM@abc - 20121203:05.09.08.18: 00000039:ERROR: Metadata identity "OMSOBJ:Person/A***.A***2" is not configured as a table server system user.

2012-12-03T05:09:08,177 ERROR [00000007] :SYSTEM@abc - 20121203:05.09.08.18: 00000039:ERROR: 0; ; ; V_CTOR, CREATE SERVICE CONTEXT: Unexpected failure encountered: Function failed.

2012-12-03T05:09:08,191 ERROR [00000007] :SYSTEM@abc - 20121203:05.09.08.19: 00000039:ERROR: CLASSFACTORY cannot be instantiated.

[PaulHomes]

I would hazard a guess that perhaps someone has removed the SAS Trusted User as a member of the Table Server Administrators group.  In my SAS 9.2 installation the Table Server Administrators group has 2 members: SAS Truster User (a user) and SAS Administrators (a group).

[Jaydeep]

Hi Paul,

Thanks for reply, you are correct, however we already added the Trusted User (SMC) and restart all the servces, still getting the same issue.

Any suggestion.

Regards,

Jaydeep

[PaulHomes]

If it's still an issue then I'd suggest contacting SAS Technical Support for further assistance. The removal of the SAS Trusted User from the Table Server Administrators group suggests the possibility of other issues with the default security setup being modified.  You might also consider getting the assistance of a local consultant (SAS Professional Services or a partner) to review your environment.

[Rocky2090]

Thanks Paul, Adding trusted user to Table Server Administrators worked..