Web 性能和负载测试 vs2010
我在创建 Web 测试并运行此测试进行负载测试时遇到此问题
无法打开负载测试结果数据库。检查测试控制器（或本地计算机）的连接字符串指定的负载测试结果数据库是否指定包含负载测试架构且当前可用的数据库。有关详细信息，请参阅 Visual Studio 帮助主题“关于负载测试结果存储”。连接错误为：尝试创建负载测试结果存储库架构时发生错误：要创建数据库“LoadTest2010”，您的用户帐户必须具有 SQL Server“sysadmin”角色或同时具有“serveradmin”和“dbcreator”角色角色
请帮助我摆脱这个困境
i m getting this issue when created a web test and run this for load test
The load test results database could not be opened. Check that the load test results database specified by the connect string for your test controller (or local machine) specifies a database that contains the load test schema and that is currently available. For more information, see the Visual Studio help topic 'About the Load Test Results Store'. The connection error was: An error occurred while attempting to create the load test results repository schema: To create the database 'LoadTest2010' your user account must have the either the SQL Server 'sysadmin' role or both the 'serveradmin' and 'dbcreator' roles
please help me out of this
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
这里的基本问题是您的权限不适合用于运行负载测试的帐户。什么账户？这取决于您是否正在运行控制器和代理，或者您是否只是在 Visual Studio 或 MSTest 中本地运行负载测试。
在后一种情况下，请确保用于登录 Visual Studio/MSTest 计算机的凭据还允许您在 SQL Server 上创建数据库。
如果您使用控制器和代理，则您输入到控制器配置工具中的用户凭据必须具有相同的权限。
您之前可能已经阅读过本文。再次阅读，然后调整您的用户权限或让您的系统管理员来执行此操作。
The basic problem here is that you permissions are not right for the account that you are using to run the load test. What account? That depends on whether you are running a controller and agents or if you are just running your load test locally in Visual Studio or MSTest.
In the latter case, make sure that the credentials you use to log in to your Visual Studio/MSTest machine will allow you to also create a database on your SQL Server.
If you are using a controller and agents, the user credentials that you enter into your Controller configuration tool must have those same permissions.
You've probably read this before. Read it again and then adjust your user permissions or get your Sysadmin to do it.
这对我有用
要解决此问题，我按照以下步骤操作：
10.0\Common7\IDE”
加载测试结果存储库.sql“
This worked for me
To resolve this issue, I followed the below steps:
10.0\Common7\IDE"
loadtestresultsrepository.sql "