SQL 2005 SA Password Reset

[Curiosityx]

Greetings, i need to reset the SA password on our SQL 2005 server, before doing so is there a method i can use to check to see if any applications use the SA account to log onto the server?

I have previously configured all of our applications such as BES, CRM etc to use Windows Authentication.

Regards

 

[oneilldo]

if you can log into sql server under windows then can't you just do
exec sp_who in query analyser and see which ones if any care connected as SA.
Obviously all applications that access the DB will need to have active connections at this time

 

[Curiosityx]

if you can log into sql server under windows then can't you just do
exec sp_who in query analyser and see which ones if any care connected as SA.
Obviously all applications that access the DB will need to have active connections at this time

Thats the one! Thank you for your help.

Regards

 

[oneilldo]

No problem, hope you get it sorted. If you need more info than sp_who gives you then try
sp_who2, its undocumented but gives you more information (I haven't had any problems when using it)