Team Foundation Server 2010 数据库登录错误
我已在 Windows Server 2003 上安装 Team Foundation Server 2010（基本配置），没有任何问题。但是，当我去管理 Team Foundation Server 管理控制台时，在按下“管理安全性”或“组成员资格”时，我收到错误消息，
服务器无法处理请求。 ---> Team Foundation 服务无法从服务器获得。技术信息（针对管理员）：请求已处理，因为应用程序已正确配置注释。没有可用于该请求的主机服务。
如果我尝试访问 http://localhost:8080/tfs，则会出现运行时
错误每次尝试执行任何操作时，我都会收到以下错误
- Failue Aud - MSSQL$SQLEXPRESS - 用户“SAG-S01\ASPNET”登录失败。原因：无法打开明确指定的数据库。 [客户端：]
- 错误 - TFS 服务 - 异常消息：TF246017：Team Foundation Server 无法连接到数据库。验证托管数据库的服务器是否可以运行，并且网络问题不会阻止与服务器的通信。 （类型数据库连接异常）
I have installed Team Foundation Server 2010 (basic configuration) on a Windows Server 2003 without any problems. But when I go to administer the Team Foundation Server Administration Console, I get the error when in the press "Administer Security" or "Group Membership"
Server was Unable to process request. ---> Team Foundation services are not available from the server. Technical information (for administrator): The request colud note asking Processed Because the application is configured correctly note. No host service is available for the request.
If I try to go to http://localhost:8080/tfs, an I Get Runtime Error
In the Event Viewer I get following errors each time I try to do anything
- Failue Aud - MSSQL$SQLEXPRESS - Login failed for user 'SAG-S01\ASPNET'. Reason: Failed to open the explicitly specified database. [CLIENT: ]
- Error - TFS Services - Exception Message: TF246017: Team Foundation Server could not connect to the database. Verify that the server that is hosting the database is operational, and that network problems are not blocking communication with the server. (type DatabaseConnectionException)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
您可以通过启动 SQL Server Management Studio 并导航到数据层上的 SQLExpress 实例来开始调查。查看 Tfs 数据库是否正在运行以及 ASPNET 用户是否具有数据库的访问权限。
You could start investigating by starting the SQL Server Management Studio and navigate to the SQLExpress instance on your data tier. See if the Tfs databases are running and whether the ASPNET user has access rights for the database.
现在我找到了问题所在。在 IIS 服务器中设置 TFS 将使用 .NET 1.1 而不是 4.0 运行
Now I found where the problem was. It was set in the IIS server that TFS would run with .NET 1.1 instead of 4.0
很奇怪。您能否检查一下是否可以通过 Sql Server Management Studio 访问数据库。
是否可以使用本地系统帐户或sa用户访问；您必须深入研究 TFS - SQL Server 连接。可能是您的用户没有授予连接 SQL 的权限。请先尝试通过 Management Studio 连接。
It's weird. Can you check that you can access the database via Sql Server Management Studio.
If you can access with local system account or sa user; you have to deep dive form TFS - SQL Server connections. May be your user doesn't grant to connect SQL. Please try first, connect via Management Studio.