I've upgraded SQL 2005 to SQL 2008 on a server. Separate instance and i've recreated all logins.
My app, ssis packages etc all still work via NT authentication but I need to ascertain 'how'.
Other than removing each login in turn and testing, can anyone suggest a way i can prove which login is reponsible.
I have the following collection of logins on my instance.
BUILTIN\Administrators
NT AUTHORITY\NETWORK SERVICE
NT AUTHORITY\SYSTEM
I also have
NT SERVICE\MSSQLSERVER and
NT SERVICE\SQLSERVERAGENT
which have been created despite me providing domain accounts for my services.
Any help tracking this down is much appreciated.
r