Symantec Management Platform (Notification Server)

Environment:-

What is the exact Notification Server Exact Version:   SMP 7.1

Service Pack of the Notification Server: SP1

What is the SQL database server version: 2008 R2

How many number of NS installed in the environment: 1

Is the SQL installed on the NS or is it on a remote server: remote server

Issue:-

 SA account in SQL which he use to install NS , now  wants to changed the SA account with new user for Symantec _CMDB.

created a new user in SQL db with all rights, changes also made in NS server under database setting saved with new user,

After that when customer make any changes in SA account like password change its also effect the NS console the NS fails to work, Symantec management error.

Its feels that NS has not left the SA account complete,

Troubleshoot steps :-

Database Reconfigure / Repaired, under database setting NS

also entered the new user in configuration file.

Still no success.

Hi niti,

Could you please post here the log error message (Altiris Log Viewer)?

Also you could check this configuration: Settings\All Settings\Notification Server\Database Settings\Reports tab that specify the credentials you would like to use for producing public reports.

I think you have the same issue: https://www-secure.symantec.com/connect/forums/change-sql-user

Regards,

What exactly is a public report? The settings mentions refer to credentials you would like to use for producing public reports but I can't anything further in the documentation.

Does this simply refer to the reports found in the Reports menu?

Hi Xeno,

This simply refer to reports found in the Reports menu and console areas.

The credentials configured at Database\Report tab generally have some rights on database (like read right) and it will avoid some danger situations like a user truncate a table using a sql query in Reports.

Regards,