Notifications
Clear all
Topic starter
I've never done a deployment before, but I'm wanting to learn so we don't have to pay our vendor $1,500 every time we need to upgrade. The included instructions I've found to be more than adequate; however I'm to the part of installing Jboss and it's asking for the "Application Logon and Password". I'm not sure what this is. I tried my normal CPS login but didn't work, tried the admin login for SQL but it says it's reserved. What else is there to try? Thanks in advance.
And for the record, I'm breaking things on our test server, after all, that's what it's there for, right? 😉
Posted : January 30, 2015 6:16 am
Try superuser...superuser and see if that works.
Posted : January 30, 2015 6:51 am
Topic starter
Good thought, but it didn't work 🙁 "Superuser cannot be logged into the test database on the server"
Posted : January 30, 2015 6:53 am
You can do installs and upgrades yourself. There are a few gotchas to watch out for during an upgrade. Have a rollback plan. Have a known good backup of your database prior to the upgrade. Disable the SQL agent. I was 4 hours into a major version upgrade when at the very end I had a database conflict with my SQL agent backup job. Ouch. Others are the install guide can be vague in areas.
I glanced at the installation guide. It doesn't say that the sa account is prohibited, but it's probably best practice.
I don't see anything in the server name field in your screenshot. If it is on the local machine, try adding "localhost" or "centricitytest" as the SQL server name.
Posted : January 30, 2015 7:08 am
Topic starter
Could you clarify the disable sql agent?
I removed the server name so no one tries to hack me lol
Posted : January 30, 2015 7:10 am
Application Login is a SQL user you will have to create that has access to your CPS Database, you use this for running CPS and JBOSS communicating with the DB.
Posted : January 30, 2015 7:29 am
Right click on SQL Server Agent in SSMS and select stop before you start your upgrade. It runs scheduled jobs that interact with the database.
[caption id="attachment_168395" align="alignnone" width="265"]
sql server agent[/caption]
Posted : January 30, 2015 9:29 am
Chris,
As ACANTU stated, you will have to go into SQL Server, create a SQL Server user account with full rights. Once that account is created, you can use that account as the Application Logon. Keep that info handy.
Posted : January 31, 2015 8:10 pm
The SA is the system admin account in SQL. Try to use something else (adminuser for example)
Posted : February 5, 2015 8:20 pm
as acantu say, you need to create an account in your sql that will server as the database read/write account between the Jboss and the database.
Go to your SQL management studio.
On the left side
you will have
-Database
-Security
-Server Objects
-Replication
-management
-SQL Server agent.
expand security-> right click on logins-> new Login->Click on the SQL server authentication ->
fill "Login name" with the desire user name-> uncheck enforce password policy, enforce password expiration and user must change password at next login. --> type your desire password and confirm it--> on your left side menu click user mapping--> check mark your cps database--> on the bottom windows on the same tab, check db_datawriter and db_datareader.--> click the ok button.
no, go back to where you were and use this account for that authentication.
Posted : February 13, 2015 5:45 am
