SQL query to tell if SQL logins are using Kerberos or NTLM

Not explanation needed here, if you know what you are looking for, this is it.

SELECT 
s.session_id
, c.connect_time
, s.login_time
, s.login_name
, c.protocol_type
, c.auth_scheme
, s.HOST_NAME
, s.program_name
FROM sys.dm_exec_sessions s
JOIN sys.dm_exec_connections c
ON s.session_id = c.session_id

TFS 2008 to TFS 2010 Install notes

Recently (about 5 minutes ago) I did an upgrade in production of our Team Foundation 2008 server to Team Foundation 2010. I had a dry run that worked well but of course on the real thing I had a couple of issues. Here are some notes.

• TFS requires sysadmin on the new SQL server, it wants to create/drop databases like crazy
• TFS previous to 2010 required sharepoint to be installed, with 2010 it’s just an option, you can add it later.
• To clean up from an earlier install (failed, test run, etc.) you can run this command (see the gotcha at the end!)

C:Program FilesMicrosoft Team Foundation Server 2010Tools>tfsconfig setup /un
install:all

The steps are

1. Install TFS 2010
2. Configure TFS 2010 (this creates databases)
3. Backup your old TFS databases (all of them)
4. Restore your old TFS databases to your new sql instance
5. Run the TFS import command from command line. It should look like this:

C:Program FilesMicrosoft Team Foundation Server 2010Tools>Tfsconfig import /s
qlinstance:serverinstance /collectionName:imported /confirmed

Once you do this, you should be good to go

We had an error when trying to install on production because it kept finding information from the previous one. Apparently the tsconfig /setup uninstall:all doesn’t really uninstall all! There were extended database properties left over that we had to delete manually. Until we did this, we received this error:

• TF30046: The instance information does not match.

There are very useful logfiles located in:

• C:ProgramDataMicrosoftTeam FoundationServer ConfigurationLogs

In order to get visual studio 2005 to connect to TFS 2010, you have to install in this order:

1. Visual studio 2005
2. Tfs plugin for vs 2005
3. Vs 2005 sp1
4. Vs 2005 vista compatibility update (run windows update)
5. Vs 2005 TFS 2010 update
6. Then you enter the full URL in the server name field: http://tfs2010_server:8080/tfs
7. If it tells you that you can’t put in the “/” and such, it means you installed in the wrong order.

In order to get visual studio 2008 to connect to TFS 2010, you have to:

1. Install vs 2008
2. Install vs 2008 sp1
3. Install vs 2008 TFS compatibility pack
4. Enter servername as: http://tfs2010_server:8080/tfs

That’s all I have for now. After all the devs come in and hit this tomorrow I may have some more updates (but I hope not!).