{"id":8214,"date":"2015-01-05T16:28:24","date_gmt":"2015-01-05T08:28:24","guid":{"rendered":"http:\/\/w3c.weblink.com.tw\/symantec\/?p=8214"},"modified":"2015-01-05T16:34:42","modified_gmt":"2015-01-05T08:34:42","slug":"%e5%a6%82%e4%bd%95%e6%9b%b4%e6%94%b9-sdcs-sql-%e8%b3%87%e6%96%99%e5%ba%ab%e7%9a%84-dcs_ops-%e8%88%87-dcs_plugin-%e5%b8%b3%e8%99%9f%e7%9a%84%e5%af%86%e7%a2%bc","status":"publish","type":"post","link":"https:\/\/w3c.weblink.com.tw\/symantec\/?p=8214","title":{"rendered":"\u5982\u4f55\u66f4\u6539 SDCS SQL \u8cc7\u6599\u5eab\u7684 dcs_ops \u8207 dcs_plugin \u5e33\u865f\u7684\u5bc6\u78bc"},"content":{"rendered":"

\u201cHow can we change the DCS SQL DB dcs_ops and dcs_plugin account password? \u201c <\/p>\n

 <\/p>\n

Change password for dcs_ops<\/font> & dcs_plugin<\/font> on SQL server side <\/p>\n

\"image\"<\/a><\/p>\n

dcs_plugin change in password has no effect on product., as we don’t use this account on the Manager side <\/font><\/p>\n

\u203b(dcs_plugin \u7528\u4f86\u63d0\u4f9b 3-party \u7522\u54c1 (\u5982 SSIM\u3001ArcSight) \u8b80\u53d6\u8cc7\u6599\u5eab\u4f7f\u7528\uff0cSDCS \u6c92\u6709\u4f7f\u7528\u5230\u8a72\u5e33\u865f\uff0c\u53ef\u4efb\u610f\u4fee\u6539)<\/font><\/p>\n

Change dcs_ops<\/font> in passwrod will require the following changes to be done on Manager side <\/p>\n

1. Stop DCS manager service <\/p>\n

\"image\"<\/a>
2. Browse to “C:\\Program Files (x86)\\Symantec\\Data Center Security Server\\Server\\tomcat\\conf” <\/p>\n

\"image\"<\/a>
3. Backup server.xml
4. Edit server.xml <\/p>\n

\"image\"<\/a><\/p>\n

You can see the JDBC settings in the following: <\/p>\n

<Resource name=”Database-Console”
auth=”Container”
type=”javax.sql.DataSource”
url=”jdbc:jtds:sqlserver:\/\/127.0.0.1\/SCSPDB;instance=SCSP”
password=”xxxxxxxxxxxxxxxxxxx<\/font>”
username=”scsp_ops”
driverClassName=”net.sourceforge.jtds.jdbcx.JtdsDataSource”
initialSize=”10″
maxActive=”25″
maxIdle=”15″
maxWait=”-1″
minIdle=”10″
removeAbandoned=”true”
removeAbandonedTimeout=”300″
logAbandoned=”false”
\/>
<Resource name=”Database-Agent”
auth=”Container”
type=”javax.sql.DataSource”
url=”jdbc:jtds:sqlserver:\/\/127.0.0.1\/SCSPDB;instance=SCSP”
password=”xxxxxxxxxxxxxxxxxxxx<\/font>”
username=”scsp_ops”
driverClassName=”net.sourceforge.jtds.jdbcx.JtdsDataSource”
initialSize=”15″
maxActive=”45″
maxIdle=”20″
maxWait=”-1″
minIdle=”15″
removeAbandoned=”true”
removeAbandonedTimeout=”300″
logAbandoned=”false”
\/> <\/p>\n

5. Replace the text xxxxxxxxxxxx<\/font> with the new DCS-ops password, at both the locations
6. Then start the DCS manager service <\/p>\n

Also refer below article links for more clarity:
http:\/\/www.symantec.com\/connect\/forums\/csp-database<\/a>
http:\/\/www.symantec.com\/connect\/articles\/what-are-default-scsp-sql-database-accounts-and-what-are-they-used<\/a>
\u201c <\/p>\n","protected":false},"excerpt":{"rendered":"

\u201cHow can we change the DCS SQL DB dcs_ops and dcs_plugi … \u95b1\u8b80\u5168\u6587 \u5982\u4f55\u66f4\u6539 SDCS SQL \u8cc7\u6599\u5eab\u7684 dcs_ops \u8207 dcs_plugin \u5e33\u865f\u7684\u5bc6\u78bc<\/span><\/a><\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[120],"tags":[],"class_list":["post-8214","post","type-post","status-publish","format-standard","hentry","category-dcs-solution"],"_links":{"self":[{"href":"https:\/\/w3c.weblink.com.tw\/symantec\/index.php?rest_route=\/wp\/v2\/posts\/8214","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3c.weblink.com.tw\/symantec\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/w3c.weblink.com.tw\/symantec\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/w3c.weblink.com.tw\/symantec\/index.php?rest_route=\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/w3c.weblink.com.tw\/symantec\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8214"}],"version-history":[{"count":2,"href":"https:\/\/w3c.weblink.com.tw\/symantec\/index.php?rest_route=\/wp\/v2\/posts\/8214\/revisions"}],"predecessor-version":[{"id":8256,"href":"https:\/\/w3c.weblink.com.tw\/symantec\/index.php?rest_route=\/wp\/v2\/posts\/8214\/revisions\/8256"}],"wp:attachment":[{"href":"https:\/\/w3c.weblink.com.tw\/symantec\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3c.weblink.com.tw\/symantec\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8214"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/w3c.weblink.com.tw\/symantec\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}