WCF server-agents infrastructure

Hi,

I have installed a named instance of SQL Server 2008 R2 Enterprise 64 bit on Windows Server 2008 R2 Enterprise 64 bit. The os is running as a VM ware virtual machine.

I have created an AD security group for database engine sys admins on that machine. I added my user to that group.So for example;

domainname\machinename_SQL_DBE_SysADmins is a user with SysAdmin server role permissions. User domainname\MichaelEFF is a member of this group.

When I log onto the machine as this user and run the management studio with run as administrator I cannot log into the database engine. The log shows the error:

Login failed for user: Reason:Token-based server access validation failed with an infrastructure error

I've read many posts where the MVP says that the UAC is not passing the group membership. Is this the case? If so then how will role based access ever be possible with windows authentication? How can this be resolved?

Thanks!

Michael

I would appreciate help with the following issue:

I have created a local group in our SQL 2008 server and added two Windows user accounts "DOMAIN\UserName"  I  then added the local group to the database and granted read only access.

The users are trying to link tables using MS Access using and ODBC connection and getting the following error.

Users are not system administrators.

Date                      6/30/2010 1:01:54 PM

Log                         SQ

We turned on the Office SharePoint Server Publishing Infrastructure feature on our MOSS 2007 (after we already had sites created) to allow users to be able to use features like excel services and reporting which both require this be activated the Publishing feature to be turned on,  In order to do this you have to activate the Office SharePoint Server Publishing Infrastructure feature at I beleive the top level site, however when we activate this feature it changes the templates and navigation for all the existing SharePoint sites in our collection. 

Is there a way to turn this feature on with out impacting existing site sites?  Or am I doing something wrong that is causing this to happen?  Basically I need to know how I can activate this option (Office SharePoint Server Publishing Infrastructure) to just specific sites but not all or turn it on so it does not impact all sites?

Error
Publishing sites and features cannot be activated in the Central Administration Web Application.


On my other site collection(s) I manage to activate this feature by using the "publishing template".


In the logs of sharepoint ( C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN ),
i see the following entries:

w3wp.exe (0x1168)                 0x1048 CMS                            Publishing Provisioning        6wy9 Unexpected CommonUtilities.ConfirmNotCentralAdminWebApp(): Failed trying to activate publishing sites/features on CentralAdmin Web App. WebUrl: 'http://hk81:9200'

w3wp.exe (0x1168)                        0x1048 CMS                            Publishing Provisioning        8gyv Unexpected PublishingPrerequisistes Feature activation failed. Exception: Microsoft.SharePoint.SPException: Publishing sites and features cannot be activated in the Central Administration Web Application. WebUrl: 'http://hk81:9200'     at Microsoft.SharePoint.Publishing.CommonUtilities.ConfirmNotCentralAdminWebApp(SPWeb web)     at Microsoft.SharePoint.Publishing.PublishingPrerequisitesFeatureHandler.<>c__DisplayCl

We have a customer with three publications, one distributor/publisher and on subscriber using merge replication.

looking at the history of the job replication agents checkup, every entry shows a message of:

Executed as user: NT AUTHORITY\SYSTEM. The replication agent has not logged a progress message in 10 minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections to the Subscriber, Publisher, and Distributor are still active. [SQLSTATE 01000] (Message 20554).  The step succeeded.

Throughout the day this error still appears as this job runs every 10 minutes but replication works fine. The issue is at some point throughout the night the replication stops with that same message. Sometimes it stops at 6:00:00am, sometimes at 6:40:00am, others at 6:50:00am. All we have to do to fix it is go into the replication monitor and stop synchronizing and then start synchronizing and replication will run all day until it stops next morning - again.

What is causing that error message? I have checked the other logs and there is nothing running at those times. in addition, no one has logged into the server that early (they don't start arriving until 7:15 or later).

What can i do to correct the issue so the message stops happening.

i