Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
elarson
Starting Member
1 Post |
 Posted - 2007-11-13 : 13:34:11
|
| Hello-I recently inherited a SQL 2005 Standard database that I am being asked to change the Server authentication mode for. SQL system is managing a local database for Microsoft Systems Management Server 2003. Currently the system is running in SQL Server & Windows authentication mode. I am going to change it to Windows Authentication mode. Can someone point me to a checklist I could refer to before I make the change to be sure I don't take down my database? Thanks in advance.Erik |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-13 : 13:44:26
|
| Well you should be checking activity on the database server to see if any application is connecting with a SQL user. You can view current activity through Management Studio Current Activity GUI screen or by using sp_who/sp_who2. If you don't want to sit there hitting refresh all of the time, then I'd suggest tracing logins via SQL Profiler.You should also check what SQL accounts have been created by looking at Logins in Management Studio. When you setup your trace, filter it down to just these SQL accounts. Do not include sa in your trace as that's a normal SQL account to have.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Server Authentication Change Question