Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Where does Altiris store connect strings?

Created: 03 May 2013 • Updated: 03 May 2013 | 4 comments

So we're in a bit of a pickle, our one person who manages Altiris is out of the office and an instance refresh of our Altiris database (version 7, I think?) now points our dev environment to production. I looked through the entirety of the development db but didn't see anyplace that a connect string would be located. Is there something I'm overlooking? Where is the general place connect strings are located?

I appreciate any help that can be provided.

Operating Systems:

Comments 4 CommentsJump to latest comment

Marianne's picture

Moved this post from Storage and Clustering Community.
Not sure if this is the right forum, but probably more appropriate.

See this URL for list of Communities and Forums:

https://www-secure.symantec.com/connect/community-product-map

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

pete_4u2002's picture

it should be under SQL database called eXpress.

Run SQL Server Management Studio, connect to your SQL Server instance, expand Databases, expand your DS database (usually "eXpress") right-click on Views > New View.

HighTower's picture

"Express" is the default database name for Deployment Solution 6.x.  "Symantec_CMDB" is the default database name for the Symantec Management Platform for 7.x.

The SMP's database config can be found under Settings > Notification Server > Database Settings.  Here you can find servername\instance_name as well as the database name.

The Gaffer's picture

The connection string is built from values stored in the coresettings.config file which you will find under C:\ProgramData\Symantec\SMP\Settings.

There are five values stored for the db connection in this file:

  • DbServer
  • DbCatalog
  • DbUser
  • DbPassword
  • UseApplicationIdentity

The DbPassword value is encrypted.

To change the database used by the SMP you can follow HighTower's instructions and go to Settings > Notification Server > Database Settings in the console.

If you do not have access to the console, you can change the settings on the server using the aexconfig.exe command line tool. This tool is in the C:\Program Files\Altiris\Notification Server\bin folder.

The syntax is

aexconfig dbserver:<server name> dbname:<database name> dbusername:<db user n
ame> dbpassword:<db user password> dbtimeout:<db timeout>

Examples

To connect to the Symantec_CMDB database on a server called ATRSNS1, with the user "pippo" and password "password1"

aexconfig /db dbserver:ATRSNS1 dbname:Symantec_CMDB dbusername:pippo dbpassword:password1 dbtimeout:600

To connect to the Symantec_CMDB database on a server called ATRSNS2 using Integrated Security:

aexconfig /db dbserver:ATRSNS2 dbname:Symantec_CMDB dbusername: dbpassword: dbtimeout:600