我有一个测试数据库,我有权限问题.
我无法访问报告数据库,应用程序的帮助文档说明要执行以下操作：
我无法访问报告数据库,应用程序的帮助文档说明要执行以下操作：
Resolution: 1. Launch the sql Server Management Studio and connect to the database server(s) hosting the Vision and Reporting Server databases. 2. Expand the security folder. 3. Select logins and right click on the <username> user and choose properties. 4. Click the User Mapping tab 5.Make sure the following databases are selected in the Users mapped to this Login: ReportServer ReportServerTempDB Your Vision databases This maps the login/user to the respective databases. 6. As you select each database (including your Vision database),select the db_owner role in the Database role membership for: section. You must select this option for each database.
当我这样做时,我收到以下错误：
"Create Failed for user '<servername>\<username>'. User,group,or role '<servername>\<username>' already exists in the current database. (Microsoft sql Server,Error: 15023)"
我用Google搜索了这个错误,并在每个数据库上尝试了以下命令：
ALTER USER [<username>] WITH LOGIN = [<username>]
该消息表明命令已成功完成,但当我尝试按照上面的说明映射每个数据库时,我仍然收到上述错误.
我错过了什么？
Per Kin的评论(谢谢)我试过这个：
– 我右键单击了用户并选择了：Script Login As>删除并创建到>新的查询窗口.
– 我运行生成的查询并尝试通过再次选择其他两个数据库和db_owner来映射用户角色,但我仍然收到与上面相同的错误消息.
思考？
