SQL 2000数据库恢复后如何恢复DTS权限
作为我们为客户提供企业应用程序支持的方式的一部分，我们让他们备份他们的数据库，我在我们的服务器上恢复它，做一些维护，备份它，然后让他们在他们的服务器上恢复它。 这非常有效，但我通常必须重置该数据库的用户权限。 但目前我有一个客户端无法在该服务器上运行 DTS 包，因为数据库用户无法连接到数据库。 我尝试查看所有可能的设置和选项，并检查并重新检查该用户的权限，顺便说一下，该用户处于 dbo 角色，但似乎没有任何效果。 有人知道为什么即使用户具有正确的权限我也无法连接吗？
提前致谢！
As part of the way we handle support for our clients for an enterprise application, we have them backup their database, I restore it on our server, do some maintenance, backup it up, and have them restore it on their server. This works very well, but I usually have to reset the users permissions for that database. But at the moment I have one client that is not able to run the DTS packages on that server due to a database user not being able to connect to the database. I've tried looking through every possible setting and option as well as checked and rechecked the permissions for that user, who by the way is in the dbo role, but nothing seems to work. Anyone know why I can't connect even though the user has the correct permissions?
Thanks in advance!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
数据库的所有者可能是错误的。 我会首先通过确保所有者设置为其网络上的用户或角色（或者 sa，如果他们不使用 Windows 身份验证）来进行检查。
The owner of the database might be wrong. I'd check that first by making sure the owner is set to a user or role on their network (or sa if they're not using Windows authentication).