SIM 7.1 installation - initializing database

HP-UX、Linux、Tru64 UNIX、NonStop、OpenVMS、Windows Server等,数据中心、虚拟化方案等

版主: xyevolve

版面规则
1. 本版是定位于惠普软件系统及解决方案的技术讨论区。
2. 本版鼓励发帖共同讨论技术问题,不鼓励站内信件私下交流,独知知不如众知知。
3. 本版允许转贴或引用他人的作品,但必须声明原作者信息。
4. 本版禁止发表出售、求购、或其他非技术讨论等帖子。
5. 本版禁止灌水,包括但不限于任何与所讨论主题无关的回复,无意义字符,直接复制其他回复等。
6. 本站附件禁止用于商业目的,请在下载后24小时内删除,本站不对其造成的结果负任何责任。
回复
SYSTEM
网站编辑
帖子: 265
注册时间: 2012年 2月 20日 15:45 星期一

SIM 7.1 installation - initializing database

帖子 SYSTEM » 2012年 12月 12日 15:15 星期三

Mohammed 写了:During a sim installation with a remote sql server 2008 r2, its getting stuck at initializing database for more than an hour now.

Could that possibly be because of the rights given to the user on the database?

Can someone share the required database rights for SIM to work fine on a remote sql server.

Please note that the environment wont allow to have sysadmin right assignment.

SYSTEM
网站编辑
帖子: 265
注册时间: 2012年 2月 20日 15:45 星期一

Re: SIM 7.1 installation - initializing database

帖子 SYSTEM » 2012年 12月 12日 15:20 星期三

Sandeep 写了:SIM requires sysadmin privilege for installation. However post installation we can remove sysadmin privilege.

Please follow the steps below to minimize privileges post installation.

Configuration HPSIM to run with minimum privileges post installation

NOTE 1:
Ensure at least one user with SYSADMIN server role is present in SQL server. Otherwise you will not be able to connect back to SQL server. In case you have only one user with SYSADMIN (say admin) in SQL server then you must create another user (example myuser) with SYSADMIN before altering the current user (admin).

NOTE 2:
If “BUILTIN\Administrators” is added by default as Login user in our SQL server then you have to remove it. As all the users under this group will have SYSADMIN privilege by default.


Using SQL Server Management Studio

To remove “sysadmin” server role and enable “db_datareader” and “db_datawriter” database role
1. In Object Explorer, expand the server where you want to remove server role.
2. Expand the Security folder.
3. Expand the Logins folder.
4. Right-click on user (say administrator) you want to remove sysadmin server role and select Properties.
5. In Select a page Explorer, select the Server Roles and uncheck sysadmin Server Role.
1.png
6. In Select a page Explorer, select User Mapping
7. Select the database (say Insight_SIM71) in map column and in “database role membership” text box select db_datareader and db_datawriter
2.png
Using Transact-SQL

To remove “sysadmin” server role and enable “db_datareader” and “db_datawriter” database role
1. To remove SYSADMIN server role for a user (say 'SIM26\administrator') execute below Transact-SQL,

代码: 全选

EXEC sp_dropsrvrolemember 'SIM26\administrator', 'sysadmin'
2. To enable db_datareader and db_datawriter database role for a user (say 'SIM26\administrator') execute below Transact-SQL

代码: 全选

exec sp_addrolemember db_datareader, 'SIM26\administrator' 
exec sp_addrolemember db_datawriter , 'SIM26\administrator'
您没有权限查看这个主题的附件。

回复