August 19, 2009 at 5:20 am
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
August 19, 2009 at 5:59 am
Profile the sql server using the 'sql profiler' tool, and that will show you what t-sql is currently running on the server. It may be best to add the hostname & databaseid columns so you know where each connection is coming from and what database they are accessing.
Steven
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply