Skip to main content
Planview Customer Success Center

How to reset userid and password for the Login Settings Utility??

If you wish to reset the Login Settings (ie. Start from Scratch), you can copy the Global.asa and Web.config files from the installation CD to the corresponding \Changepoint, \System Manager, and \Report Designer locations on your IIS server.

Then you will use uppercase "USERID" and "PASSWORD" as your login the first time. You will then need to enter a valid SQL admin userid and password for the Changepoint application.

OR

Easiest thing to do is this:

1. Run the Enable_SQL_Dependency.sql script on the Changepoint database -- there is one in your install folder. This will create a user called "CPSQLUser" with password "CPSQLUser". Change the password if you like before running against the database.

2. Overwrite the connection settings lines only in their web.config and global.asa files with the associated strings below. This will set the login settings passwords back to USERID/PASSWORD. Use the utility to get in and switch them to the one from step #1.

Enterprise web.config:

< add key="SQLSettings" value="server=SERVERNAME;database=DATABASENAME;trusted_connection=no;uid=USERID;pwd=PASSWORD" />

< add key="ReportsDSN" value="server=SERVERNAME;database=DATABASENAME;trusted_connection=no;uid=USERID;pwd=PASSWORD" />

Enterprise global.asa:

Session("dsn") = "provider=SQLOLEDB;app=CHANGEPOINT;server=SERVERNAME;uid=USERID;password=PASSWORD;database=Changepoint;Trusted_Connection=No"
Session("datadsn") = "data provider=SQLOLEDB;app=CHANGEPOINT;data source=SERVERNAME;server=SERVERNAME;uid=USERID;password=PASSWORD;database=Changepoint;Trusted_Connection=No"
Session("reportsdsn") = "provider=SQLOLEDB;app=CHANGEPOINT;server=SERVERNAME;uid=USERID;password=PASSWORD;database=Changepoint;Trusted_Connection=No;TimeOut=300"
Session("reportsdatadsn") = "data provider=SQLOLEDB;app=CHANGEPOINT;data source=SERVERNAME;server=SERVERNAME;uid=USERID;password=PASSWORD;database=Changepoint;Trusted_Connection=No;TimeOut=300"
Session("dsn2") = "driver={SQL Server};app=CHANGEPOINT;server=SERVERNAME;uid=USERID;password=PASSWORD;database=Changepoint;Trusted_Connection=No"

System Manager web.config:

< add key="SQLSettings" value="server=SERVERNAME;database=DATABASENAME;trusted_connection=no;uid=USERID;pwd=PASSWORD" />

System Manager global.asa:

Session("dsn") = "provider=SQLOLEDB;app=CHANGEPOINT;server=SERVERNAME;uid=USERID;password=PASSWORD;database=Changepoint;Trusted_Connection=No"
Session("datadsn") = "data provider=SQLOLEDB;app=CHANGEPOINT;data source=SERVERNAME;server=SERVERNAME;uid=USERID;password=PASSWORD;database=Changepoint;Trusted_Connection=No"
Session("reportsdsn") = "provider=SQLOLEDB;app=CHANGEPOINT;server=SERVERNAME;uid=USERID;password=PASSWORD;database=Changepoint;Trusted_Connection=No;TimeOut=300"
Session("reportsdatadsn") = "data provider=SQLOLEDB;app=CHANGEPOINT;data source=SERVERNAME;server=SERVERNAME;uid=USERID;password=PASSWORD;database=Changepoint;Trusted_Connection=No;TimeOut=300"
Session("dsn2") = "driver={SQL Server};app=CHANGEPOINT;server=SERVERNAME;uid=USERID;password=PASSWORD;database=Changepoint;Trusted_Connection=No"

Report Designer web.config:

< add key="SQLSettings" value="server=SERVERNAME;database=DATABASENAME;trusted_connection=no;uid=USERID;pwd=PASSWORD" />

 

Additional Notes

Please understand the above is an example. Depending on your Changepoint version, there might be more web.config files with SQLSettings (e.g. in the folders webapi and websockets in newer versions of Changepoint).