Hello,

Maybe I asked the wrong question. I am trying to work out how permissions are assigned to each of SQL Server services in SQL Server 2008.

In SQL Server 2005 the install created groups in order to assign permissions. The account for each of the services was then dropped into each group.

From what I can see in SQL Server 2008, the account is no longer used to assign permissions. Instead a service SID is dropped into each group.

The problem I am having is, that when I run cmd>>sc showsid [servicename], the SID displayed does not match the SID in the corresponding group.

Am I missing something here?

Andrew