DCSIMG
SQL Server - SRL Group

SRL Group

This blog is about Team System, QA and Development methodologies and more...

VSTS Resources

Team System Bloggers

Browse by Tags

All Tags » SQL Server (RSS)
Team Foundation Server and SQL Server Collation
One problem, we are having sometimes during Team Foundation Server setup, caused by the fact that TFS has serious limitations on SQL server collation. To be exact, following collation are not supported: Accent Insensitive Case sensitive Binary Binary2 In case, we have to install TFS on top of existing SQL Server, there is a good chance, that System Health Check report, prepared by TFS setup, will contain " SQL Server collation is not set to one supported by Team Foundation Server" error. What can...
SQL Server does not Allow Remote Connections Error
When you create your DB Dude project and try to build and deploy the project to the client's sandbox at the first time, you suddenly get the error: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections." This error occurred because the networking protocols are disabled by default in SQL Server Express. In order to solve this problem...