Cameron Fletcher

I write software. I have run variations of this website since 2004.

less than 1 minute read

I just got this error when trying to add an Administration Console User to TFS 2010 installed on Windows 7 using a SQL Server database on a different server:

TF255440: The following account has a SQL Server login, but the login was denied access: TEST\cameron.fletcher. The server selected to host the databases for Team Foundation Server is: SQL. The SQL Server login associated with the user account must be granted access to the SQL Server instance on that server.

It turns out that although I have a login specifically assigned to me on the SQL box because I am also a member of a SQL administrators group there appears to be some issue with the TFS logic when verifying the connection. The solution? I simply deleted the login and it worked for me.

Tags:

Updated:

You May Also Enjoy

Running Roslyn on a Build Server

less than 1 minute read

If like the majority of people you shy away from installing a full blown copy of Visual Studio on your build server (for whatever reason) but you’d like to u...

CQRS Presentation

less than 1 minute read

I recently gave a presentation on Command and Query Responsibility Segregation (CQRS) as a follow-on from my event sourcing talk. This is really an overview ...

Welcome to my New Website

1 minute read

For the past 8 or so years I’ve been hosting my own website in various forms on my own hardware located for the most part in a cupboard under the stairs. Tod...