SQL Server 错误 916 [英] SQL Server error 916
问题描述
当我尝试附加数据库时出现此错误.
I get this error when I try to attach a database.
错误信息:发生异常在执行事务 sql 语句时或批量.
error message: An exception occured while executing transact sql statement or batch.
我已将我的数据库复制到 SQL Server 服务器的 Data 文件夹中.我想在 SQL Server 中配置数据库，但是当我尝试附加数据库时，它给出了错误.
I have copied my database in the Data folder of an SQL Server server. I want to configure the database in SQL Server, but when I try to attach the database, it gives the error.
我也尝试过更改与数据库相关的权限.
I have also tried to change the permissions related to the database.
推荐答案
你得到的错误和错误 916 是不同的！(我不是专家，我只是通过互联网阅读.)
The error you're getting and error 916 are different! (I am not an expert, I just read over the Internet.)
error 916 是这样的:
服务器主体用户名"不是能够访问数据库当前下的databasename"安全上下文.(微软 SQL服务器，错误:916)
The server principal "username" is not able to access the database "databasename" under the current security context. (Microsoft SQL Server, Error: 916)
无论如何，要解决 916 错误:
Anyway, to resolve the 916 error:
启动 Management Studio 2008 后，在对象资源管理器中选择一次数据库.
After starting Management Studio 2008, select Databases in the Object Explorer once.
如果对象资源管理器详细信息尚未显示，请从工具栏中选择查看，然后选择对象资源管理器详细信息.
If the Object Explorer Details are not already showing, select View from the toolbar then select Object Explorer Details.
右键单击任何列标题并确保未选中排序规则".
Right click on any column header and make sure that "collation" is not checked.
单击位于对象浏览器详细信息"面板顶部的刷新"按钮刷新数据库列表.此时您应该可以完全访问您的数据库.
Refresh the database list by clicking the Refresh button located at the top of the Object Explorer Details panel. You should have now have full access to your database at this point.
我(可耻地)复制自 Microsoft SQL Server，错误:916 和 解析 Microsoft SQL Server，错误:916.
I (shamefully) copied from Microsoft SQL Server, Error: 916 and Resolving Microsoft SQL Server, Error: 916.
要解决您在解释中写的错误，请尝试您可能会在以下情况下收到错误消息您使用 SQL Server 2005 中的配置分发向导.
And to solve the error you've written in your explanation try You may receive error messages when you use the Configure Distribution Wizard in SQL Server 2005.
希望对您有所帮助！
这篇关于SQL Server 错误 916的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
